[{"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 = '12' 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":"Spectral Dudley Fiddle","authId":"","name":"Spectral Dudley Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Dudley Fiddle","authId":"","name":"Spectral Dudley Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"id":18616464,"name":"Gravattack Gravattack Gravattack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spectral/Dudley/Fiddle/18616464.jpg","createDate":{"time":1353981518000,"minutes":58,"seconds":38,"hours":20,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spectral/Dudley/Fiddle/18616464.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":353,"difficulty":2.074829931972789,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4948,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.984821,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Shawn Sprocket","authId":"","name":"Organic Shawn Sprocket","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Shawn Sprocket","authId":"","name":"Organic Shawn Sprocket","CNNId":"","myGameChains":null,"banStatus":null},"id":17687309,"name":"Adventure Mega Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Organic/Shawn/Sprocket/17687309.jpg","createDate":{"time":1348391429000,"minutes":10,"seconds":29,"hours":5,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Organic/Shawn/Sprocket/17687309.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":113,"difficulty":2.461464243817185,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11100,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.971288,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Victor Snowball","authId":"","name":"Curious Victor Snowball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Victor Snowball","authId":"","name":"Curious Victor Snowball","CNNId":"","myGameChains":null,"banStatus":null},"id":17547307,"name":"Gravattack Humungousaur Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Victor/Snowball/17547307.jpg","createDate":{"time":1348163745000,"minutes":55,"seconds":45,"hours":13,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Victor/Snowball/17547307.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2931,"difficulty":2.131755484544966,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4280,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.965627,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Brady Kiwi","authId":"","name":"Bold Brady Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Brady Kiwi","authId":"","name":"Bold Brady Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"id":19498980,"name":"Attack Cosmic Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Brady/Kiwi/19498980.jpg","createDate":{"time":1360113250000,"minutes":14,"seconds":10,"hours":20,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Brady/Kiwi/19498980.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22990,"difficulty":2.4953728527204326,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31688,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.956652,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quaint Helen Garlic","authId":"","name":"Quaint Helen Garlic","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quaint Helen Garlic","authId":"","name":"Quaint Helen Garlic","CNNId":"","myGameChains":null,"banStatus":null},"id":19331320,"name":"Droid Light Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quaint/Helen/Garlic/19331320.jpg","createDate":{"time":1357472920000,"minutes":48,"seconds":40,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quaint/Helen/Garlic/19331320.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":195,"difficulty":2.338888888888889,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3805,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.927891,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Negative Aaron Dynamite","authId":"","name":"Negative Aaron Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Negative Aaron Dynamite","authId":"","name":"Negative Aaron Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"id":18079075,"name":"Rampage Beast Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Negative/Aaron/Dynamite/18079075.jpg","createDate":{"time":1349899804000,"minutes":10,"seconds":4,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Negative/Aaron/Dynamite/18079075.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2459,"difficulty":2.6014976424917946,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8449,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.904384,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smooth Bjorn Shuriken","authId":"","name":"Smooth Bjorn Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smooth Bjorn Shuriken","authId":"","name":"Smooth Bjorn Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"id":19128776,"name":"Spark Chase Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smooth/Bjorn/Shuriken/19128776.jpg","createDate":{"time":1356197952000,"minutes":39,"seconds":12,"hours":12,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smooth/Bjorn/Shuriken/19128776.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":737,"difficulty":1.7074829931972788,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2698,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.9,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Simon Paprika","authId":"","name":"Valiant Simon Paprika","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Simon Paprika","authId":"","name":"Valiant Simon Paprika","CNNId":"","myGameChains":null,"banStatus":null},"id":17542642,"name":"Storm Droid Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Valiant/Simon/Paprika/17542642.jpg","createDate":{"time":1348150113000,"minutes":8,"seconds":33,"hours":10,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Valiant/Simon/Paprika/17542642.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1723,"difficulty":2.2108205848215436,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4559,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.887715,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Savage Jay Vitamin","authId":"","name":"Savage Jay Vitamin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Savage Jay Vitamin","authId":"","name":"Savage Jay Vitamin","CNNId":"","myGameChains":null,"banStatus":null},"id":17736748,"name":"Mission Universe Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Savage/Jay/Vitamin/17736748.jpg","createDate":{"time":1348462373000,"minutes":52,"seconds":53,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Savage/Jay/Vitamin/17736748.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":243,"difficulty":1.7361616161616162,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7992,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.859877,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Lloyd Shuriken","authId":"","name":"King Lloyd Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Lloyd Shuriken","authId":"","name":"King Lloyd Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"id":17579684,"name":"Assault Mega Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Lloyd/Shuriken/17579684.jpg","createDate":{"time":1348242156000,"minutes":42,"seconds":36,"hours":11,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Lloyd/Shuriken/17579684.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1067,"difficulty":1.409520521659881,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3924,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":3.838512,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"121","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 = '12' 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":"130","currentPageToDisplay":13,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]