[{"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 = '9' 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":"Twisty Rocky Ninja","authId":"","name":"Twisty Rocky Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Rocky Ninja","authId":"","name":"Twisty Rocky Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":18488391,"name":"Animo Smash Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Twisty/Rocky/Ninja/18488391.jpg","createDate":{"time":1353023745000,"minutes":55,"seconds":45,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Twisty/Rocky/Ninja/18488391.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2307,"difficulty":1.5274161735700198,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6609,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.190636,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Coco Volcano","authId":"","name":"Artful Coco Volcano","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Coco Volcano","authId":"","name":"Artful Coco Volcano","CNNId":"","myGameChains":null,"banStatus":null},"id":17756400,"name":"Echo Storm Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Artful/Coco/Volcano/17756400.jpg","createDate":{"time":1348551555000,"minutes":39,"seconds":15,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Artful/Coco/Volcano/17756400.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":333,"difficulty":2.044954648526077,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26256,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.187918,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loopy Alice Fury","authId":"","name":"Loopy Alice Fury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loopy Alice Fury","authId":"","name":"Loopy Alice Fury","CNNId":"","myGameChains":null,"banStatus":null},"id":19052985,"name":"Space Mission Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loopy/Alice/Fury/19052985.jpg","createDate":{"time":1355739207000,"minutes":13,"seconds":27,"hours":5,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loopy/Alice/Fury/19052985.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":326,"difficulty":2.4,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1201,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.166667,"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":19612840,"name":"Echo Echo Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lunar/Joe/Amoeba/19612840.jpg","createDate":{"time":1362078216000,"minutes":3,"seconds":36,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lunar/Joe/Amoeba/19612840.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1181,"difficulty":2.8408564097803852,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":71693,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.153541,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Val Beast","authId":"","name":"Keen Val Beast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Val Beast","authId":"","name":"Keen Val Beast","CNNId":"","myGameChains":null,"banStatus":null},"id":19421426,"name":"Warrior Shadow Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Keen/Val/Beast/19421426.jpg","createDate":{"time":1358775492000,"minutes":38,"seconds":12,"hours":8,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Keen/Val/Beast/19421426.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":643,"difficulty":2.2226731601731604,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1984,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.153439,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Daniel Clone","authId":"","name":"Earnest Daniel Clone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Daniel Clone","authId":"","name":"Earnest Daniel Clone","CNNId":"","myGameChains":null,"banStatus":null},"id":19517382,"name":"Techno Doom Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Earnest/Daniel/Clone/19517382.jpg","createDate":{"time":1360448344000,"minutes":19,"seconds":4,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Earnest/Daniel/Clone/19517382.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":179,"difficulty":2.6666666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1181,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.145833,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Pedro Cosmos","authId":"","name":"Athletic Pedro Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Pedro Cosmos","authId":"","name":"Athletic Pedro Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"id":17585374,"name":"Hero Water Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Athletic/Pedro/Cosmos/17585374.jpg","createDate":{"time":1348256172000,"minutes":36,"seconds":12,"hours":15,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Athletic/Pedro/Cosmos/17585374.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":638,"difficulty":2.12,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1747,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.142857,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Slimy Gavin Figment","authId":"","name":"Slimy Gavin Figment","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Slimy Gavin Figment","authId":"","name":"Slimy Gavin Figment","CNNId":"","myGameChains":null,"banStatus":null},"id":19489421,"name":"Big Fire Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Slimy/Gavin/Figment/19489421.jpg","createDate":{"time":1359918649000,"minutes":10,"seconds":49,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Slimy/Gavin/Figment/19489421.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1803,"difficulty":1.6388888888888888,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2508,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.14,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gleeful Ivan Robot","authId":"","name":"Gleeful Ivan Robot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gleeful Ivan Robot","authId":"","name":"Gleeful Ivan Robot","CNNId":"","myGameChains":null,"banStatus":null},"id":19364371,"name":"Ultra Energy Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gleeful/Ivan/Robot/19364371.jpg","createDate":{"time":1357962230000,"minutes":43,"seconds":50,"hours":22,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gleeful/Ivan/Robot/19364371.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1571,"difficulty":2.2915893630179345,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9541,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.133078,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Lazlo Banjo","authId":"","name":"Flying Lazlo Banjo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Lazlo Banjo","authId":"","name":"Flying Lazlo Banjo","CNNId":"","myGameChains":null,"banStatus":null},"id":17622941,"name":"Pursuit Spike Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Flying/Lazlo/Banjo/17622941.jpg","createDate":{"time":1348316042000,"minutes":14,"seconds":2,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Flying/Lazlo/Banjo/17622941.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7737,"difficulty":1.8564549892413487,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27941,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.125452,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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 = '9' 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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]