[{"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 = '10' 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 Omar Quark","authId":"","name":"Delicate Omar Quark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Delicate Omar Quark","authId":"","name":"Delicate Omar Quark","CNNId":"","myGameChains":null,"banStatus":null},"id":19835529,"name":"Nitro Shadow Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Delicate/Omar/Quark/19835529.jpg","createDate":{"time":1363734997000,"minutes":16,"seconds":37,"hours":19,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Delicate/Omar/Quark/19835529.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27712,"difficulty":2.412483614148506,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37562,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.381425,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Waldo Rebel","authId":"","name":"Abnormal Waldo Rebel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Waldo Rebel","authId":"","name":"Abnormal Waldo Rebel","CNNId":"","myGameChains":null,"banStatus":null},"id":19489433,"name":"Mega Challenge Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abnormal/Waldo/Rebel/19489433.jpg","createDate":{"time":1359918816000,"minutes":13,"seconds":36,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abnormal/Waldo/Rebel/19489433.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6607,"difficulty":2.41202900918433,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9524,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.350266,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Nathan Avocado","authId":"","name":"Alien Nathan Avocado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Nathan Avocado","authId":"","name":"Alien Nathan Avocado","CNNId":"","myGameChains":null,"banStatus":null},"id":19995401,"name":"Atomic Space Burst","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Nathan/Avocado/19995401.jpg","createDate":{"time":1364838704000,"minutes":51,"seconds":44,"hours":13,"month":3,"timezoneOffset":240,"year":113,"day":1,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Nathan/Avocado/19995401.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1932,"difficulty":1.3640801053289973,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3893,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.312461,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colorful Gavin Alien","authId":"","name":"Colorful Gavin Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colorful Gavin Alien","authId":"","name":"Colorful Gavin Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":17712787,"name":"Ben Robot Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colorful/Gavin/Alien/17712787.jpg","createDate":{"time":1348426216000,"minutes":50,"seconds":16,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colorful/Gavin/Alien/17712787.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11639,"difficulty":2.431705568445753,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":147687,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.311451,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Victor Panda","authId":"","name":"Loony Victor Panda","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Victor Panda","authId":"","name":"Loony Victor Panda","CNNId":"","myGameChains":null,"banStatus":null},"id":19967779,"name":"Battle Steel Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loony/Victor/Panda/19967779.jpg","createDate":{"time":1364648139000,"minutes":55,"seconds":39,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loony/Victor/Panda/19967779.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6096,"difficulty":2.2286993779690296,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9153,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.297384,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Skinny Tyler Android","authId":"","name":"Skinny Tyler Android","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Skinny Tyler Android","authId":"","name":"Skinny Tyler Android","CNNId":"","myGameChains":null,"banStatus":null},"id":19933867,"name":"Chill Nova Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Skinny/Tyler/Android/19933867.jpg","createDate":{"time":1364418075000,"minutes":1,"seconds":15,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Skinny/Tyler/Android/19933867.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1978,"difficulty":1.4722479078557233,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8242,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.282783,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Jennifer Pinwheel","authId":"","name":"Evil Jennifer Pinwheel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Jennifer Pinwheel","authId":"","name":"Evil Jennifer Pinwheel","CNNId":"","myGameChains":null,"banStatus":null},"id":19499430,"name":"Ultimate Hex Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evil/Jennifer/Pinwheel/19499430.jpg","createDate":{"time":1360122198000,"minutes":43,"seconds":18,"hours":22,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evil/Jennifer/Pinwheel/19499430.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":54494,"difficulty":2.5571320264430413,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":80605,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.279257,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Benton Neutron","authId":"","name":"Robust Benton Neutron","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Benton Neutron","authId":"","name":"Robust Benton Neutron","CNNId":"","myGameChains":null,"banStatus":null},"id":18345292,"name":"Mega Plasma Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Robust/Benton/Neutron/18345292.jpg","createDate":{"time":1351807486000,"minutes":4,"seconds":46,"hours":18,"month":10,"timezoneOffset":240,"year":112,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Robust/Benton/Neutron/18345292.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1333,"difficulty":1.6720583912177374,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7634,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.2598,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Bob Electron","authId":"","name":"Crazy Bob Electron","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Bob Electron","authId":"","name":"Crazy Bob Electron","CNNId":"","myGameChains":null,"banStatus":null},"id":19364383,"name":"Hyper Patrol Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Bob/Electron/19364383.jpg","createDate":{"time":1357962419000,"minutes":46,"seconds":59,"hours":22,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Bob/Electron/19364383.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":991,"difficulty":1.8179869397292765,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15903,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.250213,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Horrid Angela Catapult","authId":"","name":"Horrid Angela Catapult","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Horrid Angela Catapult","authId":"","name":"Horrid Angela Catapult","CNNId":"","myGameChains":null,"banStatus":null},"id":19632193,"name":"Smash Rescue Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Horrid/Angela/Catapult/19632193.jpg","createDate":{"time":1362410950000,"minutes":29,"seconds":10,"hours":10,"month":2,"timezoneOffset":300,"year":113,"day":1,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Horrid/Angela/Catapult/19632193.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1292,"difficulty":2.8287738813474106,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9043,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.249449,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"141","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 = '10' 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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]