[{"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":"Hectic Violet Biscuit","authId":"","name":"Hectic Violet Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hectic Violet Biscuit","authId":"","name":"Hectic Violet Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"id":20014551,"name":"Universe Ambush Kickin' Hawk","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hectic/Violet/Biscuit/20014551.jpg","createDate":{"time":1364996916000,"minutes":48,"seconds":36,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hectic/Violet/Biscuit/20014551.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4,"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":"Mighty Michelle Bazooka","authId":"","name":"Mighty Michelle Bazooka","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mighty Michelle Bazooka","authId":"","name":"Mighty Michelle Bazooka","CNNId":"","myGameChains":null,"banStatus":null},"id":20014549,"name":"Chill Adventure Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mighty/Michelle/Bazooka/20014549.jpg","createDate":{"time":1364996892000,"minutes":48,"seconds":12,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mighty/Michelle/Bazooka/20014549.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":"Gracious Bobby Varnish","authId":"","name":"Gracious Bobby Varnish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gracious Bobby Varnish","authId":"","name":"Gracious Bobby Varnish","CNNId":"","myGameChains":null,"banStatus":null},"id":20014547,"name":"Cosmic Danger Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gracious/Bobby/Varnish/20014547.jpg","createDate":{"time":1364996328000,"minutes":38,"seconds":48,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gracious/Bobby/Varnish/20014547.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":"Hectic Violet Biscuit","authId":"","name":"Hectic Violet Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hectic Violet Biscuit","authId":"","name":"Hectic Violet Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"id":20014545,"name":"Nitro Hex Whirlwind","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hectic/Violet/Biscuit/20014545.jpg","createDate":{"time":1364996318000,"minutes":38,"seconds":38,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hectic/Violet/Biscuit/20014545.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4,"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":"Heroic Jack Kungfu","authId":"","name":"Heroic Jack Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Heroic Jack Kungfu","authId":"","name":"Heroic Jack Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"id":20014543,"name":"Alien Energy Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Heroic/Jack/Kungfu/20014543.jpg","createDate":{"time":1364996185000,"minutes":36,"seconds":25,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Heroic/Jack/Kungfu/20014543.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4,"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":"Gracious Bobby Varnish","authId":"","name":"Gracious Bobby Varnish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gracious Bobby Varnish","authId":"","name":"Gracious Bobby Varnish","CNNId":"","myGameChains":null,"banStatus":null},"id":20014541,"name":"Alien Lightning Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gracious/Bobby/Varnish/20014541.jpg","createDate":{"time":1364995824000,"minutes":30,"seconds":24,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gracious/Bobby/Varnish/20014541.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":"Frugal Dakota Universe","authId":"","name":"Frugal Dakota Universe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Dakota Universe","authId":"","name":"Frugal Dakota Universe","CNNId":"","myGameChains":null,"banStatus":null},"id":20014539,"name":"Iron Slam Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frugal/Dakota/Universe/20014539.jpg","createDate":{"time":1364995822000,"minutes":30,"seconds":22,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frugal/Dakota/Universe/20014539.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":"Nautical Drew Unicycle","authId":"","name":"Nautical Drew Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nautical Drew Unicycle","authId":"","name":"Nautical Drew Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"id":20014537,"name":"Echo Echo Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nautical/Drew/Unicycle/20014537.jpg","createDate":{"time":1364995783000,"minutes":29,"seconds":43,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nautical/Drew/Unicycle/20014537.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12,"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":"Gracious Bobby Varnish","authId":"","name":"Gracious Bobby Varnish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gracious Bobby Varnish","authId":"","name":"Gracious Bobby Varnish","CNNId":"","myGameChains":null,"banStatus":null},"id":20014534,"name":"Ben Pursuit Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gracious/Bobby/Varnish/20014534.jpg","createDate":{"time":1364994925000,"minutes":15,"seconds":25,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gracious/Bobby/Varnish/20014534.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3,"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":"Green Zeus Apple","authId":"","name":"Green Zeus Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Green Zeus Apple","authId":"","name":"Green Zeus Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":20014532,"name":"Adventure Spidermonkey Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Green/Zeus/Apple/20014532.jpg","createDate":{"time":1364994890000,"minutes":14,"seconds":50,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Green/Zeus/Apple/20014532.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":0,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]