[{"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":"Freaky Erik Dragon","authId":"","name":"Freaky Erik Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Freaky Erik Dragon","authId":"","name":"Freaky Erik Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":8940704,"name":"Sonic Swampfire Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Freaky/Erik/Dragon/8940704.jpg","createDate":{"time":1236559357000,"minutes":42,"seconds":37,"hours":20,"month":2,"timezoneOffset":240,"year":109,"day":0,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Freaky/Erik/Dragon/8940704.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":35960,"difficulty":1.7520276551431169,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":590950,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":157,"rating":3.81987,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Logan Coconut","authId":"","name":"Grizzly Logan Coconut","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Logan Coconut","authId":"","name":"Grizzly Logan Coconut","CNNId":"","myGameChains":null,"banStatus":null},"id":5186823,"name":"Pulse Solar Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grizzly/Logan/Coconut/5186823.jpg","createDate":{"time":1216911810000,"minutes":3,"seconds":30,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grizzly/Logan/Coconut/5186823.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":86169,"difficulty":2.316742833651146,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":234817,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":157,"rating":4.365791,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sneaky Herman Worm","authId":"","name":"Sneaky Herman Worm","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sneaky Herman Worm","authId":"","name":"Sneaky Herman Worm","CNNId":"","myGameChains":null,"banStatus":null},"id":5186720,"name":"Slam Adventure Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sneaky/Herman/Worm/5186720.jpg","createDate":{"time":1216911686000,"minutes":1,"seconds":26,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sneaky/Herman/Worm/5186720.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":64253,"difficulty":2.2382017457202625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":290207,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":156,"rating":3.28933,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bizarre Elroy Monster","authId":"","name":"Bizarre Elroy Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bizarre Elroy Monster","authId":"","name":"Bizarre Elroy Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":14052089,"name":"Pulse Pulse Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bizarre/Elroy/Monster/14052089.jpg","createDate":{"time":1286761533000,"minutes":45,"seconds":33,"hours":21,"month":9,"timezoneOffset":240,"year":110,"day":0,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bizarre/Elroy/Monster/14052089.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":78603,"difficulty":2.7839099080587517,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":139359,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":156,"rating":4.800148,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Dominic Bamboo","authId":"","name":"Fearless Dominic Bamboo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Dominic Bamboo","authId":"","name":"Fearless Dominic Bamboo","CNNId":"","myGameChains":null,"banStatus":null},"id":2018833,"name":"Lightning Battle Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearless/Dominic/Bamboo/2018833.jpg","createDate":{"time":1211682209000,"minutes":23,"seconds":29,"hours":22,"month":4,"timezoneOffset":240,"year":108,"day":6,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearless/Dominic/Bamboo/2018833.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":57825,"difficulty":1.3883325337959196,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":197909,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":155,"rating":3.21789,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Charming Patrick Sunshine","authId":"","name":"Charming Patrick Sunshine","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Charming Patrick Sunshine","authId":"","name":"Charming Patrick Sunshine","CNNId":"","myGameChains":null,"banStatus":null},"id":15691450,"name":"Universe Storm Pulse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Charming/Patrick/Sunshine/15691450.jpg","createDate":{"time":1306455512000,"minutes":18,"seconds":32,"hours":20,"month":4,"timezoneOffset":240,"year":111,"day":4,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Charming/Patrick/Sunshine/15691450.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":304349,"difficulty":2.2952064691023013,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":321627,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":155,"rating":3.358217,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Plucky Dora Android","authId":"","name":"Plucky Dora Android","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Plucky Dora Android","authId":"","name":"Plucky Dora Android","CNNId":"","myGameChains":null,"banStatus":null},"id":12555591,"name":"Adventure Clash Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Plucky/Dora/Android/12555591.jpg","createDate":{"time":1275487101000,"minutes":58,"seconds":21,"hours":9,"month":5,"timezoneOffset":240,"year":110,"day":3,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Plucky/Dora/Android/12555591.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":169787,"difficulty":1.9177335770409711,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":608171,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":155,"rating":3.534318,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cranky Matthew Gorilla","authId":"","name":"Cranky Matthew Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cranky Matthew Gorilla","authId":"","name":"Cranky Matthew Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"id":5186895,"name":"Plasma Nitro Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cranky/Matthew/Gorilla/5186895.jpg","createDate":{"time":1216911918000,"minutes":5,"seconds":18,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cranky/Matthew/Gorilla/5186895.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4028,"difficulty":2.516176525664605,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":338909,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":153,"rating":4.216641,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Ella Gong","authId":"","name":"Bouncing Ella Gong","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Ella Gong","authId":"","name":"Bouncing Ella Gong","CNNId":"","myGameChains":null,"banStatus":null},"id":5186722,"name":"Ultimate Cosmic Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bouncing/Ella/Gong/5186722.jpg","createDate":{"time":1216911702000,"minutes":1,"seconds":42,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bouncing/Ella/Gong/5186722.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6808,"difficulty":1.4701611037012976,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":247531,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":152,"rating":2.306987,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gleeful Landon Platypus","authId":"","name":"Gleeful Landon Platypus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gleeful Landon Platypus","authId":"","name":"Gleeful Landon Platypus","CNNId":"","myGameChains":null,"banStatus":null},"id":5186531,"name":"Ultimate Swampfire Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gleeful/Landon/Platypus/5186531.jpg","createDate":{"time":1216911365000,"minutes":56,"seconds":5,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gleeful/Landon/Platypus/5186531.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":515,"difficulty":2.659853131675015,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":295066,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":152,"rating":3.962394,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"181","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":"190","currentPageToDisplay":19,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]