[{"getNew":{"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 \"NewGames.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 createdate BETWEEN SYSDATE-'280' AND SYSDATE AND Game.id = GameStat.gameid order by Game.createdate desc) where rownum <= 200) ORDER BY GAME.createdate DESC ) ","list":[{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Sydney Clone","authId":"","name":"Virtual Sydney Clone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Sydney Clone","authId":"","name":"Virtual Sydney Clone","CNNId":"","myGameChains":null,"banStatus":null},"id":20014685,"name":"Warp Danger Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Virtual/Sydney/Clone/20014685.jpg","createDate":{"time":1365122219000,"minutes":36,"seconds":59,"hours":20,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Virtual/Sydney/Clone/20014685.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":86,"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":"Virtual Sydney Clone","authId":"","name":"Virtual Sydney Clone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Sydney Clone","authId":"","name":"Virtual Sydney Clone","CNNId":"","myGameChains":null,"banStatus":null},"id":20014683,"name":"Plasma Hyper Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Virtual/Sydney/Clone/20014683.jpg","createDate":{"time":1365120937000,"minutes":15,"seconds":37,"hours":20,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Virtual/Sydney/Clone/20014683.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":21,"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":"Fanciful Kevin Dragoon","authId":"","name":"Fanciful Kevin Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fanciful Kevin Dragoon","authId":"","name":"Fanciful Kevin Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":20014681,"name":"Pursuit Energy Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fanciful/Kevin/Dragoon/20014681.jpg","createDate":{"time":1365112266000,"minutes":51,"seconds":6,"hours":17,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fanciful/Kevin/Dragoon/20014681.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":0,"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":"Prickly Scooby Dragoon","authId":"","name":"Prickly Scooby Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prickly Scooby Dragoon","authId":"","name":"Prickly Scooby Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":20014679,"name":"Alien Laser Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prickly/Scooby/Dragoon/20014679.jpg","createDate":{"time":1365106166000,"minutes":9,"seconds":26,"hours":16,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prickly/Scooby/Dragoon/20014679.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2,"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":"Colossal Michael Shinobi","authId":"","name":"Colossal Michael Shinobi","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Michael Shinobi","authId":"","name":"Colossal Michael Shinobi","CNNId":"","myGameChains":null,"banStatus":null},"id":20014676,"name":"Robot Assault Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colossal/Michael/Shinobi/20014676.jpg","createDate":{"time":1365100449000,"minutes":34,"seconds":9,"hours":14,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colossal/Michael/Shinobi/20014676.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1,"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":"Galactic Kylie Turnip","authId":"","name":"Galactic Kylie Turnip","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Kylie Turnip","authId":"","name":"Galactic Kylie Turnip","CNNId":"","myGameChains":null,"banStatus":null},"id":20014674,"name":"Alien Battle Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Galactic/Kylie/Turnip/20014674.jpg","createDate":{"time":1365099486000,"minutes":18,"seconds":6,"hours":14,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Galactic/Kylie/Turnip/20014674.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":49,"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":"Active Rhett Waffle","authId":"","name":"Active Rhett Waffle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Rhett Waffle","authId":"","name":"Active Rhett Waffle","CNNId":"","myGameChains":null,"banStatus":null},"id":20014672,"name":"Beast Universe Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Active/Rhett/Waffle/20014672.jpg","createDate":{"time":1365095047000,"minutes":4,"seconds":7,"hours":13,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Active/Rhett/Waffle/20014672.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1,"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":"Robotic Sierra Tundra","authId":"","name":"Robotic Sierra Tundra","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Robotic Sierra Tundra","authId":"","name":"Robotic Sierra Tundra","CNNId":"","myGameChains":null,"banStatus":null},"id":20014670,"name":"Hero Defense Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Robotic/Sierra/Tundra/20014670.jpg","createDate":{"time":1365093983000,"minutes":46,"seconds":23,"hours":12,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Robotic/Sierra/Tundra/20014670.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":0,"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":"Doctor Milo Fizz","authId":"","name":"Doctor Milo Fizz","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Milo Fizz","authId":"","name":"Doctor Milo Fizz","CNNId":"","myGameChains":null,"banStatus":null},"id":20014668,"name":"Techno Energy Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Doctor/Milo/Fizz/20014668.jpg","createDate":{"time":1365088311000,"minutes":11,"seconds":51,"hours":11,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Doctor/Milo/Fizz/20014668.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":0,"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":"Genuine Bessie Chipmunk","authId":"","name":"Genuine Bessie Chipmunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Genuine Bessie Chipmunk","authId":"","name":"Genuine Bessie Chipmunk","CNNId":"","myGameChains":null,"banStatus":null},"id":20014665,"name":"Iron Power Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Genuine/Bessie/Chipmunk/20014665.jpg","createDate":{"time":1365087840000,"minutes":4,"seconds":0,"hours":11,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Genuine/Bessie/Chipmunk/20014665.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5,"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":"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 createdate BETWEEN SYSDATE-'280' AND SYSDATE AND Game.id = GameStat.gameid order by Game.createdate desc) where rownum <= 200) ORDER BY GAME.createdate DESC ","endRecordId":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]