[{"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":"Brisk Edd Atlas","authId":"","name":"Brisk Edd Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Edd Atlas","authId":"","name":"Brisk Edd Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":19053379,"name":"Solar Plasma Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Edd/Atlas/19053379.jpg","createDate":{"time":1355745550000,"minutes":59,"seconds":10,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Edd/Atlas/19053379.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":535,"difficulty":2.4285714285714284,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2305,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.197531,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Merlin","authId":"","name":"Ancient Merlin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Merlin","authId":"","name":"Ancient Merlin","CNNId":"","myGameChains":null,"banStatus":null},"id":17944278,"name":"Hero Warrior Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Merlin/17944278.jpg","createDate":{"time":1349284297000,"minutes":11,"seconds":37,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Merlin/17944278.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1674,"difficulty":2.4583333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7263,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.193027,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Chaotic Jaden Barnacle","authId":"","name":"Chaotic Jaden Barnacle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Chaotic Jaden Barnacle","authId":"","name":"Chaotic Jaden Barnacle","CNNId":"","myGameChains":null,"banStatus":null},"id":17782784,"name":"Sonic Siege Whirlwind","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Chaotic/Jaden/Barnacle/17782784.jpg","createDate":{"time":1348688385000,"minutes":39,"seconds":45,"hours":15,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Chaotic/Jaden/Barnacle/17782784.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1342,"difficulty":2.484388528138528,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2333,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.178319,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Merlin Vector","authId":"","name":"Admiral Merlin Vector","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Merlin Vector","authId":"","name":"Admiral Merlin Vector","CNNId":"","myGameChains":null,"banStatus":null},"id":18004034,"name":"Nano Mission Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Merlin/Vector/18004034.jpg","createDate":{"time":1349552726000,"minutes":45,"seconds":26,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Merlin/Vector/18004034.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":180,"difficulty":2.68,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3734,"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":"Extreme Aiden Clone","authId":"","name":"Extreme Aiden Clone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Aiden Clone","authId":"","name":"Extreme Aiden Clone","CNNId":"","myGameChains":null,"banStatus":null},"id":17543769,"name":"Clash Universe Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Aiden/Clone/17543769.jpg","createDate":{"time":1348153592000,"minutes":6,"seconds":32,"hours":11,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Aiden/Clone/17543769.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1265,"difficulty":1.6866466196491772,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2740,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.162888,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Brandy Vector","authId":"","name":"Immortal Brandy Vector","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Brandy Vector","authId":"","name":"Immortal Brandy Vector","CNNId":"","myGameChains":null,"banStatus":null},"id":17587472,"name":"Adventure Star Humungousaur","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Immortal/Brandy/Vector/17587472.jpg","createDate":{"time":1348259075000,"minutes":24,"seconds":35,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Immortal/Brandy/Vector/17587472.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":657,"difficulty":2.5848496214827485,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3032,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.15377,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal David Pinball","authId":"","name":"Colossal David Pinball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal David Pinball","authId":"","name":"Colossal David Pinball","CNNId":"","myGameChains":null,"banStatus":null},"id":18170677,"name":"Gear Techno Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colossal/David/Pinball/18170677.jpg","createDate":{"time":1350380361000,"minutes":39,"seconds":21,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colossal/David/Pinball/18170677.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":360,"difficulty":2.49220309604925,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9065,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.147828,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Heidi Tuxedo","authId":"","name":"Ancient Heidi Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Heidi Tuxedo","authId":"","name":"Ancient Heidi Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"id":18170599,"name":"Rampage Nitro Nitro","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Heidi/Tuxedo/18170599.jpg","createDate":{"time":1350377791000,"minutes":56,"seconds":31,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Heidi/Tuxedo/18170599.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":756,"difficulty":1.5714285714285714,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4288,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.126786,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Robotic Logan Aardvark","authId":"","name":"Robotic Logan Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Robotic Logan Aardvark","authId":"","name":"Robotic Logan Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"id":17778051,"name":"Assault Doom Light","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Robotic/Logan/Aardvark/17778051.jpg","createDate":{"time":1348670349000,"minutes":39,"seconds":9,"hours":10,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Robotic/Logan/Aardvark/17778051.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":104,"difficulty":1.8333333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2467,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.122575,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Conrad Orca","authId":"","name":"Speedy Conrad Orca","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Conrad Orca","authId":"","name":"Speedy Conrad Orca","CNNId":"","myGameChains":null,"banStatus":null},"id":18474849,"name":"Power Drone Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Conrad/Orca/18474849.jpg","createDate":{"time":1352839227000,"minutes":40,"seconds":27,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Conrad/Orca/18474849.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19098,"difficulty":2.1403240572014197,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51265,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.079977,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"101","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":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]