[{"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":"Gigantic Leah Moxie","authId":"","name":"Gigantic Leah Moxie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Leah Moxie","authId":"","name":"Gigantic Leah Moxie","CNNId":"","myGameChains":null,"banStatus":null},"id":17072485,"name":"Metal Storm Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gigantic/Leah/Moxie/17072485.jpg","createDate":{"time":1338376391000,"minutes":13,"seconds":11,"hours":7,"month":4,"timezoneOffset":240,"year":112,"day":3,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gigantic/Leah/Moxie/17072485.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":23655,"difficulty":2.429789382377524,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":499082,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":166,"rating":4.764532,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tricky Derek Kiwi","authId":"","name":"Tricky Derek Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tricky Derek Kiwi","authId":"","name":"Tricky Derek Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"id":5188190,"name":"Swampfire Energy Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tricky/Derek/Kiwi/5188190.jpg","createDate":{"time":1216913909000,"minutes":38,"seconds":29,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tricky/Derek/Kiwi/5188190.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":46309,"difficulty":2.1252265998608375,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":98496,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":166,"rating":4.318607,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Jackson Blade","authId":"","name":"Magnetic Jackson Blade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Jackson Blade","authId":"","name":"Magnetic Jackson Blade","CNNId":"","myGameChains":null,"banStatus":null},"id":5187033,"name":"Adventure Spark Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Jackson/Blade/5187033.jpg","createDate":{"time":1216912103000,"minutes":8,"seconds":23,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Jackson/Blade/5187033.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8625,"difficulty":2.5225248621570286,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":293554,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":165,"rating":4.52684,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Thomas Walrus","authId":"","name":"Aquatic Thomas Walrus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Thomas Walrus","authId":"","name":"Aquatic Thomas Walrus","CNNId":"","myGameChains":null,"banStatus":null},"id":5187135,"name":"Magno Fury Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aquatic/Thomas/Walrus/5187135.jpg","createDate":{"time":1216912276000,"minutes":11,"seconds":16,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aquatic/Thomas/Walrus/5187135.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19749,"difficulty":2.1436014643821317,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":285754,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":165,"rating":3.808468,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Itchy Evelyn Whizbang","authId":"","name":"Itchy Evelyn Whizbang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Itchy Evelyn Whizbang","authId":"","name":"Itchy Evelyn Whizbang","CNNId":"","myGameChains":null,"banStatus":null},"id":5186576,"name":"Doom Invasion Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Itchy/Evelyn/Whizbang/5186576.jpg","createDate":{"time":1216911439000,"minutes":57,"seconds":19,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Itchy/Evelyn/Whizbang/5186576.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":73898,"difficulty":1.8957401023847398,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":206715,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":164,"rating":4.25148,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Thomas Beeswax","authId":"","name":"Magnetic Thomas Beeswax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Thomas Beeswax","authId":"","name":"Magnetic Thomas Beeswax","CNNId":"","myGameChains":null,"banStatus":null},"id":5187123,"name":"Fire Shock Swampfire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Thomas/Beeswax/5187123.jpg","createDate":{"time":1216912241000,"minutes":10,"seconds":41,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Thomas/Beeswax/5187123.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":34766,"difficulty":2.0140580629366878,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":154163,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":164,"rating":1.676663,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crunchy Joel Dragon","authId":"","name":"Crunchy Joel Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crunchy Joel Dragon","authId":"","name":"Crunchy Joel Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":5186954,"name":"Spike Ultimate Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crunchy/Joel/Dragon/5186954.jpg","createDate":{"time":1216911993000,"minutes":6,"seconds":33,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crunchy/Joel/Dragon/5186954.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":41416,"difficulty":1.652041705586132,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":226114,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":164,"rating":4.276384,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Don Pirate","authId":"","name":"Shiny Don Pirate","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Don Pirate","authId":"","name":"Shiny Don Pirate","CNNId":"","myGameChains":null,"banStatus":null},"id":6582380,"name":"Ultimate Laser Nano","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shiny/Don/Pirate/6582380.jpg","createDate":{"time":1223326319000,"minutes":51,"seconds":59,"hours":16,"month":9,"timezoneOffset":240,"year":108,"day":1,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shiny/Don/Pirate/6582380.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9412,"difficulty":2.721483840668824,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":353685,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":163,"rating":3.804812,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shifty Kenny Raptor","authId":"","name":"Shifty Kenny Raptor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shifty Kenny Raptor","authId":"","name":"Shifty Kenny Raptor","CNNId":"","myGameChains":null,"banStatus":null},"id":12503848,"name":"Nano Chase Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shifty/Kenny/Raptor/12503848.jpg","createDate":{"time":1274860250000,"minutes":50,"seconds":50,"hours":3,"month":4,"timezoneOffset":240,"year":110,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shifty/Kenny/Raptor/12503848.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":46265,"difficulty":2.5946301979144364,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":175914,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":162,"rating":4.76112,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bashful Chuck Fritter","authId":"","name":"Bashful Chuck Fritter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bashful Chuck Fritter","authId":"","name":"Bashful Chuck Fritter","CNNId":"","myGameChains":null,"banStatus":null},"id":14229942,"name":"Big Laser Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bashful/Chuck/Fritter/14229942.jpg","createDate":{"time":1290473103000,"minutes":45,"seconds":3,"hours":19,"month":10,"timezoneOffset":300,"year":110,"day":1,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bashful/Chuck/Fritter/14229942.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11486,"difficulty":2.903325494321915,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":425041,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":162,"rating":4.843361,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"161","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":"170","currentPageToDisplay":17,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]