[{"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 = '1' 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":"Swift Matthew Cobra","authId":"","name":"Swift Matthew Cobra","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Swift Matthew Cobra","authId":"","name":"Swift Matthew Cobra","CNNId":"","myGameChains":null,"banStatus":null},"id":19566049,"name":"Swampfire Rush Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Swift/Matthew/Cobra/19566049.jpg","createDate":{"time":1361214609000,"minutes":10,"seconds":9,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Swift/Matthew/Cobra/19566049.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"difficulty":2.4166666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3831,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Scruffy Anthony Mercury","authId":"","name":"Scruffy Anthony Mercury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scruffy Anthony Mercury","authId":"","name":"Scruffy Anthony Mercury","CNNId":"","myGameChains":null,"banStatus":null},"id":18287513,"name":"Hero Laser Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scruffy/Anthony/Mercury/18287513.jpg","createDate":{"time":1351357975000,"minutes":12,"seconds":55,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scruffy/Anthony/Mercury/18287513.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":511,"difficulty":1.88,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1718,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.48,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Volcanic Clyde Tiger","authId":"","name":"Volcanic Clyde Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Volcanic Clyde Tiger","authId":"","name":"Volcanic Clyde Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":18287490,"name":"Whirlwind Universe Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Volcanic/Clyde/Tiger/18287490.jpg","createDate":{"time":1351357892000,"minutes":11,"seconds":32,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Volcanic/Clyde/Tiger/18287490.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":766,"difficulty":1.2299107142857142,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1176,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.472321,"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":18260377,"name":"Champion Alien Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gentle/Wolfgang/Gumshoe/18260377.jpg","createDate":{"time":1351155492000,"minutes":58,"seconds":12,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gentle/Wolfgang/Gumshoe/18260377.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":961,"difficulty":1.3333333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1240,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.42,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tough Zelda Cipher","authId":"","name":"Tough Zelda Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tough Zelda Cipher","authId":"","name":"Tough Zelda Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":18127764,"name":"Warp Atomic Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tough/Zelda/Cipher/18127764.jpg","createDate":{"time":1350158676000,"minutes":4,"seconds":36,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tough/Zelda/Cipher/18127764.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":352,"difficulty":2.5046683848622906,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10780,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.405605,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Douglas Wyvern","authId":"","name":"Fabulous Douglas Wyvern","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Douglas Wyvern","authId":"","name":"Fabulous Douglas Wyvern","CNNId":"","myGameChains":null,"banStatus":null},"id":18351656,"name":"Laser Search Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fabulous/Douglas/Wyvern/18351656.jpg","createDate":{"time":1351880263000,"minutes":17,"seconds":43,"hours":14,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fabulous/Douglas/Wyvern/18351656.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":283,"difficulty":1.8916666666666666,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1367,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.38,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Metallic Ben Umbrella","authId":"","name":"Metallic Ben Umbrella","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Metallic Ben Umbrella","authId":"","name":"Metallic Ben Umbrella","CNNId":"","myGameChains":null,"banStatus":null},"id":18429336,"name":"Rampage Rescue Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Metallic/Ben/Umbrella/18429336.jpg","createDate":{"time":1352506413000,"minutes":13,"seconds":33,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Metallic/Ben/Umbrella/18429336.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":446,"difficulty":1.3428571428571427,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1184,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.369643,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Milo Ooze","authId":"","name":"Toxic Milo Ooze","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Milo Ooze","authId":"","name":"Toxic Milo Ooze","CNNId":"","myGameChains":null,"banStatus":null},"id":17622763,"name":"Droid Fury Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Milo/Ooze/17622763.jpg","createDate":{"time":1348315768000,"minutes":9,"seconds":28,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Milo/Ooze/17622763.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":166,"difficulty":1.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1255,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Mitchell Avator","authId":"","name":"Comical Mitchell Avator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Mitchell Avator","authId":"","name":"Comical Mitchell Avator","CNNId":"","myGameChains":null,"banStatus":null},"id":17622894,"name":"Ultra Universe Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Comical/Mitchell/Avator/17622894.jpg","createDate":{"time":1348315969000,"minutes":12,"seconds":49,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Comical/Mitchell/Avator/17622894.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1089,"difficulty":1.3009120502831926,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17402,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.305642,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Waldo Bonkers","authId":"","name":"Kinetic Waldo Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Waldo Bonkers","authId":"","name":"Kinetic Waldo Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"id":19899568,"name":"Fire Power Swampfire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Kinetic/Waldo/Bonkers/19899568.jpg","createDate":{"time":1364157401000,"minutes":36,"seconds":41,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Kinetic/Waldo/Bonkers/19899568.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1744,"difficulty":1.3874809391501184,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8399,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.298728,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"171","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 = '1' 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":"180","currentPageToDisplay":18,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]