[{"getMostShared":{"content":{"limit":200,"numberOfItemsPerPage":10,"pagesArray":["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20"],"count":199,"SQLFilter":null,"limitStatement":" AND ROWNUM <= 200","totalRecordsSQL":"Select count(*) as \"MostShared.count\" from (SELECT Game.id AS \"Game.id\",Player.name AS \"Game.creator.name\", Game.name AS \"Game.name\", Game.img AS \"Game.base64img\", Game.createDate AS \"Game.createDate\",GameStat.timesShared AS \"Game.statistic.timesShared\", GameStat.timesWon AS\"Game.statistic.timesWon\",GameStat.timesPlayed AS \"Game.statistic.timesPlayed\", ROUND(GameStat.rating,6) AS \"Game.statistic.rating\", GameStat.difficulty AS \"Game.statistic.difficulty\" FROM Game LEFT OUTER JOIN HERO ON Game.heroId = Hero.id LEFT OUTER JOIN GOAL ON Game.goalid = Goal.id LEFT OUTER JOIN GameStat ON Game.id = GameStat.gameid INNER JOIN Player ON Game.creatorId = Player.id AND game.id in (select gameid from (select gameid from game, GameStat where gamestat.timesShared > '5' AND Game.status = 1 AND Game.id = GameStat.gameid order by GameStat.timesShared desc) where rownum <= 200) ORDER BY Gamestat.timesshared DESC) ","list":[{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Charming Brian Blitz","authId":"","name":"Charming Brian Blitz","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Charming Brian Blitz","authId":"","name":"Charming Brian Blitz","CNNId":"","myGameChains":null,"banStatus":null},"id":6844692,"name":"Spidermonkey Mission Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Charming/Brian/Blitz/6844692.jpg","createDate":{"time":1224301744000,"minutes":49,"seconds":4,"hours":23,"month":9,"timezoneOffset":240,"year":108,"day":5,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Charming/Brian/Blitz/6844692.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13791,"difficulty":1.983521257652396,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":355175,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":225,"rating":2.674672,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Andrea Glop","authId":"","name":"Chilly Andrea Glop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Andrea Glop","authId":"","name":"Chilly Andrea Glop","CNNId":"","myGameChains":null,"banStatus":null},"id":5187094,"name":"Light Hero Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Chilly/Andrea/Glop/5187094.jpg","createDate":{"time":1216912191000,"minutes":9,"seconds":51,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Chilly/Andrea/Glop/5187094.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25712,"difficulty":1.2511849979566894,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":133464,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":224,"rating":1.736179,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Alex Crater","authId":"","name":"Gigantic Alex Crater","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Alex Crater","authId":"","name":"Gigantic Alex Crater","CNNId":"","myGameChains":null,"banStatus":null},"id":5187129,"name":"Robot Search Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gigantic/Alex/Crater/5187129.jpg","createDate":{"time":1216912261000,"minutes":11,"seconds":1,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gigantic/Alex/Crater/5187129.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":57304,"difficulty":1.4794588359838146,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":170537,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":223,"rating":2.489066,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Scary Reginald Igloo","authId":"","name":"Scary Reginald Igloo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scary Reginald Igloo","authId":"","name":"Scary Reginald Igloo","CNNId":"","myGameChains":null,"banStatus":null},"id":5186548,"name":"Ultra Shock Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scary/Reginald/Igloo/5186548.jpg","createDate":{"time":1216911389000,"minutes":56,"seconds":29,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scary/Reginald/Igloo/5186548.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":46907,"difficulty":2.328287532171497,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":455231,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":221,"rating":4.263091,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Carefree Rudolph Atlas","authId":"","name":"Carefree Rudolph Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Carefree Rudolph Atlas","authId":"","name":"Carefree Rudolph Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":16128042,"name":"Ultimate Waterhazard Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Carefree/Rudolph/Atlas/16128042.jpg","createDate":{"time":1315263808000,"minutes":3,"seconds":28,"hours":19,"month":8,"timezoneOffset":240,"year":111,"day":1,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Carefree/Rudolph/Atlas/16128042.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9803,"difficulty":2.8982495934351626,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":941215,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":220,"rating":4.619004,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Ivy Aurora","authId":"","name":"Fierce Ivy Aurora","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Ivy Aurora","authId":"","name":"Fierce Ivy Aurora","CNNId":"","myGameChains":null,"banStatus":null},"id":7507726,"name":"Ultimate Swampfire Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fierce/Ivy/Aurora/7507726.jpg","createDate":{"time":1228540748000,"minutes":19,"seconds":8,"hours":0,"month":11,"timezoneOffset":300,"year":108,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fierce/Ivy/Aurora/7507726.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":77,"difficulty":2.0105820105820107,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":557,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":219,"rating":4.816667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Diligent Ace Enigma","authId":"","name":"Diligent Ace Enigma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Diligent Ace Enigma","authId":"","name":"Diligent Ace Enigma","CNNId":"","myGameChains":null,"banStatus":null},"id":8947748,"name":"Dark Energy Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Diligent/Ace/Enigma/8947748.jpg","createDate":{"time":1236652794000,"minutes":39,"seconds":54,"hours":22,"month":2,"timezoneOffset":240,"year":109,"day":1,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Diligent/Ace/Enigma/8947748.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12714,"difficulty":2.8169772894015552,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":630369,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":219,"rating":4.438279,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Jada Jalapeno","authId":"","name":"Fearless Jada Jalapeno","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Jada Jalapeno","authId":"","name":"Fearless Jada Jalapeno","CNNId":"","myGameChains":null,"banStatus":null},"id":9086975,"name":"Brainstorm Warp Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearless/Jada/Jalapeno/9086975.jpg","createDate":{"time":1238108310000,"minutes":58,"seconds":30,"hours":18,"month":2,"timezoneOffset":240,"year":109,"day":4,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearless/Jada/Jalapeno/9086975.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8081,"difficulty":1.6502574846620093,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":289363,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":216,"rating":4.632221,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Clyde Dynamite","authId":"","name":"Silly Clyde Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Clyde Dynamite","authId":"","name":"Silly Clyde Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"id":6685703,"name":"Galaxy Hero Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silly/Clyde/Dynamite/6685703.jpg","createDate":{"time":1223697449000,"minutes":57,"seconds":29,"hours":23,"month":9,"timezoneOffset":240,"year":108,"day":5,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silly/Clyde/Dynamite/6685703.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":917,"difficulty":2.3948145369741844,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":524899,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":216,"rating":4.563421,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Daisy Bamboo","authId":"","name":"Western Daisy Bamboo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Daisy Bamboo","authId":"","name":"Western Daisy Bamboo","CNNId":"","myGameChains":null,"banStatus":null},"id":5187175,"name":"Energy Search Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Western/Daisy/Bamboo/5187175.jpg","createDate":{"time":1216912343000,"minutes":12,"seconds":23,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Western/Daisy/Bamboo/5187175.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3943,"difficulty":1.3347223692336463,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":207854,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":213,"rating":2.555468,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"91","sql":"SELECT Game.id AS \"Game.id\",Player.name AS \"Game.creator.name\", Game.name AS \"Game.name\", Game.img AS \"Game.base64img\", Game.createDate AS \"Game.createDate\",GameStat.timesShared AS \"Game.statistic.timesShared\", GameStat.timesWon AS\"Game.statistic.timesWon\",GameStat.timesPlayed AS \"Game.statistic.timesPlayed\", ROUND(GameStat.rating,6) AS \"Game.statistic.rating\", GameStat.difficulty AS \"Game.statistic.difficulty\" FROM Game LEFT OUTER JOIN HERO ON Game.heroId = Hero.id LEFT OUTER JOIN GOAL ON Game.goalid = Goal.id LEFT OUTER JOIN GameStat ON Game.id = GameStat.gameid INNER JOIN Player ON Game.creatorId = Player.id AND game.id in (select gameid from (select gameid from game, GameStat where gamestat.timesShared > '5' AND Game.status = 1 AND Game.id = GameStat.gameid order by GameStat.timesShared desc) where rownum <= 200) ORDER BY Gamestat.timesshared DESC","endRecordId":"100","currentPageToDisplay":10,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]