[{"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 = '8' 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":"Jingling Collin Martian","authId":"","name":"Jingling Collin Martian","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jingling Collin Martian","authId":"","name":"Jingling Collin Martian","CNNId":"","myGameChains":null,"banStatus":null},"id":18486799,"name":"Giga Cosmic Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jingling/Collin/Martian/18486799.jpg","createDate":{"time":1353009391000,"minutes":56,"seconds":31,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jingling/Collin/Martian/18486799.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1322,"difficulty":2.6132064050929857,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12583,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.686307,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Mark Spark","authId":"","name":"Western Mark Spark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Mark Spark","authId":"","name":"Western Mark Spark","CNNId":"","myGameChains":null,"banStatus":null},"id":17793404,"name":"Nano Patrol Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Western/Mark/Spark/17793404.jpg","createDate":{"time":1348719871000,"minutes":24,"seconds":31,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Western/Mark/Spark/17793404.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1146,"difficulty":1.9398433932027548,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17383,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.685687,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironclad Albert Hogwash","authId":"","name":"Ironclad Albert Hogwash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironclad Albert Hogwash","authId":"","name":"Ironclad Albert Hogwash","CNNId":"","myGameChains":null,"banStatus":null},"id":19611824,"name":"Defense Space Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironclad/Albert/Hogwash/19611824.jpg","createDate":{"time":1362048159000,"minutes":42,"seconds":39,"hours":5,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironclad/Albert/Hogwash/19611824.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1579,"difficulty":1.8682924750210999,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":49954,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.679821,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Napoleon Shinobi","authId":"","name":"Flying Napoleon Shinobi","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Napoleon Shinobi","authId":"","name":"Flying Napoleon Shinobi","CNNId":"","myGameChains":null,"banStatus":null},"id":17216071,"name":"Hyper Metal Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Flying/Napoleon/Shinobi/17216071.jpg","createDate":{"time":1342162106000,"minutes":48,"seconds":26,"hours":2,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Flying/Napoleon/Shinobi/17216071.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":200292,"difficulty":2.4814329274263116,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2361312,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":619,"rating":4.678509,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Diego Flamingo","authId":"","name":"Speedy Diego Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Diego Flamingo","authId":"","name":"Speedy Diego Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"id":19385777,"name":"Metal Beast Cannonbolt","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Diego/Flamingo/19385777.jpg","createDate":{"time":1358209551000,"minutes":25,"seconds":51,"hours":19,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Diego/Flamingo/19385777.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9001,"difficulty":2.897203142807483,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":35868,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.665994,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Latoya Scimitar","authId":"","name":"Vigilant Latoya Scimitar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Latoya Scimitar","authId":"","name":"Vigilant Latoya Scimitar","CNNId":"","myGameChains":null,"banStatus":null},"id":18930506,"name":"Spike Ultra Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vigilant/Latoya/Scimitar/18930506.jpg","createDate":{"time":1355228922000,"minutes":28,"seconds":42,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vigilant/Latoya/Scimitar/18930506.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1820,"difficulty":1.91368772809216,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3662,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.650379,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Duke Wilma","authId":"","name":"Duke Wilma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Duke Wilma","authId":"","name":"Duke Wilma","CNNId":"","myGameChains":null,"banStatus":null},"id":17687335,"name":"Big Target Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Duke/Wilma/17687335.jpg","createDate":{"time":1348391509000,"minutes":11,"seconds":49,"hours":5,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Duke/Wilma/17687335.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3136,"difficulty":1.5814215990318048,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5403,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.646839,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Juggling Jay Serpent","authId":"","name":"Juggling Jay Serpent","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Juggling Jay Serpent","authId":"","name":"Juggling Jay Serpent","CNNId":"","myGameChains":null,"banStatus":null},"id":19128792,"name":"Ultra Mega Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Juggling/Jay/Serpent/19128792.jpg","createDate":{"time":1356197968000,"minutes":39,"seconds":28,"hours":12,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Juggling/Jay/Serpent/19128792.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1237,"difficulty":1.5695080438214635,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29596,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.636983,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Seismic Kennedy Fondue","authId":"","name":"Seismic Kennedy Fondue","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Seismic Kennedy Fondue","authId":"","name":"Seismic Kennedy Fondue","CNNId":"","myGameChains":null,"banStatus":null},"id":19347471,"name":"Hero Racer Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Seismic/Kennedy/Fondue/19347471.jpg","createDate":{"time":1357680825000,"minutes":33,"seconds":45,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Seismic/Kennedy/Fondue/19347471.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":173,"difficulty":2.86,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3304,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.634375,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Steven Buffalo","authId":"","name":"Steven Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Steven Buffalo","authId":"","name":"Steven Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"id":19563739,"name":"Energy Water Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Steven/Buffalo/19563739.jpg","createDate":{"time":1361193735000,"minutes":22,"seconds":15,"hours":8,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Steven/Buffalo/19563739.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":576,"difficulty":2.5129820086002415,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31260,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.631059,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"21","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 = '8' 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":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]