[{"getMostPopularAllTime":{"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 \"MostPopular.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 Game.status = 1 AND GameStat.timesPlayed >= '1000' AND GameStat.rating >= '0.0' AND Game.id = GameStat.gameid order by GameStat.rating desc) where rownum <= 200) ORDER BY Gamestat.rating DESC) ","list":[{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"General Gregory Amoeba","authId":"","name":"General Gregory Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"General Gregory Amoeba","authId":"","name":"General Gregory Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"id":14525429,"name":"Ultimate Terraspin Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/General/Gregory/Amoeba/14525429.jpg","createDate":{"time":1291491282000,"minutes":34,"seconds":42,"hours":14,"month":11,"timezoneOffset":300,"year":110,"day":6,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"General/Gregory/Amoeba/14525429.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":311,"difficulty":2.970305923990436,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":332175,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":130,"rating":4.904748,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Richard Penguin","authId":"","name":"Fizzy Richard Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Richard Penguin","authId":"","name":"Fizzy Richard Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":6286279,"name":"Stone Razor Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fizzy/Richard/Penguin/6286279.jpg","createDate":{"time":1220905677000,"minutes":27,"seconds":57,"hours":16,"month":8,"timezoneOffset":240,"year":108,"day":1,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fizzy/Richard/Penguin/6286279.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":70,"difficulty":1.839795171908569,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4551,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.904674,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Andrew Alien","authId":"","name":"Sturdy Andrew Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Andrew Alien","authId":"","name":"Sturdy Andrew Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":16227392,"name":"Danger Storm Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sturdy/Andrew/Alien/16227392.jpg","createDate":{"time":1318271299000,"minutes":28,"seconds":19,"hours":14,"month":9,"timezoneOffset":240,"year":111,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sturdy/Andrew/Alien/16227392.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":588,"difficulty":1.6685964912280702,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4198,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.904619,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Hank Spark","authId":"","name":"Wild Hank Spark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Hank Spark","authId":"","name":"Wild Hank Spark","CNNId":"","myGameChains":null,"banStatus":null},"id":1995244,"name":"Turbo Challenge Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wild/Hank/Spark/1995244.jpg","createDate":{"time":1211670477000,"minutes":7,"seconds":57,"hours":19,"month":4,"timezoneOffset":240,"year":108,"day":6,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wild/Hank/Spark/1995244.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":166,"difficulty":2.6925719177498295,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15221,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.904031,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Larry Oddball","authId":"","name":"Atomic Larry Oddball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Larry Oddball","authId":"","name":"Atomic Larry Oddball","CNNId":"","myGameChains":null,"banStatus":null},"id":8918279,"name":"Siege Solar Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Larry/Oddball/8918279.jpg","createDate":{"time":1236449282000,"minutes":8,"seconds":2,"hours":13,"month":2,"timezoneOffset":300,"year":109,"day":6,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Larry/Oddball/8918279.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26,"difficulty":2.9852236652236654,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3407,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.903915,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Cody Phantom","authId":"","name":"Alien Cody Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Cody Phantom","authId":"","name":"Alien Cody Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":10764733,"name":"Universe Doom Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Cody/Phantom/10764733.jpg","createDate":{"time":1251661052000,"minutes":37,"seconds":32,"hours":15,"month":7,"timezoneOffset":240,"year":109,"day":0,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Cody/Phantom/10764733.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":610,"difficulty":2.8380764917082093,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12835,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.903733,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Richard Penguin","authId":"","name":"Fizzy Richard Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Richard Penguin","authId":"","name":"Fizzy Richard Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":6180453,"name":"Humongousaur Smash Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fizzy/Richard/Penguin/6180453.jpg","createDate":{"time":1220204252000,"minutes":37,"seconds":32,"hours":13,"month":7,"timezoneOffset":240,"year":108,"day":0,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fizzy/Richard/Penguin/6180453.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":773,"difficulty":1.378799756466481,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3703,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.903527,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Richard Penguin","authId":"","name":"Fizzy Richard Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Richard Penguin","authId":"","name":"Fizzy Richard Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":7059118,"name":"Lightning Search Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fizzy/Richard/Penguin/7059118.jpg","createDate":{"time":1225650056000,"minutes":20,"seconds":56,"hours":13,"month":10,"timezoneOffset":300,"year":108,"day":0,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fizzy/Richard/Penguin/7059118.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2,"difficulty":2.9705085508599773,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5724,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.902918,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Jason Hambone","authId":"","name":"Blue Jason Hambone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Jason Hambone","authId":"","name":"Blue Jason Hambone","CNNId":"","myGameChains":null,"banStatus":null},"id":10783575,"name":"Nova Attack Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Jason/Hambone/10783575.jpg","createDate":{"time":1251886762000,"minutes":19,"seconds":22,"hours":6,"month":8,"timezoneOffset":240,"year":109,"day":3,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Jason/Hambone/10783575.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":154,"difficulty":2.4412544878704963,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":28102,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":13,"rating":4.902842,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Absurd Madeline Alien","authId":"","name":"Absurd Madeline Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Absurd Madeline Alien","authId":"","name":"Absurd Madeline Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":11232309,"name":"Droid Smash Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Absurd/Madeline/Alien/11232309.jpg","createDate":{"time":1256739489000,"minutes":18,"seconds":9,"hours":10,"month":9,"timezoneOffset":240,"year":109,"day":3,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Absurd/Madeline/Alien/11232309.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":600,"difficulty":2.477195769548695,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14778,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":12,"rating":4.902514,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"21","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 Game.status = 1 AND GameStat.timesPlayed >= '1000' AND GameStat.rating >= '0.0' AND Game.id = GameStat.gameid order by GameStat.rating desc) where rownum <= 200) ORDER BY Gamestat.rating DESC","endRecordId":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]