[{"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":"Bold Bob Volcano","authId":"","name":"Bold Bob Volcano","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Bob Volcano","authId":"","name":"Bold Bob Volcano","CNNId":"","myGameChains":null,"banStatus":null},"id":18170590,"name":"Ambush Pulse Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Bob/Volcano/18170590.jpg","createDate":{"time":1350377582000,"minutes":53,"seconds":2,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Bob/Volcano/18170590.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":528,"difficulty":1.8179012345679013,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2247,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.472222,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gentle Wolfgang Gumshoe","authId":"","name":"Gentle Wolfgang Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gentle Wolfgang Gumshoe","authId":"","name":"Gentle Wolfgang Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":18260520,"name":"Rumble Alien Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gentle/Wolfgang/Gumshoe/18260520.jpg","createDate":{"time":1351157462000,"minutes":31,"seconds":2,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gentle/Wolfgang/Gumshoe/18260520.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":305,"difficulty":1.6122414832642105,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11080,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.457933,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gullible William Kazoo","authId":"","name":"Gullible William Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gullible William Kazoo","authId":"","name":"Gullible William Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"id":19053552,"name":"Rush Stone Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gullible/William/Kazoo/19053552.jpg","createDate":{"time":1355747025000,"minutes":23,"seconds":45,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gullible/William/Kazoo/19053552.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2681,"difficulty":1.3965804350426845,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39179,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.43767,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Happy Kristin Diamond","authId":"","name":"Happy Kristin Diamond","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Happy Kristin Diamond","authId":"","name":"Happy Kristin Diamond","CNNId":"","myGameChains":null,"banStatus":null},"id":19564859,"name":"Streak Cannonbolt Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Happy/Kristin/Diamond/19564859.jpg","createDate":{"time":1361205686000,"minutes":41,"seconds":26,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Happy/Kristin/Diamond/19564859.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8983,"difficulty":2.1201600423885614,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":23353,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.346708,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble William Larva","authId":"","name":"Humble William Larva","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble William Larva","authId":"","name":"Humble William Larva","CNNId":"","myGameChains":null,"banStatus":null},"id":17736847,"name":"Adventure Atomic Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humble/William/Larva/17736847.jpg","createDate":{"time":1348463980000,"minutes":19,"seconds":40,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humble/William/Larva/17736847.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":765,"difficulty":1.14421768707483,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3399,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.211111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Forrest Warrior","authId":"","name":"Ancient Forrest Warrior","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Forrest Warrior","authId":"","name":"Ancient Forrest Warrior","CNNId":"","myGameChains":null,"banStatus":null},"id":17793471,"name":"Charge Nitro Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Forrest/Warrior/17793471.jpg","createDate":{"time":1348721211000,"minutes":46,"seconds":51,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Forrest/Warrior/17793471.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13840,"difficulty":2.7373231213610962,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27596,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.209105,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Jared Baloney","authId":"","name":"Atomic Jared Baloney","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Jared Baloney","authId":"","name":"Atomic Jared Baloney","CNNId":"","myGameChains":null,"banStatus":null},"id":19721463,"name":"Search Razor Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Jared/Baloney/19721463.jpg","createDate":{"time":1363262374000,"minutes":59,"seconds":34,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Jared/Baloney/19721463.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17886,"difficulty":2.4804855473309324,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":20213,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.181096,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Bruce Dynamite","authId":"","name":"Toxic Bruce Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Bruce Dynamite","authId":"","name":"Toxic Bruce Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"id":17622957,"name":"Fury Chill Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Bruce/Dynamite/17622957.jpg","createDate":{"time":1348316054000,"minutes":14,"seconds":14,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Bruce/Dynamite/17622957.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17267,"difficulty":1.6400314597923626,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24485,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.161531,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Normal Pedro Galoot","authId":"","name":"Normal Pedro Galoot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Normal Pedro Galoot","authId":"","name":"Normal Pedro Galoot","CNNId":"","myGameChains":null,"banStatus":null},"id":19360730,"name":"Gear Blaster Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Normal/Pedro/Galoot/19360730.jpg","createDate":{"time":1357924554000,"minutes":15,"seconds":54,"hours":12,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Normal/Pedro/Galoot/19360730.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3477,"difficulty":2.6699393801053843,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":45519,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.143752,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Elly Eggplant","authId":"","name":"Dormant Elly Eggplant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Elly Eggplant","authId":"","name":"Dormant Elly Eggplant","CNNId":"","myGameChains":null,"banStatus":null},"id":18930508,"name":"Adventure Ultra Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dormant/Elly/Eggplant/18930508.jpg","createDate":{"time":1355228928000,"minutes":28,"seconds":48,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dormant/Elly/Eggplant/18930508.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2405,"difficulty":1.5687074829931973,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3002,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.140894,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"151","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":"160","currentPageToDisplay":16,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]