[{"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 = '16' 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":"Academic Brooklyn Jungle","authId":"","name":"Academic Brooklyn Jungle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Brooklyn Jungle","authId":"","name":"Academic Brooklyn Jungle","CNNId":"","myGameChains":null,"banStatus":null},"id":19684422,"name":"Kickin' Hawk Pursuit Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Brooklyn/Jungle/19684422.jpg","createDate":{"time":1363101832000,"minutes":23,"seconds":52,"hours":11,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Brooklyn/Jungle/19684422.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":51,"difficulty":2.6304464766003224,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1984,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.628307,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Cody Magma","authId":"","name":"Virtual Cody Magma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Cody Magma","authId":"","name":"Virtual Cody Magma","CNNId":"","myGameChains":null,"banStatus":null},"id":19760099,"name":"Shock Humungousaur Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Virtual/Cody/Magma/19760099.jpg","createDate":{"time":1363434897000,"minutes":54,"seconds":57,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Virtual/Cody/Magma/19760099.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":367,"difficulty":2.4219504178228646,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11082,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.622034,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Itchy Natasha Calamari","authId":"","name":"Itchy Natasha Calamari","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Itchy Natasha Calamari","authId":"","name":"Itchy Natasha Calamari","CNNId":"","myGameChains":null,"banStatus":null},"id":19686594,"name":"Search Nitro Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Itchy/Natasha/Calamari/19686594.jpg","createDate":{"time":1363109375000,"minutes":29,"seconds":35,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Itchy/Natasha/Calamari/19686594.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1237,"difficulty":2.454413597647894,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15765,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.614365,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Aaron Jamboree","authId":"","name":"Amazing Aaron Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Aaron Jamboree","authId":"","name":"Amazing Aaron Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"id":19670799,"name":"Alien Iron Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amazing/Aaron/Jamboree/19670799.jpg","createDate":{"time":1363039283000,"minutes":1,"seconds":23,"hours":18,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amazing/Aaron/Jamboree/19670799.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":216,"difficulty":1.8591911577234361,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4844,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.607482,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Handsome Hailey Hawk","authId":"","name":"Handsome Hailey Hawk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Handsome Hailey Hawk","authId":"","name":"Handsome Hailey Hawk","CNNId":"","myGameChains":null,"banStatus":null},"id":19906796,"name":"Laser Ben Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Handsome/Hailey/Hawk/19906796.jpg","createDate":{"time":1364218918000,"minutes":41,"seconds":58,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Handsome/Hailey/Hawk/19906796.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":648,"difficulty":2.4285714285714284,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1457,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.6,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious DJ Skeleton","authId":"","name":"Glorious DJ Skeleton","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious DJ Skeleton","authId":"","name":"Glorious DJ Skeleton","CNNId":"","myGameChains":null,"banStatus":null},"id":19668823,"name":"Sonic Giga Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Glorious/DJ/Skeleton/19668823.jpg","createDate":{"time":1363035487000,"minutes":58,"seconds":7,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Glorious/DJ/Skeleton/19668823.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":244,"difficulty":2.798673385628352,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":48089,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.599042,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Zach Banzai","authId":"","name":"Awesome Zach Banzai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Zach Banzai","authId":"","name":"Awesome Zach Banzai","CNNId":"","myGameChains":null,"banStatus":null},"id":19721036,"name":"Doom Nova Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/Zach/Banzai/19721036.jpg","createDate":{"time":1363258710000,"minutes":58,"seconds":30,"hours":6,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/Zach/Banzai/19721036.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2331,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.598639,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Conrad Volcano","authId":"","name":"Luminous Conrad Volcano","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Conrad Volcano","authId":"","name":"Luminous Conrad Volcano","CNNId":"","myGameChains":null,"banStatus":null},"id":19840857,"name":"Fury Plumber Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Luminous/Conrad/Volcano/19840857.jpg","createDate":{"time":1363788651000,"minutes":10,"seconds":51,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Luminous/Conrad/Volcano/19840857.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1308,"difficulty":2.5348043329887897,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":23568,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.598068,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Kenneth Charger","authId":"","name":"Extreme Kenneth Charger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Kenneth Charger","authId":"","name":"Extreme Kenneth Charger","CNNId":"","myGameChains":null,"banStatus":null},"id":19757620,"name":"Warrior Rampage Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Kenneth/Charger/19757620.jpg","createDate":{"time":1363416640000,"minutes":50,"seconds":40,"hours":2,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Kenneth/Charger/19757620.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1151,"difficulty":2.2563560596458516,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10767,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.587354,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Abstract Ray Deadbolt","authId":"","name":"Abstract Ray Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abstract Ray Deadbolt","authId":"","name":"Abstract Ray Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"id":19759985,"name":"Plasma Hero Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abstract/Ray/Deadbolt/19759985.jpg","createDate":{"time":1363434467000,"minutes":47,"seconds":47,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abstract/Ray/Deadbolt/19759985.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":633,"difficulty":2.9298664537374215,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13256,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.586454,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"61","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 = '16' 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":"70","currentPageToDisplay":7,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]