[{"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":"Feisty Joseph Charger","authId":"","name":"Feisty Joseph Charger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Feisty Joseph Charger","authId":"","name":"Feisty Joseph Charger","CNNId":"","myGameChains":null,"banStatus":null},"id":5864998,"name":"Plasma Drone Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Feisty/Joseph/Charger/5864998.jpg","createDate":{"time":1218682714000,"minutes":58,"seconds":34,"hours":22,"month":7,"timezoneOffset":240,"year":108,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Feisty/Joseph/Charger/5864998.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12,"difficulty":2.881547444877729,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3969,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.88518,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghostly Shane Daffodil","authId":"","name":"Ghostly Shane Daffodil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghostly Shane Daffodil","authId":"","name":"Ghostly Shane Daffodil","CNNId":"","myGameChains":null,"banStatus":null},"id":8243512,"name":"Blaster Magno Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghostly/Shane/Daffodil/8243512.jpg","createDate":{"time":1231505241000,"minutes":47,"seconds":21,"hours":7,"month":0,"timezoneOffset":300,"year":109,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghostly/Shane/Daffodil/8243512.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1971,"difficulty":1.1684474343754123,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2878,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.884961,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Liam Ape","authId":"","name":"Famous Liam Ape","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Liam Ape","authId":"","name":"Famous Liam Ape","CNNId":"","myGameChains":null,"banStatus":null},"id":14242406,"name":"Challenge Nitro Nano","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Liam/Ape/14242406.jpg","createDate":{"time":1290527105000,"minutes":45,"seconds":5,"hours":10,"month":10,"timezoneOffset":300,"year":110,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Liam/Ape/14242406.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5661,"difficulty":2.868261215970673,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":657448,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":252,"rating":4.88491,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Ray Worm","authId":"","name":"Comical Ray Worm","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Ray Worm","authId":"","name":"Comical Ray Worm","CNNId":"","myGameChains":null,"banStatus":null},"id":10965369,"name":"Humongousaur Space Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Comical/Ray/Worm/10965369.jpg","createDate":{"time":1253698942000,"minutes":42,"seconds":22,"hours":5,"month":8,"timezoneOffset":240,"year":109,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Comical/Ray/Worm/10965369.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":465,"difficulty":2.356124027201532,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6284,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.884878,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Howling Bruce Cipher","authId":"","name":"Howling Bruce Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Howling Bruce Cipher","authId":"","name":"Howling Bruce Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":10882808,"name":"Shadow Invasion Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Howling/Bruce/Cipher/10882808.jpg","createDate":{"time":1252849435000,"minutes":43,"seconds":55,"hours":9,"month":8,"timezoneOffset":240,"year":109,"day":0,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Howling/Bruce/Cipher/10882808.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":381,"difficulty":2.1065746177149687,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8713,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.884409,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hideous Hugo Dragon","authId":"","name":"Hideous Hugo Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hideous Hugo Dragon","authId":"","name":"Hideous Hugo Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":8135798,"name":"Burst Galaxy Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hideous/Hugo/Dragon/8135798.jpg","createDate":{"time":1230830216000,"minutes":16,"seconds":56,"hours":12,"month":0,"timezoneOffset":300,"year":109,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hideous/Hugo/Dragon/8135798.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":629,"difficulty":2.7607017317536937,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5560,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.88423,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Variable Stephen Gumshoe","authId":"","name":"Variable Stephen Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Variable Stephen Gumshoe","authId":"","name":"Variable Stephen Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":13827459,"name":"Escape Quake Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Variable/Stephen/Gumshoe/13827459.jpg","createDate":{"time":1282456040000,"minutes":47,"seconds":20,"hours":1,"month":7,"timezoneOffset":240,"year":110,"day":0,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Variable/Stephen/Gumshoe/13827459.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10669,"difficulty":2.916024617739625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":112563,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":18,"rating":4.88413,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Chaotic Duncan Vampire","authId":"","name":"Chaotic Duncan Vampire","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Chaotic Duncan Vampire","authId":"","name":"Chaotic Duncan Vampire","CNNId":"","myGameChains":null,"banStatus":null},"id":6377777,"name":"Doom Search Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Chaotic/Duncan/Vampire/6377777.jpg","createDate":{"time":1221867114000,"minutes":31,"seconds":54,"hours":19,"month":8,"timezoneOffset":240,"year":108,"day":5,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Chaotic/Duncan/Vampire/6377777.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":213,"difficulty":2.4549644067213485,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5167,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.883949,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spooky Nick Narwhal","authId":"","name":"Spooky Nick Narwhal","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spooky Nick Narwhal","authId":"","name":"Spooky Nick Narwhal","CNNId":"","myGameChains":null,"banStatus":null},"id":11573659,"name":"Alien Fire Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spooky/Nick/Narwhal/11573659.jpg","createDate":{"time":1261252341000,"minutes":52,"seconds":21,"hours":14,"month":11,"timezoneOffset":300,"year":109,"day":6,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spooky/Nick/Narwhal/11573659.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":89,"difficulty":2.9025641025641025,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8019,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.883596,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Dana Rhino","authId":"","name":"Rowdy Dana Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Dana Rhino","authId":"","name":"Rowdy Dana Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":8235654,"name":"Hyper Laser Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rowdy/Dana/Rhino/8235654.jpg","createDate":{"time":1231421039000,"minutes":23,"seconds":59,"hours":8,"month":0,"timezoneOffset":300,"year":109,"day":4,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rowdy/Dana/Rhino/8235654.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":95,"difficulty":2.890625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2202,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.883333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"111","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":"120","currentPageToDisplay":12,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]