[{"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 = '4' 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":"Ghastly Chester Brute","authId":"","name":"Ghastly Chester Brute","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghastly Chester Brute","authId":"","name":"Ghastly Chester Brute","CNNId":"","myGameChains":null,"banStatus":null},"id":17956074,"name":"Spidermonkey Rampage Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghastly/Chester/Brute/17956074.jpg","createDate":{"time":1349365592000,"minutes":46,"seconds":32,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghastly/Chester/Brute/17956074.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":280,"difficulty":1.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1063,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dizzy Gus Gorgon","authId":"","name":"Dizzy Gus Gorgon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dizzy Gus Gorgon","authId":"","name":"Dizzy Gus Gorgon","CNNId":"","myGameChains":null,"banStatus":null},"id":18207206,"name":"Danger Defense Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dizzy/Gus/Gorgon/18207206.jpg","createDate":{"time":1350724202000,"minutes":10,"seconds":2,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dizzy/Gus/Gorgon/18207206.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":56,"difficulty":2.111111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":978,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Jackson Mallard","authId":"","name":"Famous Jackson Mallard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Jackson Mallard","authId":"","name":"Famous Jackson Mallard","CNNId":"","myGameChains":null,"banStatus":null},"id":19208543,"name":"Universe Rampage Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Jackson/Mallard/19208543.jpg","createDate":{"time":1356614892000,"minutes":28,"seconds":12,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Jackson/Mallard/19208543.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2369,"difficulty":2.565510138924413,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9138,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.108746,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Merry Kristin Whale","authId":"","name":"Merry Kristin Whale","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Merry Kristin Whale","authId":"","name":"Merry Kristin Whale","CNNId":"","myGameChains":null,"banStatus":null},"id":17972208,"name":"Pursuit Hyper Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Merry/Kristin/Whale/17972208.jpg","createDate":{"time":1349459445000,"minutes":50,"seconds":45,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Merry/Kristin/Whale/17972208.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":80034,"difficulty":2.1269400566851675,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":210773,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.104481,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Carefree Zoe Frog","authId":"","name":"Carefree Zoe Frog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Carefree Zoe Frog","authId":"","name":"Carefree Zoe Frog","CNNId":"","myGameChains":null,"banStatus":null},"id":18127734,"name":"Adventure Warrior Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Carefree/Zoe/Frog/18127734.jpg","createDate":{"time":1350158631000,"minutes":3,"seconds":51,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Carefree/Zoe/Frog/18127734.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2338,"difficulty":1.6874951010055375,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15051,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.086476,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Larry Atlas","authId":"","name":"Stinky Larry Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Larry Atlas","authId":"","name":"Stinky Larry Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":18207293,"name":"Mega Metal Burst","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stinky/Larry/Atlas/18207293.jpg","createDate":{"time":1350725503000,"minutes":31,"seconds":43,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stinky/Larry/Atlas/18207293.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7330,"difficulty":2.506231105220588,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":23000,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.076164,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nimble Ashton Scorpion","authId":"","name":"Nimble Ashton Scorpion","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nimble Ashton Scorpion","authId":"","name":"Nimble Ashton Scorpion","CNNId":"","myGameChains":null,"banStatus":null},"id":18089257,"name":"Spidermonkey Alien Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nimble/Ashton/Scorpion/18089257.jpg","createDate":{"time":1349979715000,"minutes":21,"seconds":55,"hours":14,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nimble/Ashton/Scorpion/18089257.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1977,"difficulty":2.324147305981216,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4086,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.075556,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Alexis Ape","authId":"","name":"Electric Alexis Ape","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Alexis Ape","authId":"","name":"Electric Alexis Ape","CNNId":"","myGameChains":null,"banStatus":null},"id":17681572,"name":"Target Warrior Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Alexis/Ape/17681572.jpg","createDate":{"time":1348369449000,"minutes":4,"seconds":9,"hours":23,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Alexis/Ape/17681572.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":109,"difficulty":2.8018247645569065,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":65573,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.053545,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Earl Glop","authId":"","name":"Dormant Earl Glop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Earl Glop","authId":"","name":"Dormant Earl Glop","CNNId":"","myGameChains":null,"banStatus":null},"id":19198303,"name":"Rampage Warrior Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dormant/Earl/Glop/19198303.jpg","createDate":{"time":1356540014000,"minutes":40,"seconds":14,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dormant/Earl/Glop/19198303.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2368,"difficulty":1.6314182965156285,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7727,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.045035,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quantum Evan Zeppelin","authId":"","name":"Quantum Evan Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quantum Evan Zeppelin","authId":"","name":"Quantum Evan Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"id":17752570,"name":"Pursuit Humungousaur Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quantum/Evan/Zeppelin/17752570.jpg","createDate":{"time":1348533318000,"minutes":35,"seconds":18,"hours":20,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quantum/Evan/Zeppelin/17752570.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3496,"difficulty":2.6293823505197698,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":98390,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.019132,"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 = '4' 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"}}]