[{"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":"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":6664274,"name":"Rumble Quake Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Valiant/Vincent/Varmint/6664274.jpg","createDate":{"time":1223666073000,"minutes":14,"seconds":33,"hours":15,"month":9,"timezoneOffset":240,"year":108,"day":5,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Valiant/Vincent/Varmint/6664274.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1835,"difficulty":1.6770989294838685,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":396629,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":194,"rating":3.959407,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Witty Zelda Neutron","authId":"","name":"Witty Zelda Neutron","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Witty Zelda Neutron","authId":"","name":"Witty Zelda Neutron","CNNId":"","myGameChains":null,"banStatus":null},"id":15037942,"name":"Rampage Adventure Cannonbolt","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Witty/Zelda/Neutron/15037942.jpg","createDate":{"time":1295590132000,"minutes":8,"seconds":52,"hours":1,"month":0,"timezoneOffset":300,"year":111,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Witty/Zelda/Neutron/15037942.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":74782,"difficulty":2.416744201371211,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":286007,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":194,"rating":4.835652,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Ryan Eel","authId":"","name":"Alien Ryan Eel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Ryan Eel","authId":"","name":"Alien Ryan Eel","CNNId":"","myGameChains":null,"banStatus":null},"id":5199530,"name":"Energy Titan Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Ryan/Eel/5199530.jpg","createDate":{"time":1216928164000,"minutes":36,"seconds":4,"hours":15,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Ryan/Eel/5199530.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16381,"difficulty":2.249430006747181,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":91841,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":192,"rating":3.996738,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fuzzy Ace Squish","authId":"","name":"Fuzzy Ace Squish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fuzzy Ace Squish","authId":"","name":"Fuzzy Ace Squish","CNNId":"","myGameChains":null,"banStatus":null},"id":9129936,"name":"Warp Quake Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fuzzy/Ace/Squish/9129936.jpg","createDate":{"time":1238347323000,"minutes":22,"seconds":3,"hours":13,"month":2,"timezoneOffset":240,"year":109,"day":0,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fuzzy/Ace/Squish/9129936.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20357,"difficulty":2.30604321101743,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":848320,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":192,"rating":4.663469,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Ed Oddball","authId":"","name":"Odd Ed Oddball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Ed Oddball","authId":"","name":"Odd Ed Oddball","CNNId":"","myGameChains":null,"banStatus":null},"id":6225443,"name":"Cosmic Smash Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Odd/Ed/Oddball/6225443.jpg","createDate":{"time":1220402496000,"minutes":41,"seconds":36,"hours":20,"month":8,"timezoneOffset":240,"year":108,"day":2,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Odd/Ed/Oddball/6225443.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2452,"difficulty":2.2926730405839404,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":175467,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":192,"rating":4.753322,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mighty Dana Bolt","authId":"","name":"Mighty Dana Bolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mighty Dana Bolt","authId":"","name":"Mighty Dana Bolt","CNNId":"","myGameChains":null,"banStatus":null},"id":8915206,"name":"Burst Turbo Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mighty/Dana/Bolt/8915206.jpg","createDate":{"time":1236438843000,"minutes":14,"seconds":3,"hours":10,"month":2,"timezoneOffset":300,"year":109,"day":6,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mighty/Dana/Bolt/8915206.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":138440,"difficulty":1.5099806561952593,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":271388,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":189,"rating":4.583126,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Wes Octopus","authId":"","name":"Wacky Wes Octopus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Wes Octopus","authId":"","name":"Wacky Wes Octopus","CNNId":"","myGameChains":null,"banStatus":null},"id":5187058,"name":"Thunder Robot Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wacky/Wes/Octopus/5187058.jpg","createDate":{"time":1216912144000,"minutes":9,"seconds":4,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wacky/Wes/Octopus/5187058.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":61534,"difficulty":2.3275203387865324,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":202942,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":189,"rating":3.13149,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Aaron Goblin","authId":"","name":"Awesome Aaron Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Aaron Goblin","authId":"","name":"Awesome Aaron Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":5187231,"name":"Swampfire Challenge Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/Aaron/Goblin/5187231.jpg","createDate":{"time":1216912468000,"minutes":14,"seconds":28,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/Aaron/Goblin/5187231.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":867,"difficulty":2.743318316444704,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":224811,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":189,"rating":2.635012,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Tara Ukulele","authId":"","name":"Spectral Tara Ukulele","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Tara Ukulele","authId":"","name":"Spectral Tara Ukulele","CNNId":"","myGameChains":null,"banStatus":null},"id":9134828,"name":"Alien Magno Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spectral/Tara/Ukulele/9134828.jpg","createDate":{"time":1238359825000,"minutes":50,"seconds":25,"hours":16,"month":2,"timezoneOffset":240,"year":109,"day":0,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spectral/Tara/Ukulele/9134828.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8288,"difficulty":2.504027761527313,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":232276,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":188,"rating":4.527843,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brutish Florence Orchid","authId":"","name":"Brutish Florence Orchid","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brutish Florence Orchid","authId":"","name":"Brutish Florence Orchid","CNNId":"","myGameChains":null,"banStatus":null},"id":16789986,"name":"Adventure Shadow Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brutish/Florence/Orchid/16789986.jpg","createDate":{"time":1331495549000,"minutes":52,"seconds":29,"hours":15,"month":2,"timezoneOffset":240,"year":112,"day":0,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brutish/Florence/Orchid/16789986.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":207899,"difficulty":2.6513554282304455,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":403205,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":187,"rating":4.829386,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"121","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":"130","currentPageToDisplay":13,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]