[{"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 Jeremiah Monster","authId":"","name":"Fiery Jeremiah Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Jeremiah Monster","authId":"","name":"Fiery Jeremiah Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":18406458,"name":"Pursuit Nano Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fiery/Jeremiah/Monster/18406458.jpg","createDate":{"time":1352246405000,"minutes":0,"seconds":5,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fiery/Jeremiah/Monster/18406458.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":186,"difficulty":1.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3308,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.916667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Erik Acrobat","authId":"","name":"Cute Erik Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Erik Acrobat","authId":"","name":"Cute Erik Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"id":19545968,"name":"Adventure Fusion Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cute/Erik/Acrobat/19545968.jpg","createDate":{"time":1360967045000,"minutes":24,"seconds":5,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cute/Erik/Acrobat/19545968.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5596,"difficulty":2.683528748610803,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8756,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.851622,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Titanic Finn Sludge","authId":"","name":"Titanic Finn Sludge","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Titanic Finn Sludge","authId":"","name":"Titanic Finn Sludge","CNNId":"","myGameChains":null,"banStatus":null},"id":19589226,"name":"Dark Blaster Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Titanic/Finn/Sludge/19589226.jpg","createDate":{"time":1361625017000,"minutes":10,"seconds":17,"hours":8,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Titanic/Finn/Sludge/19589226.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":624,"difficulty":1.9330698860454911,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8640,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.842464,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Jaden Gong","authId":"","name":"Aromatic Jaden Gong","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Jaden Gong","authId":"","name":"Aromatic Jaden Gong","CNNId":"","myGameChains":null,"banStatus":null},"id":19895698,"name":"Light Clash Giga","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aromatic/Jaden/Gong/19895698.jpg","createDate":{"time":1364144178000,"minutes":56,"seconds":18,"hours":12,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aromatic/Jaden/Gong/19895698.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1971,"difficulty":2.5780132511729006,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61336,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.803659,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shady Dwight Runner","authId":"","name":"Shady Dwight Runner","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shady Dwight Runner","authId":"","name":"Shady Dwight Runner","CNNId":"","myGameChains":null,"banStatus":null},"id":19549287,"name":"Fury Droid Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shady/Dwight/Runner/19549287.jpg","createDate":{"time":1361017694000,"minutes":28,"seconds":14,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shady/Dwight/Runner/19549287.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":489,"difficulty":1.218694885361552,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5340,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.789116,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic CJ Bazooka","authId":"","name":"Atomic CJ Bazooka","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic CJ Bazooka","authId":"","name":"Atomic CJ Bazooka","CNNId":"","myGameChains":null,"banStatus":null},"id":19565301,"name":"Doom Alien Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/CJ/Bazooka/19565301.jpg","createDate":{"time":1361209150000,"minutes":39,"seconds":10,"hours":12,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/CJ/Bazooka/19565301.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5214,"difficulty":2.479684568028002,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":20542,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.775615,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Devon Ladybug","authId":"","name":"Shy Devon Ladybug","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Devon Ladybug","authId":"","name":"Shy Devon Ladybug","CNNId":"","myGameChains":null,"banStatus":null},"id":17209301,"name":"Jetray Sonic Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shy/Devon/Ladybug/17209301.jpg","createDate":{"time":1341994933000,"minutes":22,"seconds":13,"hours":4,"month":6,"timezoneOffset":240,"year":112,"day":3,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shy/Devon/Ladybug/17209301.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":349,"difficulty":2.422531016736991,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7718,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.772878,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Collin Kungfu","authId":"","name":"Keen Collin Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Collin Kungfu","authId":"","name":"Keen Collin Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"id":19580355,"name":"Adventure Universe Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Keen/Collin/Kungfu/19580355.jpg","createDate":{"time":1361472974000,"minutes":56,"seconds":14,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Keen/Collin/Kungfu/19580355.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":986,"difficulty":1.8553402482591972,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18193,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.763848,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Yancy Panda","authId":"","name":"Fiery Yancy Panda","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Yancy Panda","authId":"","name":"Fiery Yancy Panda","CNNId":"","myGameChains":null,"banStatus":null},"id":19472353,"name":"Jetray Doom Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fiery/Yancy/Panda/19472353.jpg","createDate":{"time":1359640878000,"minutes":1,"seconds":18,"hours":9,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fiery/Yancy/Panda/19472353.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1812,"difficulty":1.9259480103230102,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4078,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.694482,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Albert Brick","authId":"","name":"Average Albert Brick","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Albert Brick","authId":"","name":"Average Albert Brick","CNNId":"","myGameChains":null,"banStatus":null},"id":19128799,"name":"Water Robot Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Average/Albert/Brick/19128799.jpg","createDate":{"time":1356197975000,"minutes":39,"seconds":35,"hours":12,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Average/Albert/Brick/19128799.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5605,"difficulty":1.772673764297887,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":32195,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.681409,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"161","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":"170","currentPageToDisplay":17,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]