[{"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":"Normal Jose Creature","authId":"","name":"Normal Jose Creature","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Normal Jose Creature","authId":"","name":"Normal Jose Creature","CNNId":"","myGameChains":null,"banStatus":null},"id":8891345,"name":"Ambush Pursuit Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Normal/Jose/Creature/8891345.jpg","createDate":{"time":1236201089000,"minutes":11,"seconds":29,"hours":16,"month":2,"timezoneOffset":300,"year":109,"day":3,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Normal/Jose/Creature/8891345.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5780,"difficulty":2.53996320517826,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":243637,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":152,"rating":4.617998,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Pretty April Glacier","authId":"","name":"Pretty April Glacier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Pretty April Glacier","authId":"","name":"Pretty April Glacier","CNNId":"","myGameChains":null,"banStatus":null},"id":8450764,"name":"Spark Adventure Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Pretty/April/Glacier/8450764.jpg","createDate":{"time":1232911585000,"minutes":26,"seconds":25,"hours":14,"month":0,"timezoneOffset":300,"year":109,"day":0,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Pretty/April/Glacier/8450764.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":112,"difficulty":1.9583333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":504,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":151,"rating":3.444444,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty Cameron Bolt","authId":"","name":"Sporty Cameron Bolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty Cameron Bolt","authId":"","name":"Sporty Cameron Bolt","CNNId":"","myGameChains":null,"banStatus":null},"id":5186649,"name":"Swampfire Rush Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sporty/Cameron/Bolt/5186649.jpg","createDate":{"time":1216911558000,"minutes":59,"seconds":18,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sporty/Cameron/Bolt/5186649.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":42324,"difficulty":1.7850361078373664,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":262551,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":151,"rating":2.581945,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Nicole Ladybug","authId":"","name":"Crafty Nicole Ladybug","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Nicole Ladybug","authId":"","name":"Crafty Nicole Ladybug","CNNId":"","myGameChains":null,"banStatus":null},"id":5186764,"name":"Rush Blaster Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crafty/Nicole/Ladybug/5186764.jpg","createDate":{"time":1216911739000,"minutes":2,"seconds":19,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crafty/Nicole/Ladybug/5186764.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33834,"difficulty":1.5740241863580555,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":280067,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":151,"rating":2.944821,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Skylar Knight","authId":"","name":"Electric Skylar Knight","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Skylar Knight","authId":"","name":"Electric Skylar Knight","CNNId":"","myGameChains":null,"banStatus":null},"id":15748333,"name":"Power Whirlwind Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Skylar/Knight/15748333.jpg","createDate":{"time":1307647944000,"minutes":32,"seconds":24,"hours":15,"month":5,"timezoneOffset":240,"year":111,"day":4,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Skylar/Knight/15748333.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36753,"difficulty":2.2880843971189933,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":395609,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":151,"rating":4.514572,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Leshawna Bayou","authId":"","name":"Cackling Leshawna Bayou","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Leshawna Bayou","authId":"","name":"Cackling Leshawna Bayou","CNNId":"","myGameChains":null,"banStatus":null},"id":14745769,"name":"Magno Adventure Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cackling/Leshawna/Bayou/14745769.jpg","createDate":{"time":1292783455000,"minutes":30,"seconds":55,"hours":13,"month":11,"timezoneOffset":300,"year":110,"day":0,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cackling/Leshawna/Bayou/14745769.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":35480,"difficulty":2.521703009894068,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":168945,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":149,"rating":4.766928,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Mark Blade","authId":"","name":"Loyal Mark Blade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Mark Blade","authId":"","name":"Loyal Mark Blade","CNNId":"","myGameChains":null,"banStatus":null},"id":5186806,"name":"Swampfire Mega Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loyal/Mark/Blade/5186806.jpg","createDate":{"time":1216911777000,"minutes":2,"seconds":57,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loyal/Mark/Blade/5186806.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27212,"difficulty":2.6992393877818737,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":120829,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":149,"rating":4.513965,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Mandy Holler","authId":"","name":"Alien Mandy Holler","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Mandy Holler","authId":"","name":"Alien Mandy Holler","CNNId":"","myGameChains":null,"banStatus":null},"id":5186533,"name":"Clash Mission Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Mandy/Holler/5186533.jpg","createDate":{"time":1216911366000,"minutes":56,"seconds":6,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Mandy/Holler/5186533.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14882,"difficulty":2.161890589324142,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":314463,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":148,"rating":2.294356,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ticklish Wyatt Monkey","authId":"","name":"Ticklish Wyatt Monkey","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ticklish Wyatt Monkey","authId":"","name":"Ticklish Wyatt Monkey","CNNId":"","myGameChains":null,"banStatus":null},"id":5186710,"name":"Adventure Champion Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ticklish/Wyatt/Monkey/5186710.jpg","createDate":{"time":1216911675000,"minutes":1,"seconds":15,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ticklish/Wyatt/Monkey/5186710.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6930,"difficulty":1.3394171596553357,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":141689,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":147,"rating":1.886208,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"191","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":"199","currentPageToDisplay":20,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]