[{"getBestRatedByGoal":{"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":200,"SQLFilter":null,"limitStatement":" AND ROWNUM <= 200","totalRecordsSQL":"Select count(*) as \"Goal.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.goalId = '2' AND Game.status = 1 AND createdate BETWEEN SYSDATE-'280' AND SYSDATE AND GameStat.timesPlayed >= '0' AND GameStat.rating >= '0.0' AND Game.id = GameStat.gameid order by GameStat.timesPlayed desc) where rownum <= 200) ORDER BY Gamestat.rating DESC) ","list":[{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Carol Jupiter","authId":"","name":"Frugal Carol Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Carol Jupiter","authId":"","name":"Frugal Carol Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"id":19664271,"name":"Vilgax Laser Plumber","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frugal/Carol/Jupiter/19664271.jpg","createDate":{"time":1363023796000,"minutes":43,"seconds":16,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frugal/Carol/Jupiter/19664271.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9128,"difficulty":2.3926362690392255,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":67933,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.076064,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Vince Steel","authId":"","name":"Stealthy Vince Steel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Vince Steel","authId":"","name":"Stealthy Vince Steel","CNNId":"","myGameChains":null,"banStatus":null},"id":18976288,"name":"Solar Robot Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stealthy/Vince/Steel/18976288.jpg","createDate":{"time":1355478541000,"minutes":49,"seconds":1,"hours":4,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stealthy/Vince/Steel/18976288.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":79867,"difficulty":2.5697415250419087,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":114977,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.069324,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Lunar Lucius Gamer","authId":"","name":"Lunar Lucius Gamer","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lunar Lucius Gamer","authId":"","name":"Lunar Lucius Gamer","CNNId":"","myGameChains":null,"banStatus":null},"id":18707718,"name":"Champion Vilgax Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lunar/Lucius/Gamer/18707718.jpg","createDate":{"time":1354658596000,"minutes":3,"seconds":16,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lunar/Lucius/Gamer/18707718.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1946,"difficulty":2.2839956918081916,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7348,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.062566,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Classic Claire Kangaroo","authId":"","name":"Classic Claire Kangaroo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Classic Claire Kangaroo","authId":"","name":"Classic Claire Kangaroo","CNNId":"","myGameChains":null,"banStatus":null},"id":17793411,"name":"Ultimate Attack Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Classic/Claire/Kangaroo/17793411.jpg","createDate":{"time":1348719960000,"minutes":26,"seconds":0,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Classic/Claire/Kangaroo/17793411.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2772,"difficulty":2.3507559044488398,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31312,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.039757,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Emperor Chris Howler","authId":"","name":"Emperor Chris Howler","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Emperor Chris Howler","authId":"","name":"Emperor Chris Howler","CNNId":"","myGameChains":null,"banStatus":null},"id":17957141,"name":"Mega Charge Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Emperor/Chris/Howler/17957141.jpg","createDate":{"time":1349373103000,"minutes":51,"seconds":43,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Emperor/Chris/Howler/17957141.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":480,"difficulty":2.041743970315399,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":43949,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.020972,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Swift Danny Android","authId":"","name":"Swift Danny Android","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Swift Danny Android","authId":"","name":"Swift Danny Android","CNNId":"","myGameChains":null,"banStatus":null},"id":19831243,"name":"Big Big Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Swift/Danny/Android/19831243.jpg","createDate":{"time":1363713017000,"minutes":10,"seconds":17,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Swift/Danny/Android/19831243.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":341,"difficulty":2.8588590372998093,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27505,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.020131,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Hercules Isotope","authId":"","name":"Extreme Hercules Isotope","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Hercules Isotope","authId":"","name":"Extreme Hercules Isotope","CNNId":"","myGameChains":null,"banStatus":null},"id":18205385,"name":"Racer Light Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Hercules/Isotope/18205385.jpg","createDate":{"time":1350705731000,"minutes":2,"seconds":11,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Hercules/Isotope/18205385.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3341,"difficulty":2.2111626745483686,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":101327,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.018882,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Silent Heidi Dolphin","authId":"","name":"Silent Heidi Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silent Heidi Dolphin","authId":"","name":"Silent Heidi Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"id":19605395,"name":"Thunder Rumble Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silent/Heidi/Dolphin/19605395.jpg","createDate":{"time":1361861117000,"minutes":45,"seconds":17,"hours":1,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silent/Heidi/Dolphin/19605395.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4998,"difficulty":1.4684190988631323,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26616,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.017506,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Austin Deadbolt","authId":"","name":"Cackling Austin Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Austin Deadbolt","authId":"","name":"Cackling Austin Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"id":19385895,"name":"Doom Breaker Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cackling/Austin/Deadbolt/19385895.jpg","createDate":{"time":1358210939000,"minutes":48,"seconds":59,"hours":19,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cackling/Austin/Deadbolt/19385895.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13970,"difficulty":2.299204782398362,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":30849,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.002379,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Scary Will Tornado","authId":"","name":"Scary Will Tornado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scary Will Tornado","authId":"","name":"Scary Will Tornado","CNNId":"","myGameChains":null,"banStatus":null},"id":19721030,"name":"Kickin' Hawk Laser Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scary/Will/Tornado/19721030.jpg","createDate":{"time":1363258613000,"minutes":56,"seconds":53,"hours":6,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scary/Will/Tornado/19721030.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3238,"difficulty":2.370625046550818,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39394,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.984853,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"101","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.goalId = '2' AND Game.status = 1 AND createdate BETWEEN SYSDATE-'280' AND SYSDATE AND GameStat.timesPlayed >= '0' AND GameStat.rating >= '0.0' AND Game.id = GameStat.gameid order by GameStat.timesPlayed desc) where rownum <= 200) ORDER BY Gamestat.rating DESC","endRecordId":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]