[{"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":"Magnetic Michael Chaos","authId":"","name":"Magnetic Michael Chaos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Michael Chaos","authId":"","name":"Magnetic Michael Chaos","CNNId":"","myGameChains":null,"banStatus":null},"id":17622777,"name":"Racer Rush Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Michael/Chaos/17622777.jpg","createDate":{"time":1348315790000,"minutes":9,"seconds":50,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Michael/Chaos/17622777.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":110,"difficulty":1.8736111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2754,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.266667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Roscoe Yoyo","authId":"","name":"Nifty Roscoe Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Roscoe Yoyo","authId":"","name":"Nifty Roscoe Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":19520621,"name":"Ultimate Humungousaur Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nifty/Roscoe/Yoyo/19520621.jpg","createDate":{"time":1360495749000,"minutes":29,"seconds":9,"hours":6,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nifty/Roscoe/Yoyo/19520621.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2081,"difficulty":2.688712522045855,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2660,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.261378,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Hunter Calliope","authId":"","name":"Luminous Hunter Calliope","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Hunter Calliope","authId":"","name":"Luminous Hunter Calliope","CNNId":"","myGameChains":null,"banStatus":null},"id":19874433,"name":"Ultimate Turbo Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Luminous/Hunter/Calliope/19874433.jpg","createDate":{"time":1364044284000,"minutes":11,"seconds":24,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Luminous/Hunter/Calliope/19874433.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":409,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Duke Penny Gumshoe","authId":"","name":"Duke Penny Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Duke Penny Gumshoe","authId":"","name":"Duke Penny Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":18558142,"name":"Ben Power Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Duke/Penny/Gumshoe/18558142.jpg","createDate":{"time":1353626670000,"minutes":24,"seconds":30,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Duke/Penny/Gumshoe/18558142.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11,"difficulty":2.4444444444444446,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":754,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Rex Parsnip","authId":"","name":"Elite Rex Parsnip","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Rex Parsnip","authId":"","name":"Elite Rex Parsnip","CNNId":"","myGameChains":null,"banStatus":null},"id":18929908,"name":"Rustbucket Universe Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/Rex/Parsnip/18929908.jpg","createDate":{"time":1355222557000,"minutes":42,"seconds":37,"hours":5,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/Rex/Parsnip/18929908.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":48,"difficulty":1.8888888888888888,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":530,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Talented Harry Apple","authId":"","name":"Talented Harry Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Talented Harry Apple","authId":"","name":"Talented Harry Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":18260145,"name":"Rock Galaxy Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Talented/Harry/Apple/18260145.jpg","createDate":{"time":1351150469000,"minutes":34,"seconds":29,"hours":3,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Talented/Harry/Apple/18260145.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":24,"difficulty":1.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":560,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Timmy Neptune","authId":"","name":"Superb Timmy Neptune","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Timmy Neptune","authId":"","name":"Superb Timmy Neptune","CNNId":"","myGameChains":null,"banStatus":null},"id":19208414,"name":"Rampage Danger Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superb/Timmy/Neptune/19208414.jpg","createDate":{"time":1356613604000,"minutes":6,"seconds":44,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superb/Timmy/Neptune/19208414.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":83,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":382,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Timmy Turbo","authId":"","name":"Zany Timmy Turbo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Timmy Turbo","authId":"","name":"Zany Timmy Turbo","CNNId":"","myGameChains":null,"banStatus":null},"id":19391547,"name":"Mission Razor Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zany/Timmy/Turbo/19391547.jpg","createDate":{"time":1358337236000,"minutes":53,"seconds":56,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zany/Timmy/Turbo/19391547.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6544,"difficulty":2.7181706267953554,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":50962,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.225282,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Joseph Yam","authId":"","name":"Cartoony Joseph Yam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Joseph Yam","authId":"","name":"Cartoony Joseph Yam","CNNId":"","myGameChains":null,"banStatus":null},"id":18783604,"name":"Siege Energy Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cartoony/Joseph/Yam/18783604.jpg","createDate":{"time":1354913119000,"minutes":45,"seconds":19,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cartoony/Joseph/Yam/18783604.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27,"difficulty":2.502116402116402,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1496,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.188095,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Humorous Chuck Nacho","authId":"","name":"Humorous Chuck Nacho","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humorous Chuck Nacho","authId":"","name":"Humorous Chuck Nacho","CNNId":"","myGameChains":null,"banStatus":null},"id":17954028,"name":"Energy Galaxy Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humorous/Chuck/Nacho/17954028.jpg","createDate":{"time":1349347577000,"minutes":46,"seconds":17,"hours":6,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humorous/Chuck/Nacho/17954028.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":189,"difficulty":1.6,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1233,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.1875,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"71","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":"80","currentPageToDisplay":8,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]