[{"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 = '14' 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":"Cunning Derrick Swarm","authId":"","name":"Cunning Derrick Swarm","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cunning Derrick Swarm","authId":"","name":"Cunning Derrick Swarm","CNNId":"","myGameChains":null,"banStatus":null},"id":18521071,"name":"Whirlwind Laser Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cunning/Derrick/Swarm/18521071.jpg","createDate":{"time":1353354200000,"minutes":43,"seconds":20,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cunning/Derrick/Swarm/18521071.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":794,"difficulty":2.416619121240995,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16629,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.70682,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Max Banjo","authId":"","name":"Cute Max Banjo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Max Banjo","authId":"","name":"Cute Max Banjo","CNNId":"","myGameChains":null,"banStatus":null},"id":18783651,"name":"Razor Humungousaur Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cute/Max/Banjo/18783651.jpg","createDate":{"time":1354913227000,"minutes":47,"seconds":7,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cute/Max/Banjo/18783651.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11834,"difficulty":1.6157429737136413,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13839,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.702526,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Wallace Bonkers","authId":"","name":"Curious Wallace Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Wallace Bonkers","authId":"","name":"Curious Wallace Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"id":18706473,"name":"Big Bloxx Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Wallace/Bonkers/18706473.jpg","createDate":{"time":1354656574000,"minutes":29,"seconds":34,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Wallace/Bonkers/18706473.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1587,"difficulty":2.842186433542403,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":54514,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.702093,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Puzzling Tommy Flywheel","authId":"","name":"Puzzling Tommy Flywheel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Puzzling Tommy Flywheel","authId":"","name":"Puzzling Tommy Flywheel","CNNId":"","myGameChains":null,"banStatus":null},"id":18527290,"name":"Pulse Iron Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Puzzling/Tommy/Flywheel/18527290.jpg","createDate":{"time":1353430769000,"minutes":59,"seconds":29,"hours":11,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Puzzling/Tommy/Flywheel/18527290.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4674,"difficulty":1.4832796278958205,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14198,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.694625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Juggling Bryce Monolith","authId":"","name":"Juggling Bryce Monolith","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Juggling Bryce Monolith","authId":"","name":"Juggling Bryce Monolith","CNNId":"","myGameChains":null,"banStatus":null},"id":18676243,"name":"Chase Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Juggling/Bryce/Monolith/18676243.jpg","createDate":{"time":1354549756000,"minutes":49,"seconds":16,"hours":10,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Juggling/Bryce/Monolith/18676243.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":948,"difficulty":2.862475408715564,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26687,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.69314,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Ethel Dinosaur","authId":"","name":"Spectral Ethel Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Ethel Dinosaur","authId":"","name":"Spectral Ethel Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":18557306,"name":"Ultra Droid Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spectral/Ethel/Dinosaur/18557306.jpg","createDate":{"time":1353622826000,"minutes":20,"seconds":26,"hours":17,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spectral/Ethel/Dinosaur/18557306.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4732,"difficulty":2.4046811880222263,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":59828,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.69086,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Jillian Kazoo","authId":"","name":"Keen Jillian Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Jillian Kazoo","authId":"","name":"Keen Jillian Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"id":19933864,"name":"Storm Racer Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Keen/Jillian/Kazoo/19933864.jpg","createDate":{"time":1364418058000,"minutes":0,"seconds":58,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Keen/Jillian/Kazoo/19933864.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":143,"difficulty":2.815404451884728,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15963,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.686672,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stout Vern Vector","authId":"","name":"Stout Vern Vector","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stout Vern Vector","authId":"","name":"Stout Vern Vector","CNNId":"","myGameChains":null,"banStatus":null},"id":19500594,"name":"Humungousaur Shock Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stout/Vern/Vector/19500594.jpg","createDate":{"time":1360166706000,"minutes":5,"seconds":6,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stout/Vern/Vector/19500594.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2847,"difficulty":2.6945090674118055,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12880,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.663092,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grand Zeus Nova","authId":"","name":"Grand Zeus Nova","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grand Zeus Nova","authId":"","name":"Grand Zeus Nova","CNNId":"","myGameChains":null,"banStatus":null},"id":19234693,"name":"Earth Slam Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grand/Zeus/Nova/19234693.jpg","createDate":{"time":1356758385000,"minutes":19,"seconds":45,"hours":0,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grand/Zeus/Nova/19234693.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12641,"difficulty":2.4194331497276775,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":102006,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.662213,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Baxter Noob","authId":"","name":"Loud Baxter Noob","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Baxter Noob","authId":"","name":"Loud Baxter Noob","CNNId":"","myGameChains":null,"banStatus":null},"id":18558576,"name":"Iron Omniverse Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Baxter/Noob/18558576.jpg","createDate":{"time":1353628518000,"minutes":55,"seconds":18,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Baxter/Noob/18558576.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14569,"difficulty":2.61033298936699,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31130,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.661765,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"41","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 = '14' 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":"50","currentPageToDisplay":5,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]