[{"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 = '7' 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":"Awful Antonio Lime","authId":"","name":"Awful Antonio Lime","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awful Antonio Lime","authId":"","name":"Awful Antonio Lime","CNNId":"","myGameChains":null,"banStatus":null},"id":18098346,"name":"Atomic Alien Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awful/Antonio/Lime/18098346.jpg","createDate":{"time":1350037580000,"minutes":26,"seconds":20,"hours":6,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awful/Antonio/Lime/18098346.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":206,"difficulty":1.3938492063492065,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3272,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.551515,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Lloyd Whizbang","authId":"","name":"Toxic Lloyd Whizbang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Lloyd Whizbang","authId":"","name":"Toxic Lloyd Whizbang","CNNId":"","myGameChains":null,"banStatus":null},"id":19089545,"name":"Alien Turbo Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Lloyd/Whizbang/19089545.jpg","createDate":{"time":1355993070000,"minutes":44,"seconds":30,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Lloyd/Whizbang/19089545.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":415,"difficulty":2.730612244897959,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3348,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.544643,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Kylie Cookie","authId":"","name":"Stormy Kylie Cookie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Kylie Cookie","authId":"","name":"Stormy Kylie Cookie","CNNId":"","myGameChains":null,"banStatus":null},"id":19461312,"name":"Cosmic Alien Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stormy/Kylie/Cookie/19461312.jpg","createDate":{"time":1359369835000,"minutes":43,"seconds":55,"hours":5,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stormy/Kylie/Cookie/19461312.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":387,"difficulty":2.7399999999999998,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2599,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.541667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Freakish Simon Noob","authId":"","name":"Freakish Simon Noob","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Freakish Simon Noob","authId":"","name":"Freakish Simon Noob","CNNId":"","myGameChains":null,"banStatus":null},"id":18488207,"name":"Atomic Laser Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Freakish/Simon/Noob/18488207.jpg","createDate":{"time":1353022434000,"minutes":33,"seconds":54,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Freakish/Simon/Noob/18488207.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":63,"difficulty":2.8,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1614,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.541667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Yucky Dewey Jupiter","authId":"","name":"Yucky Dewey Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Yucky Dewey Jupiter","authId":"","name":"Yucky Dewey Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"id":19326708,"name":"Target Steel Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Yucky/Dewey/Jupiter/19326708.jpg","createDate":{"time":1357424264000,"minutes":17,"seconds":44,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Yucky/Dewey/Jupiter/19326708.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":635,"difficulty":2.705705009276438,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9654,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.537171,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Amber Eel","authId":"","name":"Ruthless Amber Eel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Amber Eel","authId":"","name":"Ruthless Amber Eel","CNNId":"","myGameChains":null,"banStatus":null},"id":18004854,"name":"Charge Adventure Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ruthless/Amber/Eel/18004854.jpg","createDate":{"time":1349554259000,"minutes":10,"seconds":59,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ruthless/Amber/Eel/18004854.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1324,"difficulty":2.1951863128896623,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9692,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.504489,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Classic Sophie Firefly","authId":"","name":"Classic Sophie Firefly","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Classic Sophie Firefly","authId":"","name":"Classic Sophie Firefly","CNNId":"","myGameChains":null,"banStatus":null},"id":18558000,"name":"Ambush Invasion Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Classic/Sophie/Firefly/18558000.jpg","createDate":{"time":1353625973000,"minutes":12,"seconds":53,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Classic/Sophie/Firefly/18558000.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":46,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":818,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Erin Whisper","authId":"","name":"Groovy Erin Whisper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Erin Whisper","authId":"","name":"Groovy Erin Whisper","CNNId":"","myGameChains":null,"banStatus":null},"id":19540706,"name":"Omniverse Crusher Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Groovy/Erin/Whisper/19540706.jpg","createDate":{"time":1360874156000,"minutes":35,"seconds":56,"hours":15,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Groovy/Erin/Whisper/19540706.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":202,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":690,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Chuck Brick","authId":"","name":"Keen Chuck Brick","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Chuck Brick","authId":"","name":"Keen Chuck Brick","CNNId":"","myGameChains":null,"banStatus":null},"id":19436513,"name":"Mega Giga Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Keen/Chuck/Brick/19436513.jpg","createDate":{"time":1359020884000,"minutes":48,"seconds":4,"hours":4,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Keen/Chuck/Brick/19436513.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":250,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Freddy Fez","authId":"","name":"Icy Freddy Fez","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Freddy Fez","authId":"","name":"Icy Freddy Fez","CNNId":"","myGameChains":null,"banStatus":null},"id":19279357,"name":"Universe Metal Danger","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Freddy/Fez/19279357.jpg","createDate":{"time":1357038786000,"minutes":13,"seconds":6,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Freddy/Fez/19279357.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1225,"difficulty":1.7088094821325932,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8726,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.4984,"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 = '7' 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"}}]