[{"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 = '11' 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":"Crispy Vinny Rhombus","authId":"","name":"Crispy Vinny Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Vinny Rhombus","authId":"","name":"Crispy Vinny Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"id":19331333,"name":"Power Nova Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crispy/Vinny/Rhombus/19331333.jpg","createDate":{"time":1357473135000,"minutes":52,"seconds":15,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crispy/Vinny/Rhombus/19331333.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2197,"difficulty":2.879988954586596,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31935,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.77338,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Adriana Martian","authId":"","name":"Edgy Adriana Martian","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Adriana Martian","authId":"","name":"Edgy Adriana Martian","CNNId":"","myGameChains":null,"banStatus":null},"id":17548354,"name":"Feedback Rescue Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Edgy/Adriana/Martian/17548354.jpg","createDate":{"time":1348167389000,"minutes":56,"seconds":29,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Edgy/Adriana/Martian/17548354.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4989,"difficulty":1.2626399004871118,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18938,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.770341,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Carefree Chrissie Bonkers","authId":"","name":"Carefree Chrissie Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Carefree Chrissie Bonkers","authId":"","name":"Carefree Chrissie Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"id":18469433,"name":"Search Echo Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Carefree/Chrissie/Bonkers/18469433.jpg","createDate":{"time":1352757445000,"minutes":57,"seconds":25,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Carefree/Chrissie/Bonkers/18469433.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10152,"difficulty":2.626144837536222,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":52981,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.755285,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"General Juliet Vortex","authId":"","name":"General Juliet Vortex","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"General Juliet Vortex","authId":"","name":"General Juliet Vortex","CNNId":"","myGameChains":null,"banStatus":null},"id":18247088,"name":"Spike Big Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/General/Juliet/Vortex/18247088.jpg","createDate":{"time":1351002159000,"minutes":22,"seconds":39,"hours":10,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"General/Juliet/Vortex/18247088.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":699,"difficulty":2.8999913135861215,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":192332,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.754483,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Rex Acorn","authId":"","name":"Flying Rex Acorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Rex Acorn","authId":"","name":"Flying Rex Acorn","CNNId":"","myGameChains":null,"banStatus":null},"id":17540128,"name":"Invasion Big Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Flying/Rex/Acorn/17540128.jpg","createDate":{"time":1348141475000,"minutes":44,"seconds":35,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Flying/Rex/Acorn/17540128.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6889,"difficulty":1.4282463197401039,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18861,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.749241,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Carolyn Starfish","authId":"","name":"Icy Carolyn Starfish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Carolyn Starfish","authId":"","name":"Icy Carolyn Starfish","CNNId":"","myGameChains":null,"banStatus":null},"id":19221755,"name":"Dark Hero Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Carolyn/Starfish/19221755.jpg","createDate":{"time":1356692595000,"minutes":3,"seconds":15,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Carolyn/Starfish/19221755.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3025,"difficulty":2.7022809395747336,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":20306,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.747407,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Negative Alvin Comet","authId":"","name":"Negative Alvin Comet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Negative Alvin Comet","authId":"","name":"Negative Alvin Comet","CNNId":"","myGameChains":null,"banStatus":null},"id":17548851,"name":"Adventure Feedback Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Negative/Alvin/Comet/17548851.jpg","createDate":{"time":1348168817000,"minutes":20,"seconds":17,"hours":15,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Negative/Alvin/Comet/17548851.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1178,"difficulty":2.504719699140676,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":54342,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.743559,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tricky Tyrone Thunder","authId":"","name":"Tricky Tyrone Thunder","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tricky Tyrone Thunder","authId":"","name":"Tricky Tyrone Thunder","CNNId":"","myGameChains":null,"banStatus":null},"id":19615313,"name":"Feedback Shock Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tricky/Tyrone/Thunder/19615313.jpg","createDate":{"time":1362142436000,"minutes":53,"seconds":56,"hours":7,"month":2,"timezoneOffset":300,"year":113,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tricky/Tyrone/Thunder/19615313.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":217,"difficulty":2.782771679376182,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":23722,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.742239,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironclad Jade Squid","authId":"","name":"Ironclad Jade Squid","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironclad Jade Squid","authId":"","name":"Ironclad Jade Squid","CNNId":"","myGameChains":null,"banStatus":null},"id":19436808,"name":"Target Star Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironclad/Jade/Squid/19436808.jpg","createDate":{"time":1359030711000,"minutes":31,"seconds":51,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironclad/Jade/Squid/19436808.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15996,"difficulty":1.4645357353392872,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29434,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.740668,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mystic Quincy Stampede","authId":"","name":"Mystic Quincy Stampede","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mystic Quincy Stampede","authId":"","name":"Mystic Quincy Stampede","CNNId":"","myGameChains":null,"banStatus":null},"id":17956019,"name":"Patrol Laser Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mystic/Quincy/Stampede/17956019.jpg","createDate":{"time":1349365176000,"minutes":39,"seconds":36,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mystic/Quincy/Stampede/17956019.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9185,"difficulty":2.700144939814239,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":105742,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.740666,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"21","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 = '11' 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":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]