[{"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":"Earnest Melvin Rhombus","authId":"","name":"Earnest Melvin Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Melvin Rhombus","authId":"","name":"Earnest Melvin Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"id":14991822,"name":"Ultimate Lightning Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Earnest/Melvin/Rhombus/14991822.jpg","createDate":{"time":1295110721000,"minutes":58,"seconds":41,"hours":11,"month":0,"timezoneOffset":300,"year":111,"day":6,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Earnest/Melvin/Rhombus/14991822.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13830,"difficulty":1.591964109644914,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":135570,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":161,"rating":4.845779,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy Zeb Zip","authId":"","name":"Zippy Zeb Zip","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy Zeb Zip","authId":"","name":"Zippy Zeb Zip","CNNId":"","myGameChains":null,"banStatus":null},"id":12555577,"name":"Champion Warp Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zippy/Zeb/Zip/12555577.jpg","createDate":{"time":1275486891000,"minutes":54,"seconds":51,"hours":9,"month":5,"timezoneOffset":240,"year":110,"day":3,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zippy/Zeb/Zip/12555577.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":174751,"difficulty":1.5851418105631676,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":675234,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":161,"rating":3.04469,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Heroic Angel Hologram","authId":"","name":"Heroic Angel Hologram","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Heroic Angel Hologram","authId":"","name":"Heroic Angel Hologram","CNNId":"","myGameChains":null,"banStatus":null},"id":5186600,"name":"Atomic Rampage Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Heroic/Angel/Hologram/5186600.jpg","createDate":{"time":1216911477000,"minutes":57,"seconds":57,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Heroic/Angel/Hologram/5186600.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1432,"difficulty":2.276079890059806,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":316402,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":161,"rating":3.339345,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Marco Penguin","authId":"","name":"Atomic Marco Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Marco Penguin","authId":"","name":"Atomic Marco Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":6118152,"name":"Jetray Cosmic Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Marco/Penguin/6118152.jpg","createDate":{"time":1219868726000,"minutes":25,"seconds":26,"hours":16,"month":7,"timezoneOffset":240,"year":108,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Marco/Penguin/6118152.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30502,"difficulty":1.627962757408143,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":227248,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":161,"rating":3.935862,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awful Hunter Penguin","authId":"","name":"Awful Hunter Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awful Hunter Penguin","authId":"","name":"Awful Hunter Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":5197596,"name":"Spidermonkey Cosmic Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awful/Hunter/Penguin/5197596.jpg","createDate":{"time":1216926102000,"minutes":1,"seconds":42,"hours":15,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awful/Hunter/Penguin/5197596.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11892,"difficulty":1.5122424352833712,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":83489,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":160,"rating":3.700024,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Caleb Squirrel","authId":"","name":"Brave Caleb Squirrel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Caleb Squirrel","authId":"","name":"Brave Caleb Squirrel","CNNId":"","myGameChains":null,"banStatus":null},"id":5170068,"name":"Humongousaur Rampage Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brave/Caleb/Squirrel/5170068.jpg","createDate":{"time":1216856777000,"minutes":46,"seconds":17,"hours":19,"month":6,"timezoneOffset":240,"year":108,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brave/Caleb/Squirrel/5170068.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9437,"difficulty":1.7182631377894186,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":87845,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":160,"rating":4.340725,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Miguel Jungle","authId":"","name":"Western Miguel Jungle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Miguel Jungle","authId":"","name":"Western Miguel Jungle","CNNId":"","myGameChains":null,"banStatus":null},"id":5186503,"name":"Pulse Search Nano","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Western/Miguel/Jungle/5186503.jpg","createDate":{"time":1216911323000,"minutes":55,"seconds":23,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Western/Miguel/Jungle/5186503.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3466,"difficulty":2.5990987622164194,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":367843,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":158,"rating":4.484933,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty Brandon Hologram","authId":"","name":"Sporty Brandon Hologram","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty Brandon Hologram","authId":"","name":"Sporty Brandon Hologram","CNNId":"","myGameChains":null,"banStatus":null},"id":5187066,"name":"Jetray Power Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sporty/Brandon/Hologram/5187066.jpg","createDate":{"time":1216912159000,"minutes":9,"seconds":19,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sporty/Brandon/Hologram/5187066.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8891,"difficulty":1.81126860438248,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":310430,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":158,"rating":3.958471,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Ronald Kiwi","authId":"","name":"Nomadic Ronald Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Ronald Kiwi","authId":"","name":"Nomadic Ronald Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"id":5186729,"name":"Plasma Storm Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nomadic/Ronald/Kiwi/5186729.jpg","createDate":{"time":1216911714000,"minutes":1,"seconds":54,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nomadic/Ronald/Kiwi/5186729.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11014,"difficulty":1.7475804526035885,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":307785,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":158,"rating":1.952146,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Natalie Mammoth","authId":"","name":"Loony Natalie Mammoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Natalie Mammoth","authId":"","name":"Loony Natalie Mammoth","CNNId":"","myGameChains":null,"banStatus":null},"id":5186673,"name":"Rampage Warrior Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loony/Natalie/Mammoth/5186673.jpg","createDate":{"time":1216911611000,"minutes":0,"seconds":11,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loony/Natalie/Mammoth/5186673.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3492,"difficulty":2.501785439487013,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":105022,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":158,"rating":3.235921,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"171","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":"180","currentPageToDisplay":18,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]