[{"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":"Babbling James Nova","authId":"","name":"Babbling James Nova","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling James Nova","authId":"","name":"Babbling James Nova","CNNId":"","myGameChains":null,"banStatus":null},"id":6578136,"name":"Rocket Blaster Danger","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Babbling/James/Nova/6578136.jpg","createDate":{"time":1223303286000,"minutes":28,"seconds":6,"hours":10,"month":9,"timezoneOffset":240,"year":108,"day":1,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Babbling/James/Nova/6578136.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":32530,"difficulty":2.132936708640865,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":503146,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":203,"rating":3.24367,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearsome Ariana Chipmunk","authId":"","name":"Fearsome Ariana Chipmunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearsome Ariana Chipmunk","authId":"","name":"Fearsome Ariana Chipmunk","CNNId":"","myGameChains":null,"banStatus":null},"id":6000953,"name":"Adventure Atomic Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearsome/Ariana/Chipmunk/6000953.jpg","createDate":{"time":1219265148000,"minutes":45,"seconds":48,"hours":16,"month":7,"timezoneOffset":240,"year":108,"day":3,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearsome/Ariana/Chipmunk/6000953.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":95093,"difficulty":1.627498324129741,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":163355,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":203,"rating":4.146448,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Patricia Dragon","authId":"","name":"Wild Patricia Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Patricia Dragon","authId":"","name":"Wild Patricia Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":5049018,"name":"Drone Droid Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wild/Patricia/Dragon/5049018.jpg","createDate":{"time":1216581099000,"minutes":11,"seconds":39,"hours":15,"month":6,"timezoneOffset":240,"year":108,"day":0,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wild/Patricia/Dragon/5049018.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":88134,"difficulty":1.540417930428308,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":149323,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":199,"rating":3.19881,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Gigi Tusk","authId":"","name":"Colossal Gigi Tusk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Gigi Tusk","authId":"","name":"Colossal Gigi Tusk","CNNId":"","myGameChains":null,"banStatus":null},"id":9088267,"name":"Humongousaur Streak Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colossal/Gigi/Tusk/9088267.jpg","createDate":{"time":1238112805000,"minutes":13,"seconds":25,"hours":20,"month":2,"timezoneOffset":240,"year":109,"day":4,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colossal/Gigi/Tusk/9088267.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":84152,"difficulty":1.8324495891009613,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":759671,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":197,"rating":4.400004,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Heroic Jeff Mosquito","authId":"","name":"Heroic Jeff Mosquito","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Heroic Jeff Mosquito","authId":"","name":"Heroic Jeff Mosquito","CNNId":"","myGameChains":null,"banStatus":null},"id":6772034,"name":"Steel Metal Rustbucket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Heroic/Jeff/Mosquito/6772034.jpg","createDate":{"time":1223872562000,"minutes":36,"seconds":2,"hours":0,"month":9,"timezoneOffset":240,"year":108,"day":1,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Heroic/Jeff/Mosquito/6772034.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4227,"difficulty":2.7204188025947103,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":344063,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":197,"rating":3.114656,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Irwin Citrus","authId":"","name":"Magnetic Irwin Citrus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Irwin Citrus","authId":"","name":"Magnetic Irwin Citrus","CNNId":"","myGameChains":null,"banStatus":null},"id":3337837,"name":"Burst Hex Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Irwin/Citrus/3337837.jpg","createDate":{"time":1213499617000,"minutes":13,"seconds":37,"hours":23,"month":5,"timezoneOffset":240,"year":108,"day":6,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Irwin/Citrus/3337837.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8,"difficulty":2.9374574161058353,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":576299,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":197,"rating":4.057379,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Tom Ketchup","authId":"","name":"Gigantic Tom Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Tom Ketchup","authId":"","name":"Gigantic Tom Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"id":152108,"name":"Warrior Swampfire Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images/152108_050620080425.jpg","createDate":{"time":1210100673000,"minutes":4,"seconds":33,"hours":15,"month":4,"timezoneOffset":240,"year":108,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"152108_050620080425.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28791,"difficulty":1.405340405530943,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":125807,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":196,"rating":4.877607,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble Logan Galaxy","authId":"","name":"Humble Logan Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble Logan Galaxy","authId":"","name":"Humble Logan Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"id":16274706,"name":"Warrior Light Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humble/Logan/Galaxy/16274706.jpg","createDate":{"time":1319398758000,"minutes":39,"seconds":18,"hours":15,"month":9,"timezoneOffset":240,"year":111,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humble/Logan/Galaxy/16274706.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":116353,"difficulty":1.723226370101125,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":167602,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":195,"rating":4.83686,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hardy Megan Buffalo","authId":"","name":"Hardy Megan Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hardy Megan Buffalo","authId":"","name":"Hardy Megan Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"id":5186724,"name":"Metal Cosmic Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hardy/Megan/Buffalo/5186724.jpg","createDate":{"time":1216911704000,"minutes":1,"seconds":44,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hardy/Megan/Buffalo/5186724.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11178,"difficulty":2.5157323904568862,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":216028,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":194,"rating":2.149409,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy Daniel Thing","authId":"","name":"Zippy Daniel Thing","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy Daniel Thing","authId":"","name":"Zippy Daniel Thing","CNNId":"","myGameChains":null,"banStatus":null},"id":5186551,"name":"Mega Shadow Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zippy/Daniel/Thing/5186551.jpg","createDate":{"time":1216911390000,"minutes":56,"seconds":30,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zippy/Daniel/Thing/5186551.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22851,"difficulty":1.4943521433230704,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":183724,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":194,"rating":3.971239,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"111","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":"120","currentPageToDisplay":12,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]