[{"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 = '13' 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":"Skinny Josiah Possum","authId":"","name":"Skinny Josiah Possum","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Skinny Josiah Possum","authId":"","name":"Skinny Josiah Possum","CNNId":"","myGameChains":null,"banStatus":null},"id":19222551,"name":"Water Adventure Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Skinny/Josiah/Possum/19222551.jpg","createDate":{"time":1356700202000,"minutes":10,"seconds":2,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Skinny/Josiah/Possum/19222551.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12898,"difficulty":1.6445347495354155,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14322,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.349058,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Lawrence Jamboree","authId":"","name":"Infamous Lawrence Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Lawrence Jamboree","authId":"","name":"Infamous Lawrence Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"id":18675499,"name":"Power Shock Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Infamous/Lawrence/Jamboree/18675499.jpg","createDate":{"time":1354543551000,"minutes":5,"seconds":51,"hours":9,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Infamous/Lawrence/Jamboree/18675499.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":23199,"difficulty":1.320543294929432,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":148948,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.340625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Zachary Weasel","authId":"","name":"Bold Zachary Weasel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Zachary Weasel","authId":"","name":"Bold Zachary Weasel","CNNId":"","myGameChains":null,"banStatus":null},"id":19556003,"name":"Droid Siege Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Zachary/Weasel/19556003.jpg","createDate":{"time":1361077341000,"minutes":2,"seconds":21,"hours":0,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Zachary/Weasel/19556003.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15598,"difficulty":1.7276027492311543,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":22782,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.193127,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Max Howler","authId":"","name":"Edgy Max Howler","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Max Howler","authId":"","name":"Edgy Max Howler","CNNId":"","myGameChains":null,"banStatus":null},"id":19173359,"name":"Adventure BallWeevil Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Edgy/Max/Howler/19173359.jpg","createDate":{"time":1356366986000,"minutes":36,"seconds":26,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Edgy/Max/Howler/19173359.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":42103,"difficulty":1.4487012374173451,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":59792,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.189421,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shady Sabrina Samurai","authId":"","name":"Shady Sabrina Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shady Sabrina Samurai","authId":"","name":"Shady Sabrina Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":19089507,"name":"Nova Battle Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shady/Sabrina/Samurai/19089507.jpg","createDate":{"time":1355991956000,"minutes":25,"seconds":56,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shady/Sabrina/Samurai/19089507.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":35175,"difficulty":1.6592630227822316,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":155921,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.185824,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Bryce Llama","authId":"","name":"Sturdy Bryce Llama","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Bryce Llama","authId":"","name":"Sturdy Bryce Llama","CNNId":"","myGameChains":null,"banStatus":null},"id":18676412,"name":"Ben Mega Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sturdy/Bryce/Llama/18676412.jpg","createDate":{"time":1354550438000,"minutes":0,"seconds":38,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sturdy/Bryce/Llama/18676412.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17927,"difficulty":1.0798729808327021,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19111,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.113123,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reliable Marie Orca","authId":"","name":"Reliable Marie Orca","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reliable Marie Orca","authId":"","name":"Reliable Marie Orca","CNNId":"","myGameChains":null,"banStatus":null},"id":19579228,"name":"Burst Cosmic Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reliable/Marie/Orca/19579228.jpg","createDate":{"time":1361455527000,"minutes":5,"seconds":27,"hours":9,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reliable/Marie/Orca/19579228.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1419,"difficulty":2.4334791417072132,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39168,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.089222,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Caden Sparkle","authId":"","name":"Loony Caden Sparkle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Caden Sparkle","authId":"","name":"Loony Caden Sparkle","CNNId":"","myGameChains":null,"banStatus":null},"id":19298653,"name":"Adventure Nitro Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loony/Caden/Sparkle/19298653.jpg","createDate":{"time":1357170770000,"minutes":52,"seconds":50,"hours":18,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loony/Caden/Sparkle/19298653.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15272,"difficulty":2.3560903570895366,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":54787,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.93534,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gracious Lillian Photon","authId":"","name":"Gracious Lillian Photon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gracious Lillian Photon","authId":"","name":"Gracious Lillian Photon","CNNId":"","myGameChains":null,"banStatus":null},"id":19583934,"name":"Force Adventure Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gracious/Lillian/Photon/19583934.jpg","createDate":{"time":1361542848000,"minutes":20,"seconds":48,"hours":9,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gracious/Lillian/Photon/19583934.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1396,"difficulty":1.7786537019617612,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31870,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.89767,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Hailey Jupiter","authId":"","name":"Frugal Hailey Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Hailey Jupiter","authId":"","name":"Frugal Hailey Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"id":19401387,"name":"Siege Rush Nova","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frugal/Hailey/Jupiter/19401387.jpg","createDate":{"time":1358532062000,"minutes":1,"seconds":2,"hours":13,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frugal/Hailey/Jupiter/19401387.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22062,"difficulty":1.7573319927617213,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31874,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.570674,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"191","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 = '13' 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":"200","currentPageToDisplay":20,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]