[{"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 = '8' 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":"Creepy Andre Dinosaur","authId":"","name":"Creepy Andre Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creepy Andre Dinosaur","authId":"","name":"Creepy Andre Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":19208511,"name":"Blaster Target Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creepy/Andre/Dinosaur/19208511.jpg","createDate":{"time":1356614570000,"minutes":22,"seconds":50,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creepy/Andre/Dinosaur/19208511.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2820,"difficulty":1.2764378478664193,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3338,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.125699,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Verbose Liam Riddle","authId":"","name":"Verbose Liam Riddle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Verbose Liam Riddle","authId":"","name":"Verbose Liam Riddle","CNNId":"","myGameChains":null,"banStatus":null},"id":18402620,"name":"Stone Iron Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Verbose/Liam/Riddle/18402620.jpg","createDate":{"time":1352223716000,"minutes":41,"seconds":56,"hours":12,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Verbose/Liam/Riddle/18402620.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26798,"difficulty":1.1639781099984212,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":48230,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.115539,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Diego Steel","authId":"","name":"Bouncing Diego Steel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Diego Steel","authId":"","name":"Bouncing Diego Steel","CNNId":"","myGameChains":null,"banStatus":null},"id":18127663,"name":"Streak Big Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bouncing/Diego/Steel/18127663.jpg","createDate":{"time":1350158465000,"minutes":1,"seconds":5,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bouncing/Diego/Steel/18127663.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":248,"difficulty":1.5416666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2070,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.0625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Obscure Isabelle Martian","authId":"","name":"Obscure Isabelle Martian","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Obscure Isabelle Martian","authId":"","name":"Obscure Isabelle Martian","CNNId":"","myGameChains":null,"banStatus":null},"id":17216452,"name":"Solar Adventure Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Obscure/Isabelle/Martian/17216452.jpg","createDate":{"time":1342181571000,"minutes":12,"seconds":51,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Obscure/Isabelle/Martian/17216452.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2126,"difficulty":1.6198412698412699,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2208,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.002721,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Sofia Sunrise","authId":"","name":"Comical Sofia Sunrise","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Sofia Sunrise","authId":"","name":"Comical Sofia Sunrise","CNNId":"","myGameChains":null,"banStatus":null},"id":18260516,"name":"Escape Cannonbolt Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Comical/Sofia/Sunrise/18260516.jpg","createDate":{"time":1351157389000,"minutes":29,"seconds":49,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Comical/Sofia/Sunrise/18260516.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1775,"difficulty":1.8853462194300064,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6949,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.941867,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Katelyn Iguana","authId":"","name":"Nifty Katelyn Iguana","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Katelyn Iguana","authId":"","name":"Nifty Katelyn Iguana","CNNId":"","myGameChains":null,"banStatus":null},"id":17419906,"name":"Steel Invasion Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nifty/Katelyn/Iguana/17419906.jpg","createDate":{"time":1347821047000,"minutes":44,"seconds":7,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nifty/Katelyn/Iguana/17419906.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30105,"difficulty":2.264157888728523,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":244046,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.929003,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Aidan Acrobat","authId":"","name":"Academic Aidan Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Aidan Acrobat","authId":"","name":"Academic Aidan Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"id":19532759,"name":"Adventure Adventure Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Aidan/Acrobat/19532759.jpg","createDate":{"time":1360707908000,"minutes":25,"seconds":8,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Aidan/Acrobat/19532759.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":361,"difficulty":1.5142857142857142,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2708,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.92,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baron Hunter Amoeba","authId":"","name":"Baron Hunter Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baron Hunter Amoeba","authId":"","name":"Baron Hunter Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"id":17521457,"name":"Smash Crusher Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baron/Hunter/Amoeba/17521457.jpg","createDate":{"time":1348091863000,"minutes":57,"seconds":43,"hours":17,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baron/Hunter/Amoeba/17521457.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11368,"difficulty":1.6584541707479996,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":312257,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.848458,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Jonas Dinosaur","authId":"","name":"Fiery Jonas Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Jonas Dinosaur","authId":"","name":"Fiery Jonas Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":19721458,"name":"Nitro Fury Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fiery/Jonas/Dinosaur/19721458.jpg","createDate":{"time":1363262356000,"minutes":59,"seconds":16,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fiery/Jonas/Dinosaur/19721458.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8955,"difficulty":1.9681749257541534,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61387,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.837154,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Savage Maxwell Bullfrog","authId":"","name":"Savage Maxwell Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Savage Maxwell Bullfrog","authId":"","name":"Savage Maxwell Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"id":19721469,"name":"Patrol Echo Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Savage/Maxwell/Bullfrog/19721469.jpg","createDate":{"time":1363262395000,"minutes":59,"seconds":55,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Savage/Maxwell/Bullfrog/19721469.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12312,"difficulty":1.5957834103868243,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39594,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.810829,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"161","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 = '8' 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":"170","currentPageToDisplay":17,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]