[{"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":"Electric Nelson Hydra","authId":"","name":"Electric Nelson Hydra","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Nelson Hydra","authId":"","name":"Electric Nelson Hydra","CNNId":"","myGameChains":null,"banStatus":null},"id":14319621,"name":"Iron Robot Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Nelson/Hydra/14319621.jpg","createDate":{"time":1290700188000,"minutes":49,"seconds":48,"hours":10,"month":10,"timezoneOffset":300,"year":110,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Nelson/Hydra/14319621.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":134036,"difficulty":2.4884340136672014,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":436406,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":261,"rating":4.877849,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Tom Ketchup","authId":"","name":"Gigantic Tom Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Tom Ketchup","authId":"","name":"Gigantic Tom Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"id":152108,"name":"Warrior Swampfire Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images/152108_050620080425.jpg","createDate":{"time":1210100673000,"minutes":4,"seconds":33,"hours":15,"month":4,"timezoneOffset":240,"year":108,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"152108_050620080425.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28791,"difficulty":1.405340405530943,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":125807,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":196,"rating":4.877607,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cranky Rex Sphinx","authId":"","name":"Cranky Rex Sphinx","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cranky Rex Sphinx","authId":"","name":"Cranky Rex Sphinx","CNNId":"","myGameChains":null,"banStatus":null},"id":8087607,"name":"Cosmic Dark Danger","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cranky/Rex/Sphinx/8087607.jpg","createDate":{"time":1230589576000,"minutes":26,"seconds":16,"hours":17,"month":11,"timezoneOffset":300,"year":108,"day":1,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cranky/Rex/Sphinx/8087607.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":292,"difficulty":1.9004419703103912,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1638,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.877342,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Beastly Dakota Mahogany","authId":"","name":"Beastly Dakota Mahogany","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Beastly Dakota Mahogany","authId":"","name":"Beastly Dakota Mahogany","CNNId":"","myGameChains":null,"banStatus":null},"id":8272001,"name":"Beast Warp Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Beastly/Dakota/Mahogany/8272001.jpg","createDate":{"time":1231641892000,"minutes":44,"seconds":52,"hours":21,"month":0,"timezoneOffset":300,"year":109,"day":6,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Beastly/Dakota/Mahogany/8272001.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6,"difficulty":2.6941445938174176,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3407,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.877323,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Chad Behemoth","authId":"","name":"Alien Chad Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Chad Behemoth","authId":"","name":"Alien Chad Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"id":7156130,"name":"Pulse Power Nova","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Chad/Behemoth/7156130.jpg","createDate":{"time":1226204978000,"minutes":29,"seconds":38,"hours":23,"month":10,"timezoneOffset":300,"year":108,"day":6,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Chad/Behemoth/7156130.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":113,"difficulty":2.6515151515151514,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4083,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.877254,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Modest Sierra Crowbar","authId":"","name":"Modest Sierra Crowbar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Modest Sierra Crowbar","authId":"","name":"Modest Sierra Crowbar","CNNId":"","myGameChains":null,"banStatus":null},"id":10725222,"name":"Hero Sonic Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Modest/Sierra/Crowbar/10725222.jpg","createDate":{"time":1251223555000,"minutes":5,"seconds":55,"hours":14,"month":7,"timezoneOffset":240,"year":109,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Modest/Sierra/Crowbar/10725222.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":80,"difficulty":2.664255189255189,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5018,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":5,"rating":4.87678,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Musical Chloe Orchid","authId":"","name":"Musical Chloe Orchid","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Musical Chloe Orchid","authId":"","name":"Musical Chloe Orchid","CNNId":"","myGameChains":null,"banStatus":null},"id":8461394,"name":"Rescue Animo Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Musical/Chloe/Orchid/8461394.jpg","createDate":{"time":1232982599000,"minutes":9,"seconds":59,"hours":10,"month":0,"timezoneOffset":300,"year":109,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Musical/Chloe/Orchid/8461394.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":375,"difficulty":1.7936892736892738,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1415,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.876747,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dramatic Johnny Magma","authId":"","name":"Dramatic Johnny Magma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dramatic Johnny Magma","authId":"","name":"Dramatic Johnny Magma","CNNId":"","myGameChains":null,"banStatus":null},"id":3051969,"name":"Fire Rush Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dramatic/Johnny/Magma/3051969.jpg","createDate":{"time":1212979220000,"minutes":40,"seconds":20,"hours":22,"month":5,"timezoneOffset":240,"year":108,"day":0,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dramatic/Johnny/Magma/3051969.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":279,"difficulty":2.825359719627736,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5864,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":7,"rating":4.876587,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Chaotic Wolfgang Clang","authId":"","name":"Chaotic Wolfgang Clang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Chaotic Wolfgang Clang","authId":"","name":"Chaotic Wolfgang Clang","CNNId":"","myGameChains":null,"banStatus":null},"id":5485356,"name":"Ultimate Charge Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Chaotic/Wolfgang/Clang/5485356.jpg","createDate":{"time":1217634736000,"minutes":52,"seconds":16,"hours":19,"month":7,"timezoneOffset":240,"year":108,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Chaotic/Wolfgang/Clang/5485356.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":52,"difficulty":2.3606238052604835,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2635,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.876585,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty Vicky Monster","authId":"","name":"Sporty Vicky Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty Vicky Monster","authId":"","name":"Sporty Vicky Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":10655634,"name":"Doom Rocket Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sporty/Vicky/Monster/10655634.jpg","createDate":{"time":1250604812000,"minutes":13,"seconds":32,"hours":10,"month":7,"timezoneOffset":240,"year":109,"day":2,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sporty/Vicky/Monster/10655634.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":475,"difficulty":2.302240338330564,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10088,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.876394,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"151","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":"160","currentPageToDisplay":16,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]