[{"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":"Wacky Minerva Phantom","authId":"","name":"Wacky Minerva Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Minerva Phantom","authId":"","name":"Wacky Minerva Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":10812860,"name":"Cosmic Crusher Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wacky/Minerva/Phantom/10812860.jpg","createDate":{"time":1252193246000,"minutes":27,"seconds":26,"hours":19,"month":8,"timezoneOffset":240,"year":109,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wacky/Minerva/Phantom/10812860.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":260,"difficulty":1.9867132867132866,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3263,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.892072,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Romeo Rhino","authId":"","name":"Organic Romeo Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Romeo Rhino","authId":"","name":"Organic Romeo Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":11640588,"name":"Challenge Invasion Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Organic/Romeo/Rhino/11640588.jpg","createDate":{"time":1261990057000,"minutes":47,"seconds":37,"hours":3,"month":11,"timezoneOffset":300,"year":109,"day":1,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Organic/Romeo/Rhino/11640588.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":665,"difficulty":2.8427182146416174,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12265,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":7,"rating":4.891809,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Ryan Grouch","authId":"","name":"Nomadic Ryan Grouch","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Ryan Grouch","authId":"","name":"Nomadic Ryan Grouch","CNNId":"","myGameChains":null,"banStatus":null},"id":11996875,"name":"Rocket Rock Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nomadic/Ryan/Grouch/11996875.jpg","createDate":{"time":1267679728000,"minutes":15,"seconds":28,"hours":0,"month":2,"timezoneOffset":300,"year":110,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nomadic/Ryan/Grouch/11996875.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":54,"difficulty":2.7774845813908313,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9777,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.891788,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Diego Dinosaur","authId":"","name":"Ultimate Diego Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Diego Dinosaur","authId":"","name":"Ultimate Diego Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":15939290,"name":"Waterhazard Waterhazard Waterhazard","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Diego/Dinosaur/15939290.jpg","createDate":{"time":1311081676000,"minutes":21,"seconds":16,"hours":9,"month":6,"timezoneOffset":240,"year":111,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Diego/Dinosaur/15939290.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":234,"difficulty":2.0308641975308643,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2554,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.891345,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Carter Blob","authId":"","name":"Chilly Carter Blob","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Carter Blob","authId":"","name":"Chilly Carter Blob","CNNId":"","myGameChains":null,"banStatus":null},"id":6252214,"name":"Spidermonkey Spike Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Chilly/Carter/Blob/6252214.jpg","createDate":{"time":1220704660000,"minutes":37,"seconds":40,"hours":8,"month":8,"timezoneOffset":240,"year":108,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Chilly/Carter/Blob/6252214.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":40,"difficulty":2.80331796782795,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4621,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":8,"rating":4.891252,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Homer Plasma","authId":"","name":"Ultimate Homer Plasma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Homer Plasma","authId":"","name":"Ultimate Homer Plasma","CNNId":"","myGameChains":null,"banStatus":null},"id":11959782,"name":"Champion Pursuit Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Homer/Plasma/11959782.jpg","createDate":{"time":1266923369000,"minutes":9,"seconds":29,"hours":6,"month":1,"timezoneOffset":300,"year":110,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Homer/Plasma/11959782.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":754,"difficulty":2.0251869342778432,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4537,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.891183,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Ben Fireball","authId":"","name":"Chilly Ben Fireball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Ben Fireball","authId":"","name":"Chilly Ben Fireball","CNNId":"","myGameChains":null,"banStatus":null},"id":7178095,"name":"Fusion Champion Light","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Chilly/Ben/Fireball/7178095.jpg","createDate":{"time":1226337400000,"minutes":16,"seconds":40,"hours":12,"month":10,"timezoneOffset":300,"year":108,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Chilly/Ben/Fireball/7178095.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":270,"difficulty":1.415151515151515,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2054,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.891156,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gleeful Xerxes Paradox","authId":"","name":"Gleeful Xerxes Paradox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gleeful Xerxes Paradox","authId":"","name":"Gleeful Xerxes Paradox","CNNId":"","myGameChains":null,"banStatus":null},"id":5887643,"name":"Sonic Steel Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gleeful/Xerxes/Paradox/5887643.jpg","createDate":{"time":1218782079000,"minutes":34,"seconds":39,"hours":2,"month":7,"timezoneOffset":240,"year":108,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gleeful/Xerxes/Paradox/5887643.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":57,"difficulty":2.902721207689517,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6931,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.891119,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ticklish Zoe Zeppelin","authId":"","name":"Ticklish Zoe Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ticklish Zoe Zeppelin","authId":"","name":"Ticklish Zoe Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"id":6455881,"name":"Siege Force Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ticklish/Zoe/Zeppelin/6455881.jpg","createDate":{"time":1222470297000,"minutes":4,"seconds":57,"hours":19,"month":8,"timezoneOffset":240,"year":108,"day":5,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ticklish/Zoe/Zeppelin/6455881.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":59,"difficulty":2.8379807692307693,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1625,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.891086,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Tara Gullet","authId":"","name":"Blue Tara Gullet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Tara Gullet","authId":"","name":"Blue Tara Gullet","CNNId":"","myGameChains":null,"banStatus":null},"id":6327177,"name":"Atomic Ultra Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Tara/Gullet/6327177.jpg","createDate":{"time":1221348440000,"minutes":27,"seconds":20,"hours":19,"month":8,"timezoneOffset":240,"year":108,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Tara/Gullet/6327177.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":487,"difficulty":1.8116819005075195,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3821,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.89101,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"71","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":"80","currentPageToDisplay":8,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]