[{"getBestRatedByHero":{"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 \"Hero.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.heroId = '3' 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":"Fiery Baxter Dolphin","authId":"","name":"Fiery Baxter Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Baxter Dolphin","authId":"","name":"Fiery Baxter Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"id":18247367,"name":"Ambush Thunder Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fiery/Baxter/Dolphin/18247367.jpg","createDate":{"time":1351005025000,"minutes":10,"seconds":25,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fiery/Baxter/Dolphin/18247367.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1251,"difficulty":2.4494293585202676,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2171,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.096694,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aerobic Antonio Octopus","authId":"","name":"Aerobic Antonio Octopus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aerobic Antonio Octopus","authId":"","name":"Aerobic Antonio Octopus","CNNId":"","myGameChains":null,"banStatus":null},"id":18486911,"name":"Nitro Adventure Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aerobic/Antonio/Octopus/18486911.jpg","createDate":{"time":1353010912000,"minutes":21,"seconds":52,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aerobic/Antonio/Octopus/18486911.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5118,"difficulty":1.3806823977181824,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5494,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.090493,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Lively Nick Umbrella","authId":"","name":"Lively Nick Umbrella","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lively Nick Umbrella","authId":"","name":"Lively Nick Umbrella","CNNId":"","myGameChains":null,"banStatus":null},"id":18256906,"name":"Assault Earth Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lively/Nick/Umbrella/18256906.jpg","createDate":{"time":1351115350000,"minutes":49,"seconds":10,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lively/Nick/Umbrella/18256906.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":678,"difficulty":2.3252202368665147,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13110,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.085448,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Scarlett Jinx","authId":"","name":"Generous Scarlett Jinx","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Scarlett Jinx","authId":"","name":"Generous Scarlett Jinx","CNNId":"","myGameChains":null,"banStatus":null},"id":18170620,"name":"Patrol Thunder Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Generous/Scarlett/Jinx/18170620.jpg","createDate":{"time":1350378041000,"minutes":0,"seconds":41,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Generous/Scarlett/Jinx/18170620.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1534,"difficulty":2.272321428571429,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2082,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.066667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Max Gamer","authId":"","name":"Colossal Max Gamer","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Max Gamer","authId":"","name":"Colossal Max Gamer","CNNId":"","myGameChains":null,"banStatus":null},"id":18089250,"name":"Adventure Omniverse Solar","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colossal/Max/Gamer/18089250.jpg","createDate":{"time":1349979677000,"minutes":21,"seconds":17,"hours":14,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colossal/Max/Gamer/18089250.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":139,"difficulty":2.354166666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1271,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.0625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Andre Jamboree","authId":"","name":"Immortal Andre Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Andre Jamboree","authId":"","name":"Immortal Andre Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"id":19198289,"name":"Blaster Rocket Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Immortal/Andre/Jamboree/19198289.jpg","createDate":{"time":1356539947000,"minutes":39,"seconds":7,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Immortal/Andre/Jamboree/19198289.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1850,"difficulty":2.4166666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2959,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.055746,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bright Kylie Acrobat","authId":"","name":"Bright Kylie Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bright Kylie Acrobat","authId":"","name":"Bright Kylie Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"id":19831704,"name":"Turbo Nova Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bright/Kylie/Acrobat/19831704.jpg","createDate":{"time":1363716248000,"minutes":4,"seconds":8,"hours":14,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bright/Kylie/Acrobat/19831704.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":52,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2343,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.047619,"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":"Graceful Juno Cipher","authId":"","name":"Graceful Juno Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Graceful Juno Cipher","authId":"","name":"Graceful Juno Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":18005074,"name":"Adventure Ben Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Graceful/Juno/Cipher/18005074.jpg","createDate":{"time":1349554600000,"minutes":16,"seconds":40,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Graceful/Juno/Cipher/18005074.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30583,"difficulty":2.485350240153352,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37624,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.015652,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Acoustic Alvin Trooper","authId":"","name":"Acoustic Alvin Trooper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Acoustic Alvin Trooper","authId":"","name":"Acoustic Alvin Trooper","CNNId":"","myGameChains":null,"banStatus":null},"id":18170636,"name":"Defense Turbo Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Acoustic/Alvin/Trooper/18170636.jpg","createDate":{"time":1350378628000,"minutes":10,"seconds":28,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Acoustic/Alvin/Trooper/18170636.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2391,"difficulty":2.2420120814857656,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5412,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.009885,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"91","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.heroId = '3' 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":"100","currentPageToDisplay":10,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]