[{"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 = '11' 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":"Devious Connor Whisper","authId":"","name":"Devious Connor Whisper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Devious Connor Whisper","authId":"","name":"Devious Connor Whisper","CNNId":"","myGameChains":null,"banStatus":null},"id":17810982,"name":"Galaxy Solar Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Devious/Connor/Whisper/17810982.jpg","createDate":{"time":1348811239000,"minutes":47,"seconds":19,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Devious/Connor/Whisper/17810982.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":326,"difficulty":2.326401142666898,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":23426,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.455495,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Adrian Lime","authId":"","name":"Ruthless Adrian Lime","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Adrian Lime","authId":"","name":"Ruthless Adrian Lime","CNNId":"","myGameChains":null,"banStatus":null},"id":17736856,"name":"Iron Burst Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ruthless/Adrian/Lime/17736856.jpg","createDate":{"time":1348464146000,"minutes":22,"seconds":26,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ruthless/Adrian/Lime/17736856.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7705,"difficulty":2.596260475279668,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26604,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.451456,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amusing Antonio Cyborg","authId":"","name":"Amusing Antonio Cyborg","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amusing Antonio Cyborg","authId":"","name":"Amusing Antonio Cyborg","CNNId":"","myGameChains":null,"banStatus":null},"id":17683449,"name":"Ambush Racer Feedback","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amusing/Antonio/Cyborg/17683449.jpg","createDate":{"time":1348374079000,"minutes":21,"seconds":19,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amusing/Antonio/Cyborg/17683449.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21153,"difficulty":1.7532165746049257,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":170136,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.446886,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Marco Bingo","authId":"","name":"Ancient Marco Bingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Marco Bingo","authId":"","name":"Ancient Marco Bingo","CNNId":"","myGameChains":null,"banStatus":null},"id":17956033,"name":"Power Ambush Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Marco/Bingo/17956033.jpg","createDate":{"time":1349365312000,"minutes":41,"seconds":52,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Marco/Bingo/17956033.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":692,"difficulty":2.7407320209139163,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":25646,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.436345,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Ray Tiger","authId":"","name":"Superb Ray Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Ray Tiger","authId":"","name":"Superb Ray Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":18170656,"name":"Rustbucket Rescue Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superb/Ray/Tiger/18170656.jpg","createDate":{"time":1350379385000,"minutes":23,"seconds":5,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superb/Ray/Tiger/18170656.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2271,"difficulty":2.5120317345783842,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":102227,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.433478,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Leo Pontoon","authId":"","name":"Aromatic Leo Pontoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Leo Pontoon","authId":"","name":"Aromatic Leo Pontoon","CNNId":"","myGameChains":null,"banStatus":null},"id":17542160,"name":"Thunder Patrol Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aromatic/Leo/Pontoon/17542160.jpg","createDate":{"time":1348148600000,"minutes":43,"seconds":20,"hours":9,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aromatic/Leo/Pontoon/17542160.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3296,"difficulty":2.2143004813448908,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":21340,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.429374,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Eric Yoyo","authId":"","name":"Ancient Eric Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Eric Yoyo","authId":"","name":"Ancient Eric Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":17687360,"name":"Razor Hero Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Eric/Yoyo/17687360.jpg","createDate":{"time":1348391646000,"minutes":14,"seconds":6,"hours":5,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Eric/Yoyo/17687360.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2171,"difficulty":2.5643642358944256,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27357,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.428228,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Brittany Seesaw","authId":"","name":"Baroness Brittany Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Brittany Seesaw","authId":"","name":"Baroness Brittany Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"id":18170659,"name":"Champion Chase Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baroness/Brittany/Seesaw/18170659.jpg","createDate":{"time":1350379403000,"minutes":23,"seconds":23,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baroness/Brittany/Seesaw/18170659.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2944,"difficulty":2.7258603702254995,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":131598,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.416838,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cagey Herman Techno","authId":"","name":"Cagey Herman Techno","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cagey Herman Techno","authId":"","name":"Cagey Herman Techno","CNNId":"","myGameChains":null,"banStatus":null},"id":19281762,"name":"Adventure Burst Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cagey/Herman/Techno/19281762.jpg","createDate":{"time":1357058824000,"minutes":47,"seconds":4,"hours":11,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cagey/Herman/Techno/19281762.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14462,"difficulty":1.3839499683088436,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":48392,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.413596,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Ulysses Virtuoso","authId":"","name":"Crazy Ulysses Virtuoso","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Ulysses Virtuoso","authId":"","name":"Crazy Ulysses Virtuoso","CNNId":"","myGameChains":null,"banStatus":null},"id":18676370,"name":"Quake Rampage Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Ulysses/Virtuoso/18676370.jpg","createDate":{"time":1354550267000,"minutes":57,"seconds":47,"hours":10,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Ulysses/Virtuoso/18676370.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3788,"difficulty":2.096690946980892,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19349,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.412992,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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 = '11' 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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]