[{"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":"Fierce Robert Fossil","authId":"","name":"Fierce Robert Fossil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Robert Fossil","authId":"","name":"Fierce Robert Fossil","CNNId":"","myGameChains":null,"banStatus":null},"id":5166415,"name":"Champion Rush Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fierce/Robert/Fossil/5166415.jpg","createDate":{"time":1216852034000,"minutes":27,"seconds":14,"hours":18,"month":6,"timezoneOffset":240,"year":108,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fierce/Robert/Fossil/5166415.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":398,"difficulty":2.4470178908625373,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":131954,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":100,"rating":3.459239,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Florence Phantom","authId":"","name":"Alien Florence Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Florence Phantom","authId":"","name":"Alien Florence Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":5363706,"name":"Plumber Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Florence/Phantom/5363706.jpg","createDate":{"time":1217339819000,"minutes":56,"seconds":59,"hours":9,"month":6,"timezoneOffset":240,"year":108,"day":2,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Florence/Phantom/5363706.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":60,"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":"Hectic Harry Monster","authId":"","name":"Hectic Harry Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hectic Harry Monster","authId":"","name":"Hectic Harry Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":5463324,"name":"Ben Universe Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hectic/Harry/Monster/5463324.jpg","createDate":{"time":1217598911000,"minutes":55,"seconds":11,"hours":9,"month":7,"timezoneOffset":240,"year":108,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hectic/Harry/Monster/5463324.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8,"difficulty":2.3553857906799083,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":998,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.647768,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Matthew Magma","authId":"","name":"Fierce Matthew Magma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Matthew Magma","authId":"","name":"Fierce Matthew Magma","CNNId":"","myGameChains":null,"banStatus":null},"id":5495884,"name":"Rescue Steel Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fierce/Matthew/Magma/5495884.jpg","createDate":{"time":1217685579000,"minutes":59,"seconds":39,"hours":9,"month":7,"timezoneOffset":240,"year":108,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fierce/Matthew/Magma/5495884.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":18,"difficulty":2.7777777777777777,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":143,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.1875,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sly Adam Shock","authId":"","name":"Sly Adam Shock","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sly Adam Shock","authId":"","name":"Sly Adam Shock","CNNId":"","myGameChains":null,"banStatus":null},"id":5520639,"name":"Spidermonkey Ultimate Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sly/Adam/Shock/5520639.jpg","createDate":{"time":1217731307000,"minutes":41,"seconds":47,"hours":22,"month":7,"timezoneOffset":240,"year":108,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sly/Adam/Shock/5520639.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":18,"difficulty":2.7511303511303513,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":504,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.953935,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Victor Coconut","authId":"","name":"Loud Victor Coconut","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Victor Coconut","authId":"","name":"Loud Victor Coconut","CNNId":"","myGameChains":null,"banStatus":null},"id":5567520,"name":"Stone Drone Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Victor/Coconut/5567520.jpg","createDate":{"time":1217881701000,"minutes":28,"seconds":21,"hours":16,"month":7,"timezoneOffset":240,"year":108,"day":1,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Victor/Coconut/5567520.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74,"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":"Baffling Austin Aurora","authId":"","name":"Baffling Austin Aurora","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baffling Austin Aurora","authId":"","name":"Baffling Austin Aurora","CNNId":"","myGameChains":null,"banStatus":null},"id":5644782,"name":"Champion Nitro Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baffling/Austin/Aurora/5644782.jpg","createDate":{"time":1218065901000,"minutes":38,"seconds":21,"hours":19,"month":7,"timezoneOffset":240,"year":108,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baffling/Austin/Aurora/5644782.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8,"difficulty":2.7472222222222222,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":212,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":3.96,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Red Vicky Magician","authId":"","name":"Red Vicky Magician","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Red Vicky Magician","authId":"","name":"Red Vicky Magician","CNNId":"","myGameChains":null,"banStatus":null},"id":5670381,"name":"Magno Giga Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Red/Vicky/Magician/5670381.jpg","createDate":{"time":1218136444000,"minutes":14,"seconds":4,"hours":15,"month":7,"timezoneOffset":240,"year":108,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Red/Vicky/Magician/5670381.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":344,"difficulty":2.204540450202873,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3907,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.488524,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Beastly Baxter Bamboo","authId":"","name":"Beastly Baxter Bamboo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Beastly Baxter Bamboo","authId":"","name":"Beastly Baxter Bamboo","CNNId":"","myGameChains":null,"banStatus":null},"id":5723845,"name":"Solar Smash Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Beastly/Baxter/Bamboo/5723845.jpg","createDate":{"time":1218283163000,"minutes":59,"seconds":23,"hours":7,"month":7,"timezoneOffset":240,"year":108,"day":6,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Beastly/Baxter/Bamboo/5723845.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":102,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":231,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Nick Monster","authId":"","name":"Reckless Nick Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Nick Monster","authId":"","name":"Reckless Nick Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":5886042,"name":"Mega Fire Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Nick/Monster/5886042.jpg","createDate":{"time":1218769743000,"minutes":9,"seconds":3,"hours":23,"month":7,"timezoneOffset":240,"year":108,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Nick/Monster/5886042.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":169,"difficulty":2.7932246325103467,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1198,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.76954,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"21","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":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]