[{"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 = '14' 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":"Howling Henry Hacksaw","authId":"","name":"Howling Henry Hacksaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Howling Henry Hacksaw","authId":"","name":"Howling Henry Hacksaw","CNNId":"","myGameChains":null,"banStatus":null},"id":19028015,"name":"Streak Galaxy Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Howling/Henry/Hacksaw/19028015.jpg","createDate":{"time":1355663635000,"minutes":13,"seconds":55,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Howling/Henry/Hacksaw/19028015.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5251,"difficulty":1.686202234980832,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13785,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.067245,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Matt Blubber","authId":"","name":"Creative Matt Blubber","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Matt Blubber","authId":"","name":"Creative Matt Blubber","CNNId":"","myGameChains":null,"banStatus":null},"id":18930292,"name":"Bloxx Rush Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Matt/Blubber/18930292.jpg","createDate":{"time":1355227262000,"minutes":1,"seconds":2,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Matt/Blubber/18930292.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":507,"difficulty":2.4393826330890716,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":174561,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.048921,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Max Howler","authId":"","name":"Edgy Max Howler","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Max Howler","authId":"","name":"Edgy Max Howler","CNNId":"","myGameChains":null,"banStatus":null},"id":19089493,"name":"Racer Force Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Edgy/Max/Howler/19089493.jpg","createDate":{"time":1355991694000,"minutes":21,"seconds":34,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Edgy/Max/Howler/19089493.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38868,"difficulty":2.278196882142525,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":83505,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.008603,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Kaitlyn Varmint","authId":"","name":"Electric Kaitlyn Varmint","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Kaitlyn Varmint","authId":"","name":"Electric Kaitlyn Varmint","CNNId":"","myGameChains":null,"banStatus":null},"id":18525107,"name":"Animo Adventure Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Kaitlyn/Varmint/18525107.jpg","createDate":{"time":1353387226000,"minutes":53,"seconds":46,"hours":23,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Kaitlyn/Varmint/18525107.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":527,"difficulty":2.3270286499651838,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14164,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.995292,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Casey Mummy","authId":"","name":"Active Casey Mummy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Casey Mummy","authId":"","name":"Active Casey Mummy","CNNId":"","myGameChains":null,"banStatus":null},"id":18700969,"name":"Gear Robot Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Active/Casey/Mummy/18700969.jpg","createDate":{"time":1354638385000,"minutes":26,"seconds":25,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Active/Casey/Mummy/18700969.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":98307,"difficulty":1.6943146879787445,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":135231,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.98146,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Alex Apple","authId":"","name":"Vigilant Alex Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Alex Apple","authId":"","name":"Vigilant Alex Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":19251166,"name":"Nitro Hex Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vigilant/Alex/Apple/19251166.jpg","createDate":{"time":1356865943000,"minutes":12,"seconds":23,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vigilant/Alex/Apple/19251166.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":58884,"difficulty":1.7663503293394287,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":110608,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.953659,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Savannah Planet","authId":"","name":"Majestic Savannah Planet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Savannah Planet","authId":"","name":"Majestic Savannah Planet","CNNId":"","myGameChains":null,"banStatus":null},"id":18995218,"name":"Ultimate Steel Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Majestic/Savannah/Planet/18995218.jpg","createDate":{"time":1355558786000,"minutes":6,"seconds":26,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Majestic/Savannah/Planet/18995218.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14410,"difficulty":2.456423238014918,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":113221,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.948307,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Defiant Skylar Flipper","authId":"","name":"Defiant Skylar Flipper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Defiant Skylar Flipper","authId":"","name":"Defiant Skylar Flipper","CNNId":"","myGameChains":null,"banStatus":null},"id":18749721,"name":"Space Space Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Defiant/Skylar/Flipper/18749721.jpg","createDate":{"time":1354798761000,"minutes":59,"seconds":21,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Defiant/Skylar/Flipper/18749721.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":41588,"difficulty":1.6094035942014717,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":62240,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.927748,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Suki Vampire","authId":"","name":"Blue Suki Vampire","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Suki Vampire","authId":"","name":"Blue Suki Vampire","CNNId":"","myGameChains":null,"banStatus":null},"id":19551168,"name":"Water Space Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Suki/Vampire/19551168.jpg","createDate":{"time":1361036502000,"minutes":41,"seconds":42,"hours":12,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Suki/Vampire/19551168.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26694,"difficulty":1.1568155112890155,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31796,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.920964,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling David Firefly","authId":"","name":"Babbling David Firefly","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling David Firefly","authId":"","name":"Babbling David Firefly","CNNId":"","myGameChains":null,"banStatus":null},"id":18783615,"name":"Plasma Lightning Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Babbling/David/Firefly/18783615.jpg","createDate":{"time":1354913143000,"minutes":45,"seconds":43,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Babbling/David/Firefly/18783615.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":79910,"difficulty":2.338105126222897,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":81458,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.914016,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"141","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 = '14' 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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]