[{"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":"Mystic Apollo Android","authId":"","name":"Mystic Apollo Android","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mystic Apollo Android","authId":"","name":"Mystic Apollo Android","CNNId":"","myGameChains":null,"banStatus":null},"id":11810576,"name":"Power Alien Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mystic/Apollo/Android/11810576.jpg","createDate":{"time":1264493107000,"minutes":5,"seconds":7,"hours":3,"month":0,"timezoneOffset":300,"year":110,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mystic/Apollo/Android/11810576.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":881,"difficulty":2.8491381764855914,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61263,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":47,"rating":4.035716,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Scooter Bongo","authId":"","name":"Majestic Scooter Bongo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Scooter Bongo","authId":"","name":"Majestic Scooter Bongo","CNNId":"","myGameChains":null,"banStatus":null},"id":11935193,"name":"Mega Stone Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Majestic/Scooter/Bongo/11935193.jpg","createDate":{"time":1266535944000,"minutes":32,"seconds":24,"hours":18,"month":1,"timezoneOffset":300,"year":110,"day":4,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Majestic/Scooter/Bongo/11935193.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":66,"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":"Roaring Arthur Martian","authId":"","name":"Roaring Arthur Martian","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Roaring Arthur Martian","authId":"","name":"Roaring Arthur Martian","CNNId":"","myGameChains":null,"banStatus":null},"id":12070829,"name":"Challenge Hero Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Roaring/Arthur/Martian/12070829.jpg","createDate":{"time":1269043410000,"minutes":3,"seconds":30,"hours":20,"month":2,"timezoneOffset":240,"year":110,"day":5,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Roaring/Arthur/Martian/12070829.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":44,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":66,"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":"Humorous Robby Jingles","authId":"","name":"Humorous Robby Jingles","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humorous Robby Jingles","authId":"","name":"Humorous Robby Jingles","CNNId":"","myGameChains":null,"banStatus":null},"id":12101974,"name":"Rumble Animo Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humorous/Robby/Jingles/12101974.jpg","createDate":{"time":1269440940000,"minutes":29,"seconds":0,"hours":10,"month":2,"timezoneOffset":240,"year":110,"day":3,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humorous/Robby/Jingles/12101974.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":160,"difficulty":2.8788089225589224,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5402,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.583291,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Amanda Moonbeam","authId":"","name":"Mumbling Amanda Moonbeam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Amanda Moonbeam","authId":"","name":"Mumbling Amanda Moonbeam","CNNId":"","myGameChains":null,"banStatus":null},"id":12421075,"name":"Nano Fusion Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mumbling/Amanda/Moonbeam/12421075.jpg","createDate":{"time":1273623988000,"minutes":26,"seconds":28,"hours":20,"month":4,"timezoneOffset":240,"year":110,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mumbling/Amanda/Moonbeam/12421075.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6695,"difficulty":1.7544922467366966,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40143,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":12,"rating":3.358088,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Ray Turtle","authId":"","name":"Atomic Ray Turtle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Ray Turtle","authId":"","name":"Atomic Ray Turtle","CNNId":"","myGameChains":null,"banStatus":null},"id":13348977,"name":"Burst Pulse Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Ray/Turtle/13348977.jpg","createDate":{"time":1278479937000,"minutes":18,"seconds":57,"hours":1,"month":6,"timezoneOffset":240,"year":110,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Ray/Turtle/13348977.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51,"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":"Curious Xavier Rhino","authId":"","name":"Curious Xavier Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Xavier Rhino","authId":"","name":"Curious Xavier Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":13364390,"name":"Humongousaur Animo Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Xavier/Rhino/13364390.jpg","createDate":{"time":1278564280000,"minutes":44,"seconds":40,"hours":0,"month":6,"timezoneOffset":240,"year":110,"day":4,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Xavier/Rhino/13364390.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14,"difficulty":2.888888888888889,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":70,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Danny Ghoul","authId":"","name":"Crafty Danny Ghoul","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Danny Ghoul","authId":"","name":"Crafty Danny Ghoul","CNNId":"","myGameChains":null,"banStatus":null},"id":13489130,"name":"Escape Nova Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crafty/Danny/Ghoul/13489130.jpg","createDate":{"time":1279462762000,"minutes":19,"seconds":22,"hours":10,"month":6,"timezoneOffset":240,"year":110,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crafty/Danny/Ghoul/13489130.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":59,"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":"Bumbling Bessie Crash","authId":"","name":"Bumbling Bessie Crash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bumbling Bessie Crash","authId":"","name":"Bumbling Bessie Crash","CNNId":"","myGameChains":null,"banStatus":null},"id":13593918,"name":"Whirlwind Ultimate Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bumbling/Bessie/Crash/13593918.jpg","createDate":{"time":1280317765000,"minutes":49,"seconds":25,"hours":7,"month":6,"timezoneOffset":240,"year":110,"day":3,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bumbling/Bessie/Crash/13593918.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":77,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":188,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious Cory Wraith","authId":"","name":"Glorious Cory Wraith","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious Cory Wraith","authId":"","name":"Glorious Cory Wraith","CNNId":"","myGameChains":null,"banStatus":null},"id":13726513,"name":"Storm Sonic Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Glorious/Cory/Wraith/13726513.jpg","createDate":{"time":1281545201000,"minutes":46,"seconds":41,"hours":12,"month":7,"timezoneOffset":240,"year":110,"day":3,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Glorious/Cory/Wraith/13726513.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":72,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"111","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":"120","currentPageToDisplay":12,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]