[{"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 = '5' 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":"Verbose Daniel Cowboy","authId":"","name":"Verbose Daniel Cowboy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Verbose Daniel Cowboy","authId":"","name":"Verbose Daniel Cowboy","CNNId":"","myGameChains":null,"banStatus":null},"id":17622880,"name":"Clash Chase Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Verbose/Daniel/Cowboy/17622880.jpg","createDate":{"time":1348315949000,"minutes":12,"seconds":29,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Verbose/Daniel/Cowboy/17622880.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":749,"difficulty":2.4257387057387056,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1726,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.081277,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Apollo Pinwheel","authId":"","name":"Twisty Apollo Pinwheel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Apollo Pinwheel","authId":"","name":"Twisty Apollo Pinwheel","CNNId":"","myGameChains":null,"banStatus":null},"id":19446288,"name":"Breaker Universe Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Twisty/Apollo/Pinwheel/19446288.jpg","createDate":{"time":1359190520000,"minutes":55,"seconds":20,"hours":3,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Twisty/Apollo/Pinwheel/19446288.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":583,"difficulty":2.28,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2995,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.08,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Jada Blubber","authId":"","name":"Sparkly Jada Blubber","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Jada Blubber","authId":"","name":"Sparkly Jada Blubber","CNNId":"","myGameChains":null,"banStatus":null},"id":18127775,"name":"Vilgax Lightning Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sparkly/Jada/Blubber/18127775.jpg","createDate":{"time":1350158694000,"minutes":4,"seconds":54,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sparkly/Jada/Blubber/18127775.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1227,"difficulty":1.666550931470186,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12276,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.047716,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smooth Kennedy Neptune","authId":"","name":"Smooth Kennedy Neptune","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smooth Kennedy Neptune","authId":"","name":"Smooth Kennedy Neptune","CNNId":"","myGameChains":null,"banStatus":null},"id":18676365,"name":"Galaxy Mission Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smooth/Kennedy/Neptune/18676365.jpg","createDate":{"time":1354550232000,"minutes":57,"seconds":12,"hours":10,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smooth/Kennedy/Neptune/18676365.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4425,"difficulty":1.312407159337372,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13945,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.038789,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Daring Justin Amethyst","authId":"","name":"Daring Justin Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Daring Justin Amethyst","authId":"","name":"Daring Justin Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"id":19505474,"name":"Earth Earth Giga","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Daring/Justin/Amethyst/19505474.jpg","createDate":{"time":1360271240000,"minutes":7,"seconds":20,"hours":16,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Daring/Justin/Amethyst/19505474.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3175,"difficulty":2.323042122454679,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14187,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.021139,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Hercules Isotope","authId":"","name":"Extreme Hercules Isotope","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Hercules Isotope","authId":"","name":"Extreme Hercules Isotope","CNNId":"","myGameChains":null,"banStatus":null},"id":18205385,"name":"Racer Light Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Hercules/Isotope/18205385.jpg","createDate":{"time":1350705731000,"minutes":2,"seconds":11,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Hercules/Isotope/18205385.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3341,"difficulty":2.2111626745483686,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":101327,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.018882,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smart Austin Sunrise","authId":"","name":"Smart Austin Sunrise","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smart Austin Sunrise","authId":"","name":"Smart Austin Sunrise","CNNId":"","myGameChains":null,"banStatus":null},"id":18911926,"name":"Plumber Champion Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smart/Austin/Sunrise/18911926.jpg","createDate":{"time":1355129454000,"minutes":50,"seconds":54,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smart/Austin/Sunrise/18911926.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36,"difficulty":2.8666666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2616,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.018518,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sharp Alfonso Blast","authId":"","name":"Sharp Alfonso Blast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sharp Alfonso Blast","authId":"","name":"Sharp Alfonso Blast","CNNId":"","myGameChains":null,"banStatus":null},"id":19264738,"name":"Energy Racer Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sharp/Alfonso/Blast/19264738.jpg","createDate":{"time":1356954038000,"minutes":40,"seconds":38,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sharp/Alfonso/Blast/19264738.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1706,"difficulty":1.50705724034468,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8016,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.010739,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Gus Neutron","authId":"","name":"King Gus Neutron","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Gus Neutron","authId":"","name":"King Gus Neutron","CNNId":"","myGameChains":null,"banStatus":null},"id":18513943,"name":"Lightning Laser Brainstorm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Gus/Neutron/18513943.jpg","createDate":{"time":1353269388000,"minutes":9,"seconds":48,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Gus/Neutron/18513943.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":848,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Antonio Jupiter","authId":"","name":"Toxic Antonio Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Antonio Jupiter","authId":"","name":"Toxic Antonio Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"id":17953330,"name":"Danger Universe Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Antonio/Jupiter/17953330.jpg","createDate":{"time":1349332498000,"minutes":34,"seconds":58,"hours":2,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Antonio/Jupiter/17953330.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":180,"difficulty":2.4,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":684,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"91","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 = '5' 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":"100","currentPageToDisplay":10,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]