[{"getMostPopularThisWeek":{"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":198,"SQLFilter":null,"limitStatement":" AND ROWNUM <= 200","totalRecordsSQL":"Select count(*) as \"FromTheVault.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.status = 1 AND GameStat.timesPlayed >= '50' AND createdate <= SYSDATE-'280' AND Game.id = GameStat.gameid order by dbms_random.value) where rownum <= 200) ORDER BY GAME.createdate ASC ) ","list":[{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Ben Monster","authId":"","name":"Weird Ben Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Ben Monster","authId":"","name":"Weird Ben Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":5838530,"name":"Power Defense Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Weird/Ben/Monster/5838530.jpg","createDate":{"time":1218600896000,"minutes":14,"seconds":56,"hours":0,"month":7,"timezoneOffset":240,"year":108,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Weird/Ben/Monster/5838530.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":117,"difficulty":2.7568482653709925,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3359,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.192296,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Jacob Squirrel","authId":"","name":"Weird Jacob Squirrel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Jacob Squirrel","authId":"","name":"Weird Jacob Squirrel","CNNId":"","myGameChains":null,"banStatus":null},"id":5935519,"name":"Vilgax Drone Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Weird/Jacob/Squirrel/5935519.jpg","createDate":{"time":1218982187000,"minutes":9,"seconds":47,"hours":10,"month":7,"timezoneOffset":240,"year":108,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Weird/Jacob/Squirrel/5935519.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":79,"difficulty":2.3333333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":113,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.35,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Noah Storm","authId":"","name":"Weird Noah Storm","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Noah Storm","authId":"","name":"Weird Noah Storm","CNNId":"","myGameChains":null,"banStatus":null},"id":6217330,"name":"Breaker Storm Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Weird/Noah/Storm/6217330.jpg","createDate":{"time":1220327068000,"minutes":44,"seconds":28,"hours":23,"month":8,"timezoneOffset":240,"year":108,"day":1,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Weird/Noah/Storm/6217330.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38,"difficulty":2.1733984533984536,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":249,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.918182,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eager Avery Nacho","authId":"","name":"Eager Avery Nacho","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eager Avery Nacho","authId":"","name":"Eager Avery Nacho","CNNId":"","myGameChains":null,"banStatus":null},"id":6291142,"name":"Drone Doom Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eager/Avery/Nacho/6291142.jpg","createDate":{"time":1220933480000,"minutes":11,"seconds":20,"hours":0,"month":8,"timezoneOffset":240,"year":108,"day":2,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eager/Avery/Nacho/6291142.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":173,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.666667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Ian Ketchup","authId":"","name":"Grouchy Ian Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Ian Ketchup","authId":"","name":"Grouchy Ian Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"id":6372410,"name":"Fire Ambush Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grouchy/Ian/Ketchup/6372410.jpg","createDate":{"time":1221832550000,"minutes":55,"seconds":50,"hours":9,"month":8,"timezoneOffset":240,"year":108,"day":5,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grouchy/Ian/Ketchup/6372410.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":18,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":115,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Andrew Viking","authId":"","name":"Fearless Andrew Viking","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Andrew Viking","authId":"","name":"Fearless Andrew Viking","CNNId":"","myGameChains":null,"banStatus":null},"id":6559410,"name":"Dark Sonic Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearless/Andrew/Viking/6559410.jpg","createDate":{"time":1223214551000,"minutes":49,"seconds":11,"hours":9,"month":9,"timezoneOffset":240,"year":108,"day":0,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearless/Andrew/Viking/6559410.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5170,"difficulty":1.2207209799196188,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6110,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":8,"rating":2.296384,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Duke Doodle","authId":"","name":"Alien Duke Doodle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Duke Doodle","authId":"","name":"Alien Duke Doodle","CNNId":"","myGameChains":null,"banStatus":null},"id":6691874,"name":"Lightning Metal Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Duke/Doodle/6691874.jpg","createDate":{"time":1223734127000,"minutes":8,"seconds":47,"hours":10,"month":9,"timezoneOffset":240,"year":108,"day":6,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Duke/Doodle/6691874.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":211,"difficulty":2.6582242543781005,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1425,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.410132,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Visible Bradley Gumshoe","authId":"","name":"Visible Bradley Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Visible Bradley Gumshoe","authId":"","name":"Visible Bradley Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":6769254,"name":"Crusher Danger Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Visible/Bradley/Gumshoe/6769254.jpg","createDate":{"time":1223862824000,"minutes":53,"seconds":44,"hours":21,"month":9,"timezoneOffset":240,"year":108,"day":0,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Visible/Bradley/Gumshoe/6769254.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":140,"difficulty":2.361111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":145,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.6,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hardy Jeff Jungle","authId":"","name":"Hardy Jeff Jungle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hardy Jeff Jungle","authId":"","name":"Hardy Jeff Jungle","CNNId":"","myGameChains":null,"banStatus":null},"id":6819641,"name":"Spidermonkey Warrior Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hardy/Jeff/Jungle/6819641.jpg","createDate":{"time":1224178586000,"minutes":36,"seconds":26,"hours":13,"month":9,"timezoneOffset":240,"year":108,"day":4,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hardy/Jeff/Jungle/6819641.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":116,"difficulty":2.477777777777778,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":273,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.669643,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Frank Rhino","authId":"","name":"Atomic Frank Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Frank Rhino","authId":"","name":"Atomic Frank Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":7006988,"name":"Mega Rumble Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Frank/Rhino/7006988.jpg","createDate":{"time":1225152569000,"minutes":9,"seconds":29,"hours":20,"month":9,"timezoneOffset":240,"year":108,"day":1,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Frank/Rhino/7006988.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21,"difficulty":2.786111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":957,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.468254,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"41","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.status = 1 AND GameStat.timesPlayed >= '50' AND createdate <= SYSDATE-'280' AND Game.id = GameStat.gameid order by dbms_random.value) where rownum <= 200) ORDER BY GAME.createdate ASC ","endRecordId":"50","currentPageToDisplay":5,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]