[{"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":"Artistic Adam Aurora","authId":"","name":"Artistic Adam Aurora","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Artistic Adam Aurora","authId":"","name":"Artistic Adam Aurora","CNNId":"","myGameChains":null,"banStatus":null},"id":3814721,"name":"Dark Rustbucket Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Artistic/Adam/Aurora/3814721.jpg","createDate":{"time":1214172626000,"minutes":10,"seconds":26,"hours":18,"month":5,"timezoneOffset":240,"year":108,"day":0,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Artistic/Adam/Aurora/3814721.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":92202,"difficulty":1.441486521391756,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":872103,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1000,"rating":3.292072,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Napoleon Shinobi","authId":"","name":"Flying Napoleon Shinobi","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Napoleon Shinobi","authId":"","name":"Flying Napoleon Shinobi","CNNId":"","myGameChains":null,"banStatus":null},"id":17216028,"name":"Titan Thunder Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Flying/Napoleon/Shinobi/17216028.jpg","createDate":{"time":1342159889000,"minutes":11,"seconds":29,"hours":2,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Flying/Napoleon/Shinobi/17216028.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":601650,"difficulty":2.2775852486753037,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1334993,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":957,"rating":4.626294,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sly Zeus Blitz","authId":"","name":"Sly Zeus Blitz","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sly Zeus Blitz","authId":"","name":"Sly Zeus Blitz","CNNId":"","myGameChains":null,"banStatus":null},"id":3671382,"name":"Cosmic Doom Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sly/Zeus/Blitz/3671382.jpg","createDate":{"time":1213988651000,"minutes":4,"seconds":11,"hours":15,"month":5,"timezoneOffset":240,"year":108,"day":5,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sly/Zeus/Blitz/3671382.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36800,"difficulty":2.364711779374366,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":339780,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":919,"rating":3.976139,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Bernard Smidgen","authId":"","name":"Fizzy Bernard Smidgen","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Bernard Smidgen","authId":"","name":"Fizzy Bernard Smidgen","CNNId":"","myGameChains":null,"banStatus":null},"id":11858857,"name":"Humongousaur Alien Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fizzy/Bernard/Smidgen/11858857.jpg","createDate":{"time":1265106595000,"minutes":29,"seconds":55,"hours":5,"month":1,"timezoneOffset":300,"year":110,"day":2,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fizzy/Bernard/Smidgen/11858857.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":316910,"difficulty":2.6951153922951736,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":498789,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":890,"rating":4.595137,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Witty Zelda Yodel","authId":"","name":"Witty Zelda Yodel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Witty Zelda Yodel","authId":"","name":"Witty Zelda Yodel","CNNId":"","myGameChains":null,"banStatus":null},"id":3590572,"name":"Energy Rustbucket Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Witty/Zelda/Yodel/3590572.jpg","createDate":{"time":1213886376000,"minutes":39,"seconds":36,"hours":10,"month":5,"timezoneOffset":240,"year":108,"day":4,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Witty/Zelda/Yodel/3590572.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17397,"difficulty":2.3910822760529347,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":880452,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":858,"rating":3.982909,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Matthew Nacho","authId":"","name":"Wild Matthew Nacho","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Matthew Nacho","authId":"","name":"Wild Matthew Nacho","CNNId":"","myGameChains":null,"banStatus":null},"id":3671755,"name":"Adventure Danger Spidermonkey","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wild/Matthew/Nacho/3671755.jpg","createDate":{"time":1213988878000,"minutes":7,"seconds":58,"hours":15,"month":5,"timezoneOffset":240,"year":108,"day":5,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wild/Matthew/Nacho/3671755.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":79484,"difficulty":2.1562284821505346,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":776087,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":844,"rating":3.573199,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stylish Alex Dragon","authId":"","name":"Stylish Alex Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stylish Alex Dragon","authId":"","name":"Stylish Alex Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":3666380,"name":"Danger Burst Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stylish/Alex/Dragon/3666380.jpg","createDate":{"time":1213984778000,"minutes":59,"seconds":38,"hours":13,"month":5,"timezoneOffset":240,"year":108,"day":5,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stylish/Alex/Dragon/3666380.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":47889,"difficulty":2.2512063609443222,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":521458,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":835,"rating":3.699544,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fuzzy Carol Elephant","authId":"","name":"Fuzzy Carol Elephant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fuzzy Carol Elephant","authId":"","name":"Fuzzy Carol Elephant","CNNId":"","myGameChains":null,"banStatus":null},"id":10500893,"name":"Galaxy Fusion Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fuzzy/Carol/Elephant/10500893.jpg","createDate":{"time":1249218913000,"minutes":15,"seconds":13,"hours":9,"month":7,"timezoneOffset":240,"year":109,"day":0,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fuzzy/Carol/Elephant/10500893.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13558,"difficulty":2.8709234310583724,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":881966,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":741,"rating":3.312444,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy Meghan Werewolf","authId":"","name":"Zippy Meghan Werewolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy Meghan Werewolf","authId":"","name":"Zippy Meghan Werewolf","CNNId":"","myGameChains":null,"banStatus":null},"id":10485968,"name":"Nova Vilgax Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zippy/Meghan/Werewolf/10485968.jpg","createDate":{"time":1249050635000,"minutes":30,"seconds":35,"hours":10,"month":6,"timezoneOffset":240,"year":109,"day":5,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zippy/Meghan/Werewolf/10485968.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":48195,"difficulty":2.012661265184876,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":786318,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":707,"rating":3.587769,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Howling John Blade","authId":"","name":"Howling John Blade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Howling John Blade","authId":"","name":"Howling John Blade","CNNId":"","myGameChains":null,"banStatus":null},"id":1747551,"name":"Rocket Giga Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Howling/John/Blade/1747551.jpg","createDate":{"time":1211490842000,"minutes":14,"seconds":2,"hours":17,"month":4,"timezoneOffset":240,"year":108,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Howling/John/Blade/1747551.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5896,"difficulty":1.5169940926257213,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":497645,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":686,"rating":3.869956,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"21","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":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]