[{"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":"Awesome Ben Lobster","authId":"","name":"Awesome Ben Lobster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Ben Lobster","authId":"","name":"Awesome Ben Lobster","CNNId":"","myGameChains":null,"banStatus":null},"id":749732,"name":"Star Gear Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images/749732_051120081220.jpg","createDate":{"time":1210522032000,"minutes":7,"seconds":12,"hours":12,"month":4,"timezoneOffset":240,"year":108,"day":0,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"749732_051120081220.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":40324,"difficulty":1.7525698776562422,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":551738,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":442,"rating":2.409482,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Feisty Rick Steam","authId":"","name":"Feisty Rick Steam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Feisty Rick Steam","authId":"","name":"Feisty Rick Steam","CNNId":"","myGameChains":null,"banStatus":null},"id":5016985,"name":"Ultra Warrior Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Feisty/Rick/Steam/5016985.jpg","createDate":{"time":1216492580000,"minutes":36,"seconds":20,"hours":14,"month":6,"timezoneOffset":240,"year":108,"day":6,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Feisty/Rick/Steam/5016985.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5444,"difficulty":2.2986239634855563,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":634026,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":419,"rating":4.402466,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Metallic Danny Kiwi","authId":"","name":"Metallic Danny Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Metallic Danny Kiwi","authId":"","name":"Metallic Danny Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"id":11858798,"name":"Swampfire Atomic Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Metallic/Danny/Kiwi/11858798.jpg","createDate":{"time":1265104198000,"minutes":49,"seconds":58,"hours":4,"month":1,"timezoneOffset":300,"year":110,"day":2,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Metallic/Danny/Kiwi/11858798.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":200866,"difficulty":2.3783515354198643,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":619247,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":415,"rating":4.242581,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Lanky Bubba Sphere","authId":"","name":"Lanky Bubba Sphere","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lanky Bubba Sphere","authId":"","name":"Lanky Bubba Sphere","CNNId":"","myGameChains":null,"banStatus":null},"id":8001292,"name":"Giga Spark Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lanky/Bubba/Sphere/8001292.jpg","createDate":{"time":1230211805000,"minutes":30,"seconds":5,"hours":8,"month":11,"timezoneOffset":300,"year":108,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lanky/Bubba/Sphere/8001292.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":73,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":537,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":410,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Massive Zeke Ninja","authId":"","name":"Massive Zeke Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Massive Zeke Ninja","authId":"","name":"Massive Zeke Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":1600639,"name":"Plasma Hyper Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Massive/Zeke/Ninja/1600639.jpg","createDate":{"time":1211314535000,"minutes":15,"seconds":35,"hours":16,"month":4,"timezoneOffset":240,"year":108,"day":2,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Massive/Zeke/Ninja/1600639.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":31288,"difficulty":2.004202564995989,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":351980,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":399,"rating":3.340164,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Luke Eel","authId":"","name":"Gorgeous Luke Eel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Luke Eel","authId":"","name":"Gorgeous Luke Eel","CNNId":"","myGameChains":null,"banStatus":null},"id":3238723,"name":"Streak Iron Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gorgeous/Luke/Eel/3238723.jpg","createDate":{"time":1213368880000,"minutes":54,"seconds":40,"hours":10,"month":5,"timezoneOffset":240,"year":108,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gorgeous/Luke/Eel/3238723.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":165427,"difficulty":2.2037954775861426,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":279671,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":385,"rating":3.614879,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hefty Amber Robot","authId":"","name":"Hefty Amber Robot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hefty Amber Robot","authId":"","name":"Hefty Amber Robot","CNNId":"","myGameChains":null,"banStatus":null},"id":9156899,"name":"Smash Defense Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hefty/Amber/Robot/9156899.jpg","createDate":{"time":1238550130000,"minutes":42,"seconds":10,"hours":21,"month":2,"timezoneOffset":240,"year":109,"day":2,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hefty/Amber/Robot/9156899.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":357950,"difficulty":1.924016754307591,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":796206,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":381,"rating":2.821902,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Egbert Planet","authId":"","name":"Loyal Egbert Planet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Egbert Planet","authId":"","name":"Loyal Egbert Planet","CNNId":"","myGameChains":null,"banStatus":null},"id":8142667,"name":"Ultra Alien Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loyal/Egbert/Planet/8142667.jpg","createDate":{"time":1230847676000,"minutes":7,"seconds":56,"hours":17,"month":0,"timezoneOffset":300,"year":109,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loyal/Egbert/Planet/8142667.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2518,"difficulty":2.964775130197606,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":224781,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":376,"rating":4.921766,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Adam Blade","authId":"","name":"Blue Adam Blade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Adam Blade","authId":"","name":"Blue Adam Blade","CNNId":"","myGameChains":null,"banStatus":null},"id":6578104,"name":"Adventure Hex Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Adam/Blade/6578104.jpg","createDate":{"time":1223302742000,"minutes":19,"seconds":2,"hours":10,"month":9,"timezoneOffset":240,"year":108,"day":1,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Adam/Blade/6578104.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":167671,"difficulty":2.476199322696566,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":521781,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":375,"rating":4.571721,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Happy Mariah Lobster","authId":"","name":"Happy Mariah Lobster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Happy Mariah Lobster","authId":"","name":"Happy Mariah Lobster","CNNId":"","myGameChains":null,"banStatus":null},"id":11857790,"name":"Earth Slam Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Happy/Mariah/Lobster/11857790.jpg","createDate":{"time":1265073248000,"minutes":14,"seconds":8,"hours":20,"month":1,"timezoneOffset":300,"year":110,"day":1,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Happy/Mariah/Lobster/11857790.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19488,"difficulty":2.262552357111874,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":833969,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":372,"rating":4.037267,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"41","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":"50","currentPageToDisplay":5,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]