[{"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":"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":20014509,"name":"Laser Universe Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Heroic/Jack/Kungfu/20014509.jpg","createDate":{"time":1364994452000,"minutes":7,"seconds":32,"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/20014509.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1,"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":"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":20014507,"name":"Doom Patrol Humungousaur","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Popular/Rex/Atom/20014507.jpg","createDate":{"time":1364994418000,"minutes":6,"seconds":58,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Popular/Rex/Atom/20014507.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3,"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":"Able Gulliver Genius","authId":"","name":"Able Gulliver Genius","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Able Gulliver Genius","authId":"","name":"Able Gulliver Genius","CNNId":"","myGameChains":null,"banStatus":null},"id":20014505,"name":"Spark Breaker Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Able/Gulliver/Genius/20014505.jpg","createDate":{"time":1364994414000,"minutes":6,"seconds":54,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Able/Gulliver/Genius/20014505.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Expert Destiny Chaos","authId":"","name":"Expert Destiny Chaos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Expert Destiny Chaos","authId":"","name":"Expert Destiny Chaos","CNNId":"","myGameChains":null,"banStatus":null},"id":20014503,"name":"Burst Adventure Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Expert/Destiny/Chaos/20014503.jpg","createDate":{"time":1364994393000,"minutes":6,"seconds":33,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Expert/Destiny/Chaos/20014503.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":"Speedy Alex Bolt","authId":"","name":"Speedy Alex Bolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Alex Bolt","authId":"","name":"Speedy Alex Bolt","CNNId":"","myGameChains":null,"banStatus":null},"id":20014501,"name":"Universe Star Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Alex/Bolt/20014501.jpg","createDate":{"time":1364994328000,"minutes":5,"seconds":28,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Alex/Bolt/20014501.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":"Sunny Ariel Mutant","authId":"","name":"Sunny Ariel Mutant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sunny Ariel Mutant","authId":"","name":"Sunny Ariel Mutant","CNNId":"","myGameChains":null,"banStatus":null},"id":20014499,"name":"Rush Titan Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sunny/Ariel/Mutant/20014499.jpg","createDate":{"time":1364994290000,"minutes":4,"seconds":50,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sunny/Ariel/Mutant/20014499.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":"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":20014497,"name":"Laser Star Burst","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Popular/Rex/Atom/20014497.jpg","createDate":{"time":1364994224000,"minutes":3,"seconds":44,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Popular/Rex/Atom/20014497.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":"Magical Biff Daffodil","authId":"","name":"Magical Biff Daffodil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Biff Daffodil","authId":"","name":"Magical Biff Daffodil","CNNId":"","myGameChains":null,"banStatus":null},"id":20014495,"name":"Drone Adventure Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magical/Biff/Daffodil/20014495.jpg","createDate":{"time":1364994155000,"minutes":2,"seconds":35,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magical/Biff/Daffodil/20014495.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":"Crazy Hunter Tsunami","authId":"","name":"Crazy Hunter Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Hunter Tsunami","authId":"","name":"Crazy Hunter Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"id":20014493,"name":"Drone Clash Light","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Hunter/Tsunami/20014493.jpg","createDate":{"time":1364994107000,"minutes":1,"seconds":47,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Hunter/Tsunami/20014493.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":"Digital Danny Acrobat","authId":"","name":"Digital Danny Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Danny Acrobat","authId":"","name":"Digital Danny Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"id":20014491,"name":"Rook Sonic Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Digital/Danny/Acrobat/20014491.jpg","createDate":{"time":1364994052000,"minutes":0,"seconds":52,"hours":9,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Digital/Danny/Acrobat/20014491.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"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}],"descending":false,"beginRecordId":"101","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":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]