[{"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":"Brawny Xerxes Dodo","authId":"","name":"Brawny Xerxes Dodo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brawny Xerxes Dodo","authId":"","name":"Brawny Xerxes Dodo","CNNId":"","myGameChains":null,"banStatus":null},"id":20001929,"name":"Feedback Dark Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brawny/Xerxes/Dodo/20001929.jpg","createDate":{"time":1364884410000,"minutes":33,"seconds":30,"hours":2,"month":3,"timezoneOffset":240,"year":113,"day":2,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brawny/Xerxes/Dodo/20001929.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":163,"difficulty":1.6458333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3847,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Jenna Swarm","authId":"","name":"Magnetic Jenna Swarm","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Jenna Swarm","authId":"","name":"Magnetic Jenna Swarm","CNNId":"","myGameChains":null,"banStatus":null},"id":19664653,"name":"Ambush Atomic Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Jenna/Swarm/19664653.jpg","createDate":{"time":1363024865000,"minutes":1,"seconds":5,"hours":14,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Jenna/Swarm/19664653.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":40716,"difficulty":2.544940038221052,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":337049,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.937014,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Misty Phantom","authId":"","name":"Loud Misty Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Misty Phantom","authId":"","name":"Loud Misty Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":7456511,"name":"Shock Dark Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Misty/Phantom/7456511.jpg","createDate":{"time":1228166343000,"minutes":19,"seconds":3,"hours":16,"month":11,"timezoneOffset":300,"year":108,"day":1,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Misty/Phantom/7456511.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22984,"difficulty":2.084579517356435,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":119726,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":24,"rating":4.924966,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Egbert Planet","authId":"","name":"Loyal Egbert Planet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Egbert Planet","authId":"","name":"Loyal Egbert Planet","CNNId":"","myGameChains":null,"banStatus":null},"id":8142667,"name":"Ultra Alien Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loyal/Egbert/Planet/8142667.jpg","createDate":{"time":1230847676000,"minutes":7,"seconds":56,"hours":17,"month":0,"timezoneOffset":300,"year":109,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loyal/Egbert/Planet/8142667.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2518,"difficulty":2.964775130197606,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":224781,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":376,"rating":4.921766,"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":6913464,"name":"Adventure Nano Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fizzy/Richard/Penguin/6913464.jpg","createDate":{"time":1224635698000,"minutes":34,"seconds":58,"hours":20,"month":9,"timezoneOffset":240,"year":108,"day":2,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fizzy/Richard/Penguin/6913464.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":875,"difficulty":2.4558259996109615,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":57828,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":20,"rating":4.919913,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Joshua Popcorn","authId":"","name":"Towering Joshua Popcorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Joshua Popcorn","authId":"","name":"Towering Joshua Popcorn","CNNId":"","myGameChains":null,"banStatus":null},"id":7261290,"name":"Drone Streak Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Towering/Joshua/Popcorn/7261290.jpg","createDate":{"time":1226932842000,"minutes":40,"seconds":42,"hours":9,"month":10,"timezoneOffset":300,"year":108,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Towering/Joshua/Popcorn/7261290.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2366,"difficulty":2.720856769682423,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12267,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":6,"rating":4.918152,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Valorous Dewey Donkey","authId":"","name":"Valorous Dewey Donkey","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Valorous Dewey Donkey","authId":"","name":"Valorous Dewey Donkey","CNNId":"","myGameChains":null,"banStatus":null},"id":19707366,"name":"Alien Mission Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Valorous/Dewey/Donkey/19707366.jpg","createDate":{"time":1363196202000,"minutes":36,"seconds":42,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Valorous/Dewey/Donkey/19707366.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16603,"difficulty":2.6279404723410624,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":159419,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.918023,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Egbert Planet","authId":"","name":"Loyal Egbert Planet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Egbert Planet","authId":"","name":"Loyal Egbert Planet","CNNId":"","myGameChains":null,"banStatus":null},"id":7975932,"name":"Universe Warrior Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loyal/Egbert/Planet/7975932.jpg","createDate":{"time":1230146239000,"minutes":17,"seconds":19,"hours":14,"month":11,"timezoneOffset":300,"year":108,"day":3,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loyal/Egbert/Planet/7975932.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":284,"difficulty":2.764609074116012,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10416,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":19,"rating":4.91758,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Expert Matthew Acrobat","authId":"","name":"Expert Matthew Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Expert Matthew Acrobat","authId":"","name":"Expert Matthew Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"id":11858775,"name":"Champion Doom Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Expert/Matthew/Acrobat/11858775.jpg","createDate":{"time":1265103265000,"minutes":34,"seconds":25,"hours":4,"month":1,"timezoneOffset":300,"year":110,"day":2,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Expert/Matthew/Acrobat/11858775.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":942,"difficulty":2.89080946136271,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":32692,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":15,"rating":4.917534,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Jesse Baloney","authId":"","name":"Fierce Jesse Baloney","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Jesse Baloney","authId":"","name":"Fierce Jesse Baloney","CNNId":"","myGameChains":null,"banStatus":null},"id":7540492,"name":"Droid Steel Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fierce/Jesse/Baloney/7540492.jpg","createDate":{"time":1228693699000,"minutes":48,"seconds":19,"hours":18,"month":11,"timezoneOffset":300,"year":108,"day":0,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fierce/Jesse/Baloney/7540492.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":815,"difficulty":2.4682841479982103,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14898,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.917418,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"1","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":"10","currentPageToDisplay":1,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]