[{"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":"Fabulous Austin Flatiron","authId":"","name":"Fabulous Austin Flatiron","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Austin Flatiron","authId":"","name":"Fabulous Austin Flatiron","CNNId":"","myGameChains":null,"banStatus":null},"id":19806677,"name":"Echo Water Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fabulous/Austin/Flatiron/19806677.jpg","createDate":{"time":1363555172000,"minutes":19,"seconds":32,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fabulous/Austin/Flatiron/19806677.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":851,"difficulty":2.5030971340259125,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17616,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.810274,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Lunar Joe Amoeba","authId":"","name":"Lunar Joe Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lunar Joe Amoeba","authId":"","name":"Lunar Joe Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"id":19683884,"name":"Fusion Gear Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lunar/Joe/Amoeba/19683884.jpg","createDate":{"time":1363099783000,"minutes":49,"seconds":43,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lunar/Joe/Amoeba/19683884.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":198,"difficulty":2.5818903318903317,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14246,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.805784,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Jay Banjo","authId":"","name":"Quirky Jay Banjo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Jay Banjo","authId":"","name":"Quirky Jay Banjo","CNNId":"","myGameChains":null,"banStatus":null},"id":19899517,"name":"Mega Plumber Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quirky/Jay/Banjo/19899517.jpg","createDate":{"time":1364157237000,"minutes":33,"seconds":57,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quirky/Jay/Banjo/19899517.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3887,"difficulty":2.4497782977388223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31413,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.803159,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Dora Sunrise","authId":"","name":"Ironic Dora Sunrise","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Dora Sunrise","authId":"","name":"Ironic Dora Sunrise","CNNId":"","myGameChains":null,"banStatus":null},"id":19686506,"name":"Sonic Space Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironic/Dora/Sunrise/19686506.jpg","createDate":{"time":1363109112000,"minutes":25,"seconds":12,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironic/Dora/Sunrise/19686506.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":231,"difficulty":2.7751322751322753,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1948,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.800826,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loopy Madison Clang","authId":"","name":"Loopy Madison Clang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loopy Madison Clang","authId":"","name":"Loopy Madison Clang","CNNId":"","myGameChains":null,"banStatus":null},"id":19684532,"name":"Breaker Kickin' Hawk Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loopy/Madison/Clang/19684532.jpg","createDate":{"time":1363102307000,"minutes":31,"seconds":47,"hours":11,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loopy/Madison/Clang/19684532.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1451,"difficulty":2.244341022047667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4445,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.797749,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Ichabod Anvil","authId":"","name":"Toxic Ichabod Anvil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Ichabod Anvil","authId":"","name":"Toxic Ichabod Anvil","CNNId":"","myGameChains":null,"banStatus":null},"id":19691361,"name":"Assault Hero Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Ichabod/Anvil/19691361.jpg","createDate":{"time":1363121657000,"minutes":54,"seconds":17,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Ichabod/Anvil/19691361.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":538,"difficulty":2.530396825396825,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1328,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.794405,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Max Rhino","authId":"","name":"Vast Max Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Max Rhino","authId":"","name":"Vast Max Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":19690484,"name":"Rumble Kickin' Hawk Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vast/Max/Rhino/19690484.jpg","createDate":{"time":1363119955000,"minutes":25,"seconds":55,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vast/Max/Rhino/19690484.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":223,"difficulty":2.925925925925926,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2583,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.793691,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Jordan Panda","authId":"","name":"Regal Jordan Panda","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Jordan Panda","authId":"","name":"Regal Jordan Panda","CNNId":"","myGameChains":null,"banStatus":null},"id":19906741,"name":"Mega Kickin' Hawk Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regal/Jordan/Panda/19906741.jpg","createDate":{"time":1364218571000,"minutes":36,"seconds":11,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regal/Jordan/Panda/19906741.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":130,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":867,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.791667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Putrid Roscoe Wombat","authId":"","name":"Putrid Roscoe Wombat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Putrid Roscoe Wombat","authId":"","name":"Putrid Roscoe Wombat","CNNId":"","myGameChains":null,"banStatus":null},"id":19672533,"name":"Sonic Breaker Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Putrid/Roscoe/Wombat/19672533.jpg","createDate":{"time":1363042433000,"minutes":53,"seconds":53,"hours":18,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Putrid/Roscoe/Wombat/19672533.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2215,"difficulty":2.099209278750747,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7053,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.787788,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stylish Scott Hiccup","authId":"","name":"Stylish Scott Hiccup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stylish Scott Hiccup","authId":"","name":"Stylish Scott Hiccup","CNNId":"","myGameChains":null,"banStatus":null},"id":19995393,"name":"Adventure Adventure Plumber","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stylish/Scott/Hiccup/19995393.jpg","createDate":{"time":1364838684000,"minutes":51,"seconds":24,"hours":13,"month":3,"timezoneOffset":240,"year":113,"day":1,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stylish/Scott/Hiccup/19995393.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2378,"difficulty":2.274741509624003,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2823,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.786629,"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 = '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":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]