[{"getMostShared":{"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":199,"SQLFilter":null,"limitStatement":" AND ROWNUM <= 200","totalRecordsSQL":"Select count(*) as \"MostShared.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 gamestat.timesShared > '5' AND Game.status = 1 AND Game.id = GameStat.gameid order by GameStat.timesShared desc) where rownum <= 200) ORDER BY Gamestat.timesshared DESC) ","list":[{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Hunter Aardvark","authId":"","name":"Nomadic Hunter Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Hunter Aardvark","authId":"","name":"Nomadic Hunter Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"id":9410433,"name":"Spidermonkey Shock Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nomadic/Hunter/Aardvark/9410433.jpg","createDate":{"time":1240878750000,"minutes":32,"seconds":30,"hours":20,"month":3,"timezoneOffset":240,"year":109,"day":1,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nomadic/Hunter/Aardvark/9410433.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":102,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":282,"rating":4.041667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Vincent Varmint","authId":"","name":"Valiant Vincent Varmint","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Vincent Varmint","authId":"","name":"Valiant Vincent Varmint","CNNId":"","myGameChains":null,"banStatus":null},"id":6669188,"name":"Power Slam Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Valiant/Vincent/Varmint/6669188.jpg","createDate":{"time":1223673994000,"minutes":26,"seconds":34,"hours":17,"month":9,"timezoneOffset":240,"year":108,"day":5,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Valiant/Vincent/Varmint/6669188.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":447,"difficulty":1.8129771921732811,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":534515,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":274,"rating":1.862167,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Darling Horatio Genius","authId":"","name":"Darling Horatio Genius","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Darling Horatio Genius","authId":"","name":"Darling Horatio Genius","CNNId":"","myGameChains":null,"banStatus":null},"id":16129112,"name":"Hex Swampfire Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Darling/Horatio/Genius/16129112.jpg","createDate":{"time":1315310102000,"minutes":55,"seconds":2,"hours":7,"month":8,"timezoneOffset":240,"year":111,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Darling/Horatio/Genius/16129112.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":214077,"difficulty":2.190646558042502,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":796899,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":272,"rating":4.096548,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Igor Robot","authId":"","name":"Generous Igor Robot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Igor Robot","authId":"","name":"Generous Igor Robot","CNNId":"","myGameChains":null,"banStatus":null},"id":16127223,"name":"Chill Turbo Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Generous/Igor/Robot/16127223.jpg","createDate":{"time":1315252095000,"minutes":48,"seconds":15,"hours":15,"month":8,"timezoneOffset":240,"year":111,"day":1,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Generous/Igor/Robot/16127223.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":502274,"difficulty":2.3061654952872446,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1055174,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":269,"rating":4.212423,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Jonathan Cactus","authId":"","name":"Elegant Jonathan Cactus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Jonathan Cactus","authId":"","name":"Elegant Jonathan Cactus","CNNId":"","myGameChains":null,"banStatus":null},"id":16125365,"name":"Adventure Breaker Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elegant/Jonathan/Cactus/16125365.jpg","createDate":{"time":1315229086000,"minutes":24,"seconds":46,"hours":9,"month":8,"timezoneOffset":240,"year":111,"day":1,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elegant/Jonathan/Cactus/16125365.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11551,"difficulty":2.176500915012101,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":724618,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":268,"rating":4.175722,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Squishy Zelda Gulch","authId":"","name":"Squishy Zelda Gulch","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Squishy Zelda Gulch","authId":"","name":"Squishy Zelda Gulch","CNNId":"","myGameChains":null,"banStatus":null},"id":6578106,"name":"Mega Target Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Squishy/Zelda/Gulch/6578106.jpg","createDate":{"time":1223302814000,"minutes":20,"seconds":14,"hours":10,"month":9,"timezoneOffset":240,"year":108,"day":1,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Squishy/Zelda/Gulch/6578106.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":49387,"difficulty":1.3245112690978424,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":566395,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":268,"rating":3.520406,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Nelson Hydra","authId":"","name":"Electric Nelson Hydra","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Nelson Hydra","authId":"","name":"Electric Nelson Hydra","CNNId":"","myGameChains":null,"banStatus":null},"id":14319621,"name":"Iron Robot Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Nelson/Hydra/14319621.jpg","createDate":{"time":1290700188000,"minutes":49,"seconds":48,"hours":10,"month":10,"timezoneOffset":300,"year":110,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Nelson/Hydra/14319621.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":134036,"difficulty":2.4884340136672014,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":436406,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":261,"rating":4.877849,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Bertha Mammoth","authId":"","name":"Babbling Bertha Mammoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Bertha Mammoth","authId":"","name":"Babbling Bertha Mammoth","CNNId":"","myGameChains":null,"banStatus":null},"id":16229757,"name":"Spark Shock Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Babbling/Bertha/Mammoth/16229757.jpg","createDate":{"time":1318340590000,"minutes":43,"seconds":10,"hours":9,"month":9,"timezoneOffset":240,"year":111,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Babbling/Bertha/Mammoth/16229757.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1171,"difficulty":1.735609123538774,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":180544,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":260,"rating":4.785498,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Beowulf Python","authId":"","name":"Organic Beowulf Python","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Beowulf Python","authId":"","name":"Organic Beowulf Python","CNNId":"","myGameChains":null,"banStatus":null},"id":15560804,"name":"Mission Nova Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Organic/Beowulf/Python/15560804.jpg","createDate":{"time":1302827730000,"minutes":35,"seconds":30,"hours":20,"month":3,"timezoneOffset":240,"year":111,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Organic/Beowulf/Python/15560804.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":144567,"difficulty":1.2760072073306732,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":227057,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":255,"rating":4.775818,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Liam Ape","authId":"","name":"Famous Liam Ape","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Liam Ape","authId":"","name":"Famous Liam Ape","CNNId":"","myGameChains":null,"banStatus":null},"id":14242406,"name":"Challenge Nitro Nano","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Liam/Ape/14242406.jpg","createDate":{"time":1290527105000,"minutes":45,"seconds":5,"hours":10,"month":10,"timezoneOffset":300,"year":110,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Liam/Ape/14242406.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5661,"difficulty":2.868261215970673,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":657448,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":252,"rating":4.88491,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"71","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 gamestat.timesShared > '5' AND Game.status = 1 AND Game.id = GameStat.gameid order by GameStat.timesShared desc) where rownum <= 200) ORDER BY Gamestat.timesshared DESC","endRecordId":"80","currentPageToDisplay":8,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]