[{"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 = '2' 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":"Loud Bryan Bolt","authId":"","name":"Loud Bryan Bolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Bryan Bolt","authId":"","name":"Loud Bryan Bolt","CNNId":"","myGameChains":null,"banStatus":null},"id":19589947,"name":"Alien Pursuit Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Bryan/Bolt/19589947.jpg","createDate":{"time":1361632311000,"minutes":11,"seconds":51,"hours":10,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Bryan/Bolt/19589947.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8384,"difficulty":2.172983313668111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15867,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.928416,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Keith Panda","authId":"","name":"Doctor Keith Panda","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Keith Panda","authId":"","name":"Doctor Keith Panda","CNNId":"","myGameChains":null,"banStatus":null},"id":19544595,"name":"Search Ultimate Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Doctor/Keith/Panda/19544595.jpg","createDate":{"time":1360947762000,"minutes":2,"seconds":42,"hours":12,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Doctor/Keith/Panda/19544595.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2536,"difficulty":1.9587159777475343,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47155,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.904511,"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":18260557,"name":"Charge Alien Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gentle/Wolfgang/Gumshoe/18260557.jpg","createDate":{"time":1351158022000,"minutes":40,"seconds":22,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gentle/Wolfgang/Gumshoe/18260557.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4439,"difficulty":2.256028394825436,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39633,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.889964,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eastern Connie Quasar","authId":"","name":"Eastern Connie Quasar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eastern Connie Quasar","authId":"","name":"Eastern Connie Quasar","CNNId":"","myGameChains":null,"banStatus":null},"id":18514949,"name":"Robot Robot Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eastern/Connie/Quasar/18514949.jpg","createDate":{"time":1353273997000,"minutes":26,"seconds":37,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eastern/Connie/Quasar/18514949.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2067,"difficulty":2.111492914979757,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5924,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.856592,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Stephen Javelin","authId":"","name":"Brisk Stephen Javelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Stephen Javelin","authId":"","name":"Brisk Stephen Javelin","CNNId":"","myGameChains":null,"banStatus":null},"id":19264741,"name":"Nano Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Stephen/Javelin/19264741.jpg","createDate":{"time":1356954051000,"minutes":40,"seconds":51,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Stephen/Javelin/19264741.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1106,"difficulty":2.1017528044871794,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8735,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.853191,"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":"Soggy Drake Jungle","authId":"","name":"Soggy Drake Jungle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Drake Jungle","authId":"","name":"Soggy Drake Jungle","CNNId":"","myGameChains":null,"banStatus":null},"id":18930360,"name":"Adventure Hex Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Soggy/Drake/Jungle/18930360.jpg","createDate":{"time":1355227879000,"minutes":11,"seconds":19,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Soggy/Drake/Jungle/18930360.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":40733,"difficulty":1.1900913260971215,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74795,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.804584,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sharp Courtney Basilisk","authId":"","name":"Sharp Courtney Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sharp Courtney Basilisk","authId":"","name":"Sharp Courtney Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"id":18705575,"name":"Dark Universe Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sharp/Courtney/Basilisk/18705575.jpg","createDate":{"time":1354654819000,"minutes":0,"seconds":19,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sharp/Courtney/Basilisk/18705575.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":44851,"difficulty":1.7116559302391008,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":78823,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.802725,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sergeant Oliver Calamari","authId":"","name":"Sergeant Oliver Calamari","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sergeant Oliver Calamari","authId":"","name":"Sergeant Oliver Calamari","CNNId":"","myGameChains":null,"banStatus":null},"id":19588423,"name":"Mega Laser Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sergeant/Oliver/Calamari/19588423.jpg","createDate":{"time":1361603622000,"minutes":13,"seconds":42,"hours":2,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sergeant/Oliver/Calamari/19588423.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12250,"difficulty":1.1414412989830622,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14492,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.800738,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Natalia Snake","authId":"","name":"Towering Natalia Snake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Natalia Snake","authId":"","name":"Towering Natalia Snake","CNNId":"","myGameChains":null,"banStatus":null},"id":18098388,"name":"Target Plasma Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Towering/Natalia/Snake/18098388.jpg","createDate":{"time":1350038201000,"minutes":36,"seconds":41,"hours":6,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Towering/Natalia/Snake/18098388.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7484,"difficulty":1.5254131452894923,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18027,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.785496,"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.goalId = '2' 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"}}]