[{"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":"Delicate Earl Soldier","authId":"","name":"Delicate Earl Soldier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Delicate Earl Soldier","authId":"","name":"Delicate Earl Soldier","CNNId":"","myGameChains":null,"banStatus":null},"id":19089994,"name":"Droid Smash Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Delicate/Earl/Soldier/19089994.jpg","createDate":{"time":1356002921000,"minutes":28,"seconds":41,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Delicate/Earl/Soldier/19089994.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4795,"difficulty":2.59324633536365,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":21074,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.428652,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Infinite Austin Celsius","authId":"","name":"Infinite Austin Celsius","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Infinite Austin Celsius","authId":"","name":"Infinite Austin Celsius","CNNId":"","myGameChains":null,"banStatus":null},"id":19496413,"name":"Clash Rustbucket Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Infinite/Austin/Celsius/19496413.jpg","createDate":{"time":1360073652000,"minutes":14,"seconds":12,"hours":9,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Infinite/Austin/Celsius/19496413.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13462,"difficulty":2.753426544095636,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":44745,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.423295,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Josiah Rhino","authId":"","name":"Earnest Josiah Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Josiah Rhino","authId":"","name":"Earnest Josiah Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":19222409,"name":"Adventure Nitro Giga","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Earnest/Josiah/Rhino/19222409.jpg","createDate":{"time":1356699146000,"minutes":52,"seconds":26,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Earnest/Josiah/Rhino/19222409.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1203,"difficulty":2.4642847992001693,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17673,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.422871,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Tim Saturn","authId":"","name":"Shy Tim Saturn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Tim Saturn","authId":"","name":"Shy Tim Saturn","CNNId":"","myGameChains":null,"banStatus":null},"id":19234919,"name":"Search Adventure Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shy/Tim/Saturn/19234919.jpg","createDate":{"time":1356760603000,"minutes":56,"seconds":43,"hours":0,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shy/Tim/Saturn/19234919.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":766,"difficulty":2.7391907927250667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":83572,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.405201,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Colin Wraith","authId":"","name":"Jumping Colin Wraith","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Colin Wraith","authId":"","name":"Jumping Colin Wraith","CNNId":"","myGameChains":null,"banStatus":null},"id":19347493,"name":"Crusher Mission Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jumping/Colin/Wraith/19347493.jpg","createDate":{"time":1357681105000,"minutes":38,"seconds":25,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jumping/Colin/Wraith/19347493.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17931,"difficulty":2.349517789678612,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24639,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.40265,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Duncan Volcano","authId":"","name":"Sleepy Duncan Volcano","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Duncan Volcano","authId":"","name":"Sleepy Duncan Volcano","CNNId":"","myGameChains":null,"banStatus":null},"id":18535055,"name":"Bloxx Techno Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleepy/Duncan/Volcano/18535055.jpg","createDate":{"time":1353488983000,"minutes":9,"seconds":43,"hours":4,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleepy/Duncan/Volcano/18535055.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4568,"difficulty":1.4027212462953376,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13181,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.357907,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Thomas Taco","authId":"","name":"Abnormal Thomas Taco","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Thomas Taco","authId":"","name":"Abnormal Thomas Taco","CNNId":"","myGameChains":null,"banStatus":null},"id":19434337,"name":"Ben Space Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abnormal/Thomas/Taco/19434337.jpg","createDate":{"time":1358975580000,"minutes":13,"seconds":0,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abnormal/Thomas/Taco/19434337.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6281,"difficulty":1.3579092617654538,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":56526,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.356564,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vibrant Jeremy Shuriken","authId":"","name":"Vibrant Jeremy Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vibrant Jeremy Shuriken","authId":"","name":"Vibrant Jeremy Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"id":18707629,"name":"Fire Fire Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vibrant/Jeremy/Shuriken/18707629.jpg","createDate":{"time":1354658488000,"minutes":1,"seconds":28,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vibrant/Jeremy/Shuriken/18707629.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11743,"difficulty":1.5836577512301921,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13422,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.351977,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Larry Paradox","authId":"","name":"Jolly Larry Paradox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Larry Paradox","authId":"","name":"Jolly Larry Paradox","CNNId":"","myGameChains":null,"banStatus":null},"id":18640067,"name":"Bloxx Echo BallWeevil","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jolly/Larry/Paradox/18640067.jpg","createDate":{"time":1354300583000,"minutes":36,"seconds":23,"hours":13,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jolly/Larry/Paradox/18640067.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5979,"difficulty":2.510447414369964,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10531,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.350939,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Henry Atlas","authId":"","name":"Frugal Henry Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Henry Atlas","authId":"","name":"Frugal Henry Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":18638094,"name":"Turbo Solar Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frugal/Henry/Atlas/18638094.jpg","createDate":{"time":1354278275000,"minutes":24,"seconds":35,"hours":7,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frugal/Henry/Atlas/18638094.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1240,"difficulty":2.0132598880696673,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":113630,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.344618,"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 = '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":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]