[{"getBestRatedByGoal":{"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 \"Goal.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.goalId = '3' 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":"Abnormal Spencer Magma","authId":"","name":"Abnormal Spencer Magma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Spencer Magma","authId":"","name":"Abnormal Spencer Magma","CNNId":"","myGameChains":null,"banStatus":null},"id":19445891,"name":"Battle Quake Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abnormal/Spencer/Magma/19445891.jpg","createDate":{"time":1359179819000,"minutes":56,"seconds":59,"hours":0,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abnormal/Spencer/Magma/19445891.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15355,"difficulty":1.3371805301634512,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61801,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.495779,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eager Ryan Isotope","authId":"","name":"Eager Ryan Isotope","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eager Ryan Isotope","authId":"","name":"Eager Ryan Isotope","CNNId":"","myGameChains":null,"banStatus":null},"id":18280062,"name":"Humungousaur Warrior Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eager/Ryan/Isotope/18280062.jpg","createDate":{"time":1351311163000,"minutes":12,"seconds":43,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eager/Ryan/Isotope/18280062.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3232,"difficulty":2.757496430925766,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74739,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.486113,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Putrid Lila Particle","authId":"","name":"Putrid Lila Particle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Putrid Lila Particle","authId":"","name":"Putrid Lila Particle","CNNId":"","myGameChains":null,"banStatus":null},"id":18279992,"name":"Siege Siege Whirlwind","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Putrid/Lila/Particle/18279992.jpg","createDate":{"time":1351310789000,"minutes":6,"seconds":29,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Putrid/Lila/Particle/18279992.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12507,"difficulty":2.205239549525258,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":109376,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.480887,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Caissa Gumdrop","authId":"","name":"Keen Caissa Gumdrop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Caissa Gumdrop","authId":"","name":"Keen Caissa Gumdrop","CNNId":"","myGameChains":null,"banStatus":null},"id":18747975,"name":"Gear Warp Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Keen/Caissa/Gumdrop/18747975.jpg","createDate":{"time":1354783045000,"minutes":37,"seconds":25,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Keen/Caissa/Gumdrop/18747975.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":31797,"difficulty":2.4783909024089668,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":331675,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.455329,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Larry Ion","authId":"","name":"Icy Larry Ion","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Larry Ion","authId":"","name":"Icy Larry Ion","CNNId":"","myGameChains":null,"banStatus":null},"id":17214721,"name":"Star Atomic Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Larry/Ion/17214721.jpg","createDate":{"time":1342131070000,"minutes":11,"seconds":10,"hours":18,"month":6,"timezoneOffset":240,"year":112,"day":4,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Larry/Ion/17214721.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":153271,"difficulty":2.4941981792370043,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1484039,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":575,"rating":4.45478,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Alex Genius","authId":"","name":"Super Alex Genius","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Alex Genius","authId":"","name":"Super Alex Genius","CNNId":"","myGameChains":null,"banStatus":null},"id":19641490,"name":"Invasion Alien Pulse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Alex/Genius/19641490.jpg","createDate":{"time":1362692672000,"minutes":44,"seconds":32,"hours":16,"month":2,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Alex/Genius/19641490.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2514,"difficulty":2.2668947151351757,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":170460,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.452459,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blustery Dominic Toboggan","authId":"","name":"Blustery Dominic Toboggan","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blustery Dominic Toboggan","authId":"","name":"Blustery Dominic Toboggan","CNNId":"","myGameChains":null,"banStatus":null},"id":17793478,"name":"Alien Big Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blustery/Dominic/Toboggan/17793478.jpg","createDate":{"time":1348721371000,"minutes":49,"seconds":31,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blustery/Dominic/Toboggan/17793478.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16348,"difficulty":1.8021920573867471,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":78763,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.452389,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Alex Waffle","authId":"","name":"Alien Alex Waffle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Alex Waffle","authId":"","name":"Alien Alex Waffle","CNNId":"","myGameChains":null,"banStatus":null},"id":19540906,"name":"Challenge Racer Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Alex/Waffle/19540906.jpg","createDate":{"time":1360877629000,"minutes":33,"seconds":49,"hours":16,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Alex/Waffle/19540906.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15395,"difficulty":2.214285816492981,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":70272,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.435013,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Daring Jordan Toboggan","authId":"","name":"Daring Jordan Toboggan","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Daring Jordan Toboggan","authId":"","name":"Daring Jordan Toboggan","CNNId":"","myGameChains":null,"banStatus":null},"id":17587312,"name":"Spidermonkey Steel Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Daring/Jordan/Toboggan/17587312.jpg","createDate":{"time":1348258892000,"minutes":21,"seconds":32,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Daring/Jordan/Toboggan/17587312.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8563,"difficulty":1.884472400226435,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":101911,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.434351,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Brittany Seesaw","authId":"","name":"Baroness Brittany Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Brittany Seesaw","authId":"","name":"Baroness Brittany Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"id":18170659,"name":"Champion Chase Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baroness/Brittany/Seesaw/18170659.jpg","createDate":{"time":1350379403000,"minutes":23,"seconds":23,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baroness/Brittany/Seesaw/18170659.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2944,"difficulty":2.7258603702254995,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":131598,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.416838,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"71","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.goalId = '3' 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":"80","currentPageToDisplay":8,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]