[{"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":"Funky Billy Cipher","authId":"","name":"Funky Billy Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Funky Billy Cipher","authId":"","name":"Funky Billy Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":20014446,"name":"Echo Fire Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Funky/Billy/Cipher/20014446.jpg","createDate":{"time":1364993483000,"minutes":51,"seconds":23,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Funky/Billy/Cipher/20014446.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":"Cute Dwayne Ninja","authId":"","name":"Cute Dwayne Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Dwayne Ninja","authId":"","name":"Cute Dwayne Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":20014444,"name":"Chase Power Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cute/Dwayne/Ninja/20014444.jpg","createDate":{"time":1364993395000,"minutes":49,"seconds":55,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cute/Dwayne/Ninja/20014444.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":"Popular Rex Atom","authId":"","name":"Popular Rex Atom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Popular Rex Atom","authId":"","name":"Popular Rex Atom","CNNId":"","myGameChains":null,"banStatus":null},"id":20014442,"name":"Ultra Mega Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Popular/Rex/Atom/20014442.jpg","createDate":{"time":1364993355000,"minutes":49,"seconds":15,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Popular/Rex/Atom/20014442.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":"Atomic Trent Blade","authId":"","name":"Atomic Trent Blade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Trent Blade","authId":"","name":"Atomic Trent Blade","CNNId":"","myGameChains":null,"banStatus":null},"id":20014440,"name":"Space Defense Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Trent/Blade/20014440.jpg","createDate":{"time":1364993339000,"minutes":48,"seconds":59,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Trent/Blade/20014440.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2,"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":"Alien Apollo Bison","authId":"","name":"Alien Apollo Bison","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Apollo Bison","authId":"","name":"Alien Apollo Bison","CNNId":"","myGameChains":null,"banStatus":null},"id":20014438,"name":"Ultimate Humungousaur Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Apollo/Bison/20014438.jpg","createDate":{"time":1364993261000,"minutes":47,"seconds":41,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Apollo/Bison/20014438.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":"Bold Arianna Ketchup","authId":"","name":"Bold Arianna Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Arianna Ketchup","authId":"","name":"Bold Arianna Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"id":20014436,"name":"Cannonbolt Whirlwind Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Arianna/Ketchup/20014436.jpg","createDate":{"time":1364993247000,"minutes":47,"seconds":27,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Arianna/Ketchup/20014436.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":"Atomic Jack Acrobat","authId":"","name":"Atomic Jack Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Jack Acrobat","authId":"","name":"Atomic Jack Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"id":20014433,"name":"Alien Assault Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Jack/Acrobat/20014433.jpg","createDate":{"time":1364993236000,"minutes":47,"seconds":16,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Jack/Acrobat/20014433.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":"Reckless Robin Razor","authId":"","name":"Reckless Robin Razor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Robin Razor","authId":"","name":"Reckless Robin Razor","CNNId":"","myGameChains":null,"banStatus":null},"id":20014431,"name":"Bloxx Invasion Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Robin/Razor/20014431.jpg","createDate":{"time":1364993221000,"minutes":47,"seconds":1,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Robin/Razor/20014431.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":"Alien Alan Kungfu","authId":"","name":"Alien Alan Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Alan Kungfu","authId":"","name":"Alien Alan Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"id":20014428,"name":"Universe Assault Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Alan/Kungfu/20014428.jpg","createDate":{"time":1364993171000,"minutes":46,"seconds":11,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Alan/Kungfu/20014428.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"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},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Poseidon Dolphin","authId":"","name":"Friendly Poseidon Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Poseidon Dolphin","authId":"","name":"Friendly Poseidon Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"id":20014426,"name":"Alien Ambush Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Friendly/Poseidon/Dolphin/20014426.jpg","createDate":{"time":1364993134000,"minutes":45,"seconds":34,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Friendly/Poseidon/Dolphin/20014426.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8,"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":"131","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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]