[{"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 = '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":"Duchess Gus Tsunami","authId":"","name":"Duchess Gus Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Duchess Gus Tsunami","authId":"","name":"Duchess Gus Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"id":18089288,"name":"Mega Adventure Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Duchess/Gus/Tsunami/18089288.jpg","createDate":{"time":1349979860000,"minutes":24,"seconds":20,"hours":14,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Duchess/Gus/Tsunami/18089288.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5565,"difficulty":1.3369946278715181,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7503,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.027175,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Sophia Gorilla","authId":"","name":"Captain Sophia Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Sophia Gorilla","authId":"","name":"Captain Sophia Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"id":18206823,"name":"Warp Doom Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Sophia/Gorilla/18206823.jpg","createDate":{"time":1350720236000,"minutes":3,"seconds":56,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Sophia/Gorilla/18206823.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":146,"difficulty":1.8333333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":736,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.02,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Titanic Ursula Gulch","authId":"","name":"Titanic Ursula Gulch","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Titanic Ursula Gulch","authId":"","name":"Titanic Ursula Gulch","CNNId":"","myGameChains":null,"banStatus":null},"id":17793332,"name":"Plasma Light Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Titanic/Ursula/Gulch/17793332.jpg","createDate":{"time":1348719055000,"minutes":10,"seconds":55,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Titanic/Ursula/Gulch/17793332.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":751,"difficulty":1.5963955026455026,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2821,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.000902,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Healthy Scooby Zip","authId":"","name":"Healthy Scooby Zip","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Healthy Scooby Zip","authId":"","name":"Healthy Scooby Zip","CNNId":"","myGameChains":null,"banStatus":null},"id":18408769,"name":"Burst Chase Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Healthy/Scooby/Zip/18408769.jpg","createDate":{"time":1352264752000,"minutes":5,"seconds":52,"hours":0,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Healthy/Scooby/Zip/18408769.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":172,"difficulty":1.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":542,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Robin Deadbolt","authId":"","name":"Average Robin Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Robin Deadbolt","authId":"","name":"Average Robin Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"id":18116396,"name":"Smash Robot Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Average/Robin/Deadbolt/18116396.jpg","createDate":{"time":1350128971000,"minutes":49,"seconds":31,"hours":7,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Average/Robin/Deadbolt/18116396.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15,"difficulty":2.4444444444444446,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":344,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Wyatt Enigma","authId":"","name":"Doctor Wyatt Enigma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Wyatt Enigma","authId":"","name":"Doctor Wyatt Enigma","CNNId":"","myGameChains":null,"banStatus":null},"id":18640312,"name":"Universe Universe Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Doctor/Wyatt/Enigma/18640312.jpg","createDate":{"time":1354303002000,"minutes":16,"seconds":42,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Doctor/Wyatt/Enigma/18640312.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":108,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":386,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Gregory Meteor","authId":"","name":"Elite Gregory Meteor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Gregory Meteor","authId":"","name":"Elite Gregory Meteor","CNNId":"","myGameChains":null,"banStatus":null},"id":18285980,"name":"Chase Adventure Plumber","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/Gregory/Meteor/18285980.jpg","createDate":{"time":1351352772000,"minutes":46,"seconds":12,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/Gregory/Meteor/18285980.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":64,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":409,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Paul Mastodon","authId":"","name":"Immortal Paul Mastodon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Paul Mastodon","authId":"","name":"Immortal Paul Mastodon","CNNId":"","myGameChains":null,"banStatus":null},"id":18286847,"name":"Rocket Escape Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Immortal/Paul/Mastodon/18286847.jpg","createDate":{"time":1351355891000,"minutes":38,"seconds":11,"hours":12,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Immortal/Paul/Mastodon/18286847.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":104,"difficulty":1.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":493,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Intrepid Dewey Cupcake","authId":"","name":"Intrepid Dewey Cupcake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Intrepid Dewey Cupcake","authId":"","name":"Intrepid Dewey Cupcake","CNNId":"","myGameChains":null,"banStatus":null},"id":17686829,"name":"Humungousaur Galaxy Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Intrepid/Dewey/Cupcake/17686829.jpg","createDate":{"time":1348389463000,"minutes":37,"seconds":43,"hours":4,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Intrepid/Dewey/Cupcake/17686829.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5256,"difficulty":1.6828974595382795,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":122937,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":1.99282,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fragrant Rocky Flamingo","authId":"","name":"Fragrant Rocky Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fragrant Rocky Flamingo","authId":"","name":"Fragrant Rocky Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"id":18930578,"name":"Robot Hyper Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fragrant/Rocky/Flamingo/18930578.jpg","createDate":{"time":1355229321000,"minutes":35,"seconds":21,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fragrant/Rocky/Flamingo/18930578.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9316,"difficulty":1.3274987425572649,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10452,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.960579,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"181","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 = '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":"190","currentPageToDisplay":19,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]