[{"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":"Yellow Xavier Fireball","authId":"","name":"Yellow Xavier Fireball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Yellow Xavier Fireball","authId":"","name":"Yellow Xavier Fireball","CNNId":"","myGameChains":null,"banStatus":null},"id":11800232,"name":"Plumber Doom Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Yellow/Xavier/Fireball/11800232.jpg","createDate":{"time":1264359107000,"minutes":51,"seconds":47,"hours":13,"month":0,"timezoneOffset":300,"year":110,"day":0,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Yellow/Xavier/Fireball/11800232.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":52,"difficulty":2.9298418595293594,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2587,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.89619,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bizarre Ryan Creature","authId":"","name":"Bizarre Ryan Creature","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bizarre Ryan Creature","authId":"","name":"Bizarre Ryan Creature","CNNId":"","myGameChains":null,"banStatus":null},"id":8928213,"name":"Ultimate Swampfire Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bizarre/Ryan/Creature/8928213.jpg","createDate":{"time":1236487939000,"minutes":52,"seconds":19,"hours":23,"month":2,"timezoneOffset":300,"year":109,"day":6,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bizarre/Ryan/Creature/8928213.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":100,"difficulty":2.759259259259259,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2413,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.896111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Zeke Stampede","authId":"","name":"Alien Zeke Stampede","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Zeke Stampede","authId":"","name":"Alien Zeke Stampede","CNNId":"","myGameChains":null,"banStatus":null},"id":8106000,"name":"Ultra Ambush Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Zeke/Stampede/8106000.jpg","createDate":{"time":1230676984000,"minutes":43,"seconds":4,"hours":17,"month":11,"timezoneOffset":300,"year":108,"day":2,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Zeke/Stampede/8106000.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":233,"difficulty":1.9655549697216363,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2373,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.89599,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Tex Penguin","authId":"","name":"Crazy Tex Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Tex Penguin","authId":"","name":"Crazy Tex Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":16013064,"name":"Steel Attack Spidermonkey","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Tex/Penguin/16013064.jpg","createDate":{"time":1312568019000,"minutes":13,"seconds":39,"hours":14,"month":7,"timezoneOffset":240,"year":111,"day":5,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Tex/Penguin/16013064.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14,"difficulty":2.8557491481259687,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15714,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":9,"rating":4.895736,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Landon Glacier","authId":"","name":"Grizzly Landon Glacier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Landon Glacier","authId":"","name":"Grizzly Landon Glacier","CNNId":"","myGameChains":null,"banStatus":null},"id":11232285,"name":"Metal Iron Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grizzly/Landon/Glacier/11232285.jpg","createDate":{"time":1256738953000,"minutes":9,"seconds":13,"hours":10,"month":9,"timezoneOffset":240,"year":109,"day":3,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grizzly/Landon/Glacier/11232285.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":509,"difficulty":2.216160037348273,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8538,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.89571,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Elmer Glacier","authId":"","name":"Western Elmer Glacier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Elmer Glacier","authId":"","name":"Western Elmer Glacier","CNNId":"","myGameChains":null,"banStatus":null},"id":11175733,"name":"Blaster Laser Brainstorm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Western/Elmer/Glacier/11175733.jpg","createDate":{"time":1255943305000,"minutes":8,"seconds":25,"hours":5,"month":9,"timezoneOffset":240,"year":109,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Western/Elmer/Glacier/11175733.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":78,"difficulty":2.7775587507730366,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7395,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.895575,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Otis Viking","authId":"","name":"Jumping Otis Viking","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Otis Viking","authId":"","name":"Jumping Otis Viking","CNNId":"","myGameChains":null,"banStatus":null},"id":11777970,"name":"Warp Ben Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jumping/Otis/Viking/11777970.jpg","createDate":{"time":1264113647000,"minutes":40,"seconds":47,"hours":17,"month":0,"timezoneOffset":300,"year":110,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jumping/Otis/Viking/11777970.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2810,"difficulty":1.3678346444593845,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13969,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.89546,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful Beatrice Thunder","authId":"","name":"Powerful Beatrice Thunder","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful Beatrice Thunder","authId":"","name":"Powerful Beatrice Thunder","CNNId":"","myGameChains":null,"banStatus":null},"id":7219863,"name":"Ultra Sonic Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Powerful/Beatrice/Thunder/7219863.jpg","createDate":{"time":1226640588000,"minutes":29,"seconds":48,"hours":0,"month":10,"timezoneOffset":300,"year":108,"day":5,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Powerful/Beatrice/Thunder/7219863.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11,"difficulty":2.8410849567099565,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2993,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.895331,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Ed Pontoon","authId":"","name":"Stealthy Ed Pontoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Ed Pontoon","authId":"","name":"Stealthy Ed Pontoon","CNNId":"","myGameChains":null,"banStatus":null},"id":18521192,"name":"Atomic Energy Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stealthy/Ed/Pontoon/18521192.jpg","createDate":{"time":1353355283000,"minutes":1,"seconds":23,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stealthy/Ed/Pontoon/18521192.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22510,"difficulty":2.415957196482608,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1015644,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.895329,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Metallic Matthew Android","authId":"","name":"Metallic Matthew Android","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Metallic Matthew Android","authId":"","name":"Metallic Matthew Android","CNNId":"","myGameChains":null,"banStatus":null},"id":11563148,"name":"Slam Magno Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Metallic/Matthew/Android/11563148.jpg","createDate":{"time":1261151347000,"minutes":49,"seconds":7,"hours":10,"month":11,"timezoneOffset":300,"year":109,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Metallic/Matthew/Android/11563148.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4765,"difficulty":1.6256973636616785,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9208,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":6,"rating":4.895118,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"51","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":"60","currentPageToDisplay":6,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]