[{"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 = '3' 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":"Super Billy Ooze","authId":"","name":"Super Billy Ooze","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Billy Ooze","authId":"","name":"Super Billy Ooze","CNNId":"","myGameChains":null,"banStatus":null},"id":17687350,"name":"Charge Galaxy Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Billy/Ooze/17687350.jpg","createDate":{"time":1348391604000,"minutes":13,"seconds":24,"hours":5,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Billy/Ooze/17687350.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4801,"difficulty":1.9997631145240802,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10711,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.437025,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Splendid Rocky Tiger","authId":"","name":"Splendid Rocky Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Splendid Rocky Tiger","authId":"","name":"Splendid Rocky Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":19885338,"name":"Plasma Smash Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Splendid/Rocky/Tiger/19885338.jpg","createDate":{"time":1364079153000,"minutes":52,"seconds":33,"hours":18,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Splendid/Rocky/Tiger/19885338.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21187,"difficulty":2.4862533029616953,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26215,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.386775,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Freakish Maxwell Nacho","authId":"","name":"Freakish Maxwell Nacho","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Freakish Maxwell Nacho","authId":"","name":"Freakish Maxwell Nacho","CNNId":"","myGameChains":null,"banStatus":null},"id":18089280,"name":"Fusion Hex Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Freakish/Maxwell/Nacho/18089280.jpg","createDate":{"time":1349979843000,"minutes":24,"seconds":3,"hours":14,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Freakish/Maxwell/Nacho/18089280.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2067,"difficulty":2.348721375087805,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11898,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.378798,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Stephen Javelin","authId":"","name":"Brisk Stephen Javelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Stephen Javelin","authId":"","name":"Brisk Stephen Javelin","CNNId":"","myGameChains":null,"banStatus":null},"id":19264768,"name":"Search Shock Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Stephen/Javelin/19264768.jpg","createDate":{"time":1356954453000,"minutes":47,"seconds":33,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Stephen/Javelin/19264768.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1033,"difficulty":1.313893146275241,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9589,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.3107,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Kyle Acorn","authId":"","name":"Dandy Kyle Acorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Kyle Acorn","authId":"","name":"Dandy Kyle Acorn","CNNId":"","myGameChains":null,"banStatus":null},"id":17813342,"name":"Nitro Echo Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dandy/Kyle/Acorn/17813342.jpg","createDate":{"time":1348832630000,"minutes":43,"seconds":50,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dandy/Kyle/Acorn/17813342.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1963,"difficulty":2.3151480463980465,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2271,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.227826,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Bella Wombat","authId":"","name":"Gruesome Bella Wombat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Bella Wombat","authId":"","name":"Gruesome Bella Wombat","CNNId":"","myGameChains":null,"banStatus":null},"id":17813354,"name":"Smash Lightning Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gruesome/Bella/Wombat/17813354.jpg","createDate":{"time":1348832716000,"minutes":45,"seconds":16,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gruesome/Bella/Wombat/17813354.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2424,"difficulty":2.3133612958947403,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3200,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.227051,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shrewd Spike Soldier","authId":"","name":"Shrewd Spike Soldier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shrewd Spike Soldier","authId":"","name":"Shrewd Spike Soldier","CNNId":"","myGameChains":null,"banStatus":null},"id":19707567,"name":"Beast Thunder Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shrewd/Spike/Soldier/19707567.jpg","createDate":{"time":1363196893000,"minutes":48,"seconds":13,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shrewd/Spike/Soldier/19707567.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3751,"difficulty":1.8456399178895428,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8107,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.212215,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Northern Dustin Ghost","authId":"","name":"Northern Dustin Ghost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Northern Dustin Ghost","authId":"","name":"Northern Dustin Ghost","CNNId":"","myGameChains":null,"banStatus":null},"id":18079033,"name":"Solar Challenge Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Northern/Dustin/Ghost/18079033.jpg","createDate":{"time":1349899623000,"minutes":7,"seconds":3,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Northern/Dustin/Ghost/18079033.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":512,"difficulty":1.5160714285714285,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4669,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.200893,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"General Jon Yoyo","authId":"","name":"General Jon Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"General Jon Yoyo","authId":"","name":"General Jon Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":19899570,"name":"Battle Spike Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/General/Jon/Yoyo/19899570.jpg","createDate":{"time":1364157404000,"minutes":36,"seconds":44,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"General/Jon/Yoyo/19899570.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4567,"difficulty":1.6203799340815705,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5854,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.154621,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Messy Iris Ghost","authId":"","name":"Messy Iris Ghost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Messy Iris Ghost","authId":"","name":"Messy Iris Ghost","CNNId":"","myGameChains":null,"banStatus":null},"id":19861078,"name":"Racer Warp Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Messy/Iris/Ghost/19861078.jpg","createDate":{"time":1363957668000,"minutes":7,"seconds":48,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Messy/Iris/Ghost/19861078.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2789,"difficulty":2.4329238639900406,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3544,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.136552,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"141","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 = '3' 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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]