[{"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 = '15' 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":"Unknown Marvin Venom","authId":"","name":"Unknown Marvin Venom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Marvin Venom","authId":"","name":"Unknown Marvin Venom","CNNId":"","myGameChains":null,"banStatus":null},"id":19678682,"name":"Rook Ultra Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unknown/Marvin/Venom/19678682.jpg","createDate":{"time":1363055093000,"minutes":24,"seconds":53,"hours":22,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unknown/Marvin/Venom/19678682.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1614,"difficulty":1.9402485804822578,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9638,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.799306,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Plucky Casey Shock","authId":"","name":"Plucky Casey Shock","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Plucky Casey Shock","authId":"","name":"Plucky Casey Shock","CNNId":"","myGameChains":null,"banStatus":null},"id":19673790,"name":"Warp Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Plucky/Casey/Shock/19673790.jpg","createDate":{"time":1363044345000,"minutes":25,"seconds":45,"hours":19,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Plucky/Casey/Shock/19673790.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1072,"difficulty":2.7513987735050174,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3869,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.769607,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Leon Potato","authId":"","name":"Extreme Leon Potato","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Leon Potato","authId":"","name":"Extreme Leon Potato","CNNId":"","myGameChains":null,"banStatus":null},"id":19667696,"name":"Hyper Galaxy Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Leon/Potato/19667696.jpg","createDate":{"time":1363033343000,"minutes":22,"seconds":23,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Leon/Potato/19667696.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":527,"difficulty":1.9910584042654178,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4559,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.76621,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Augustus Bungee","authId":"","name":"Crafty Augustus Bungee","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Augustus Bungee","authId":"","name":"Crafty Augustus Bungee","CNNId":"","myGameChains":null,"banStatus":null},"id":19667276,"name":"Champion Escape Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crafty/Augustus/Bungee/19667276.jpg","createDate":{"time":1363032255000,"minutes":4,"seconds":15,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crafty/Augustus/Bungee/19667276.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":125,"difficulty":2.8286312945923253,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19820,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.765767,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prickly Finn Foghorn","authId":"","name":"Prickly Finn Foghorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prickly Finn Foghorn","authId":"","name":"Prickly Finn Foghorn","CNNId":"","myGameChains":null,"banStatus":null},"id":19816480,"name":"Plasma Shock Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prickly/Finn/Foghorn/19816480.jpg","createDate":{"time":1363611653000,"minutes":0,"seconds":53,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prickly/Finn/Foghorn/19816480.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1769,"difficulty":2.4120208167449384,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":25678,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.757118,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Snazzy Phyllis Baboon","authId":"","name":"Snazzy Phyllis Baboon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Snazzy Phyllis Baboon","authId":"","name":"Snazzy Phyllis Baboon","CNNId":"","myGameChains":null,"banStatus":null},"id":19816528,"name":"Adventure Space Rustbucket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Snazzy/Phyllis/Baboon/19816528.jpg","createDate":{"time":1363611859000,"minutes":4,"seconds":19,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Snazzy/Phyllis/Baboon/19816528.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2236,"difficulty":2.4625270497033878,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6401,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.756509,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Beatrice Blade","authId":"","name":"Captain Beatrice Blade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Beatrice Blade","authId":"","name":"Captain Beatrice Blade","CNNId":"","myGameChains":null,"banStatus":null},"id":19707241,"name":"Universe Alien Ben","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Beatrice/Blade/19707241.jpg","createDate":{"time":1363195686000,"minutes":28,"seconds":6,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Beatrice/Blade/19707241.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3158,"difficulty":1.5785676726002364,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27343,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.749134,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Ella Gumshoe","authId":"","name":"Towering Ella Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Ella Gumshoe","authId":"","name":"Towering Ella Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":19707310,"name":"Rock Attack Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Towering/Ella/Gumshoe/19707310.jpg","createDate":{"time":1363195972000,"minutes":32,"seconds":52,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Towering/Ella/Gumshoe/19707310.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13968,"difficulty":2.3364331770812963,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":44167,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.748688,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Slimy Darlene Yodel","authId":"","name":"Slimy Darlene Yodel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Slimy Darlene Yodel","authId":"","name":"Slimy Darlene Yodel","CNNId":"","myGameChains":null,"banStatus":null},"id":19671936,"name":"Solar Ultimate Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Slimy/Darlene/Yodel/19671936.jpg","createDate":{"time":1363041542000,"minutes":39,"seconds":2,"hours":18,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Slimy/Darlene/Yodel/19671936.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":362,"difficulty":2.4131393298059964,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2744,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.746032,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stately Ginger Unicorn","authId":"","name":"Stately Ginger Unicorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stately Ginger Unicorn","authId":"","name":"Stately Ginger Unicorn","CNNId":"","myGameChains":null,"banStatus":null},"id":19667073,"name":"Adventure Giga Pulse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stately/Ginger/Unicorn/19667073.jpg","createDate":{"time":1363031832000,"minutes":57,"seconds":12,"hours":15,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stately/Ginger/Unicorn/19667073.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":198,"difficulty":2.847133094741023,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":76903,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.743845,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"11","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 = '15' 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":"20","currentPageToDisplay":2,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]