[{"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":"Average Aaliyah Fang","authId":"","name":"Average Aaliyah Fang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Aaliyah Fang","authId":"","name":"Average Aaliyah Fang","CNNId":"","myGameChains":null,"banStatus":null},"id":20014663,"name":"Atomic Shadow Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Average/Aaliyah/Fang/20014663.jpg","createDate":{"time":1365085923000,"minutes":32,"seconds":3,"hours":10,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Average/Aaliyah/Fang/20014663.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":43,"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":20014661,"name":"Energy Plasma Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Doctor/Milo/Fizz/20014661.jpg","createDate":{"time":1365078919000,"minutes":35,"seconds":19,"hours":8,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Doctor/Milo/Fizz/20014661.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16,"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":"Singular Ben Galaxy","authId":"","name":"Singular Ben Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Singular Ben Galaxy","authId":"","name":"Singular Ben Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"id":20014659,"name":"Alien Hyper Humungousaur","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Singular/Ben/Galaxy/20014659.jpg","createDate":{"time":1365072043000,"minutes":40,"seconds":43,"hours":6,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Singular/Ben/Galaxy/20014659.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61,"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":"Suave Merlin Ninja","authId":"","name":"Suave Merlin Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Suave Merlin Ninja","authId":"","name":"Suave Merlin Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":20014657,"name":"Adventure Rampage Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Suave/Merlin/Ninja/20014657.jpg","createDate":{"time":1365070642000,"minutes":17,"seconds":22,"hours":6,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Suave/Merlin/Ninja/20014657.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":55,"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":"Suave Merlin Ninja","authId":"","name":"Suave Merlin Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Suave Merlin Ninja","authId":"","name":"Suave Merlin Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":20014655,"name":"Patrol Echo Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Suave/Merlin/Ninja/20014655.jpg","createDate":{"time":1365070340000,"minutes":12,"seconds":20,"hours":6,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Suave/Merlin/Ninja/20014655.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7,"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":"Magnetic Crystal Shark","authId":"","name":"Magnetic Crystal Shark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Crystal Shark","authId":"","name":"Magnetic Crystal Shark","CNNId":"","myGameChains":null,"banStatus":null},"id":20014652,"name":"Turbo Thunder Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Crystal/Shark/20014652.jpg","createDate":{"time":1365069753000,"minutes":2,"seconds":33,"hours":6,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Crystal/Shark/20014652.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Suave Merlin Ninja","authId":"","name":"Suave Merlin Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Suave Merlin Ninja","authId":"","name":"Suave Merlin Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":20014649,"name":"Attack Rush Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Suave/Merlin/Ninja/20014649.jpg","createDate":{"time":1365069320000,"minutes":55,"seconds":20,"hours":5,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Suave/Merlin/Ninja/20014649.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19,"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":"Amazing Leo Crumpet","authId":"","name":"Amazing Leo Crumpet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Leo Crumpet","authId":"","name":"Amazing Leo Crumpet","CNNId":"","myGameChains":null,"banStatus":null},"id":20014646,"name":"Rescue Fusion Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amazing/Leo/Crumpet/20014646.jpg","createDate":{"time":1365057842000,"minutes":44,"seconds":2,"hours":2,"month":3,"timezoneOffset":240,"year":113,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amazing/Leo/Crumpet/20014646.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"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":"Blue Bill Snowball","authId":"","name":"Blue Bill Snowball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Bill Snowball","authId":"","name":"Blue Bill Snowball","CNNId":"","myGameChains":null,"banStatus":null},"id":20014643,"name":"Ultra Lightning Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Bill/Snowball/20014643.jpg","createDate":{"time":1365047946000,"minutes":59,"seconds":6,"hours":23,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Bill/Snowball/20014643.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7,"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":"Shrewd Marco Jamboree","authId":"","name":"Shrewd Marco Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shrewd Marco Jamboree","authId":"","name":"Shrewd Marco Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"id":20014641,"name":"Pulse Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shrewd/Marco/Jamboree/20014641.jpg","createDate":{"time":1365042565000,"minutes":29,"seconds":25,"hours":22,"month":3,"timezoneOffset":240,"year":113,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shrewd/Marco/Jamboree/20014641.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"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}],"descending":false,"beginRecordId":"31","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":"40","currentPageToDisplay":4,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]