[{"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":200,"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":"Loud Ryan Android","authId":"","name":"Loud Ryan Android","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Ryan Android","authId":"","name":"Loud Ryan Android","CNNId":"","myGameChains":null,"banStatus":null},"id":11176340,"name":"Cosmic Danger Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Ryan/Android/11176340.jpg","createDate":{"time":1255960634000,"minutes":57,"seconds":14,"hours":9,"month":9,"timezoneOffset":240,"year":109,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Ryan/Android/11176340.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16,"difficulty":2.92,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":98,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Itchy Dan Elf","authId":"","name":"Itchy Dan Elf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Itchy Dan Elf","authId":"","name":"Itchy Dan Elf","CNNId":"","myGameChains":null,"banStatus":null},"id":11248021,"name":"Rush Attack Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Itchy/Dan/Elf/11248021.jpg","createDate":{"time":1256986145000,"minutes":49,"seconds":5,"hours":6,"month":9,"timezoneOffset":240,"year":109,"day":6,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Itchy/Dan/Elf/11248021.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":58,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Freaky Miguel Dragoon","authId":"","name":"Freaky Miguel Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Freaky Miguel Dragoon","authId":"","name":"Freaky Miguel Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":11271157,"name":"Plumber Razor Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Freaky/Miguel/Dragoon/11271157.jpg","createDate":{"time":1257234616000,"minutes":50,"seconds":16,"hours":2,"month":10,"timezoneOffset":300,"year":109,"day":2,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Freaky/Miguel/Dragoon/11271157.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21,"difficulty":2.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.75,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Buster Alien","authId":"","name":"Unknown Buster Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Buster Alien","authId":"","name":"Unknown Buster Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":11299900,"name":"Fury Fire Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unknown/Buster/Alien/11299900.jpg","createDate":{"time":1257672015000,"minutes":20,"seconds":15,"hours":4,"month":10,"timezoneOffset":300,"year":109,"day":0,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unknown/Buster/Alien/11299900.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":52,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Max Ketchup","authId":"","name":"Loony Max Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Max Ketchup","authId":"","name":"Loony Max Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"id":11319271,"name":"Hero Battle Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loony/Max/Ketchup/11319271.jpg","createDate":{"time":1257949190000,"minutes":19,"seconds":50,"hours":9,"month":10,"timezoneOffset":300,"year":109,"day":3,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loony/Max/Ketchup/11319271.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":67,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Buster Alien","authId":"","name":"Unknown Buster Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Buster Alien","authId":"","name":"Unknown Buster Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":11451236,"name":"Energy Alien Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unknown/Buster/Alien/11451236.jpg","createDate":{"time":1259503540000,"minutes":5,"seconds":40,"hours":9,"month":10,"timezoneOffset":300,"year":109,"day":0,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unknown/Buster/Alien/11451236.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":544,"difficulty":2.3186147186147186,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1639,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.570476,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Scary Jason Fury","authId":"","name":"Scary Jason Fury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scary Jason Fury","authId":"","name":"Scary Jason Fury","CNNId":"","myGameChains":null,"banStatus":null},"id":11544097,"name":"Plasma Streak Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scary/Jason/Fury/11544097.jpg","createDate":{"time":1260800043000,"minutes":14,"seconds":3,"hours":9,"month":11,"timezoneOffset":300,"year":109,"day":1,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scary/Jason/Fury/11544097.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":40,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":73,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Expert Noah Nacho","authId":"","name":"Expert Noah Nacho","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Expert Noah Nacho","authId":"","name":"Expert Noah Nacho","CNNId":"","myGameChains":null,"banStatus":null},"id":11671809,"name":"Pursuit Swampfire Light","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Expert/Noah/Nacho/11671809.jpg","createDate":{"time":1262412825000,"minutes":13,"seconds":45,"hours":1,"month":0,"timezoneOffset":300,"year":110,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Expert/Noah/Nacho/11671809.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":23,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":70,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Yellow Mel Spider","authId":"","name":"Yellow Mel Spider","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Yellow Mel Spider","authId":"","name":"Yellow Mel Spider","CNNId":"","myGameChains":null,"banStatus":null},"id":11672556,"name":"Burst Rustbucket Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Yellow/Mel/Spider/11672556.jpg","createDate":{"time":1262436287000,"minutes":44,"seconds":47,"hours":7,"month":0,"timezoneOffset":300,"year":110,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Yellow/Mel/Spider/11672556.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":44,"difficulty":2.46,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":721,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.8125,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Lenny Unicycle","authId":"","name":"Shiny Lenny Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Lenny Unicycle","authId":"","name":"Shiny Lenny Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"id":11682592,"name":"Light Metal Jetray","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shiny/Lenny/Unicycle/11682592.jpg","createDate":{"time":1262555331000,"minutes":48,"seconds":51,"hours":16,"month":0,"timezoneOffset":300,"year":110,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shiny/Lenny/Unicycle/11682592.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":88,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"91","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":"100","currentPageToDisplay":10,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]