[{"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":"Brave Brad Platypus","authId":"","name":"Brave Brad Platypus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Brad Platypus","authId":"","name":"Brave Brad Platypus","CNNId":"","myGameChains":null,"banStatus":null},"id":2200668,"name":"Humongousaur Ultra Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brave/Brad/Platypus/2200668.jpg","createDate":{"time":1211824861000,"minutes":1,"seconds":1,"hours":14,"month":4,"timezoneOffset":240,"year":108,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brave/Brad/Platypus/2200668.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10713,"difficulty":1.4518384364640597,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":119728,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":187,"rating":3.325971,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Chase Gargoyle","authId":"","name":"Atomic Chase Gargoyle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Chase Gargoyle","authId":"","name":"Atomic Chase Gargoyle","CNNId":"","myGameChains":null,"banStatus":null},"id":3069127,"name":"Humongousaur Ultimate Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Chase/Gargoyle/3069127.jpg","createDate":{"time":1213034438000,"minutes":0,"seconds":38,"hours":14,"month":5,"timezoneOffset":240,"year":108,"day":1,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Chase/Gargoyle/3069127.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6338,"difficulty":2.164654725613937,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":225255,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":185,"rating":4.411841,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Miranda Sawtooth","authId":"","name":"Alien Miranda Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Miranda Sawtooth","authId":"","name":"Alien Miranda Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"id":9087611,"name":"Humongousaur Power Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Miranda/Sawtooth/9087611.jpg","createDate":{"time":1238110380000,"minutes":33,"seconds":0,"hours":19,"month":2,"timezoneOffset":240,"year":109,"day":4,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Miranda/Sawtooth/9087611.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":91,"difficulty":2.921827990974865,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":262776,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":182,"rating":4.621357,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Gregory Rhino","authId":"","name":"Magnetic Gregory Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Gregory Rhino","authId":"","name":"Magnetic Gregory Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":5187186,"name":"Galaxy Force Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Gregory/Rhino/5187186.jpg","createDate":{"time":1216912355000,"minutes":12,"seconds":35,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Gregory/Rhino/5187186.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26490,"difficulty":1.9800614552623872,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":208097,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":182,"rating":3.159245,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Florence Elephant","authId":"","name":"Mumbling Florence Elephant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Florence Elephant","authId":"","name":"Mumbling Florence Elephant","CNNId":"","myGameChains":null,"banStatus":null},"id":5198755,"name":"Dark Adventure Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mumbling/Florence/Elephant/5198755.jpg","createDate":{"time":1216927318000,"minutes":21,"seconds":58,"hours":15,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mumbling/Florence/Elephant/5198755.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":40492,"difficulty":1.8352197853745387,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":76539,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":181,"rating":2.820045,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Kaylee Avocado","authId":"","name":"Gorgeous Kaylee Avocado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Kaylee Avocado","authId":"","name":"Gorgeous Kaylee Avocado","CNNId":"","myGameChains":null,"banStatus":null},"id":9067596,"name":"Adventure Rocket Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gorgeous/Kaylee/Avocado/9067596.jpg","createDate":{"time":1237913116000,"minutes":45,"seconds":16,"hours":12,"month":2,"timezoneOffset":240,"year":109,"day":2,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gorgeous/Kaylee/Avocado/9067596.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":136491,"difficulty":1.5160713443911815,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":245199,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":180,"rating":4.588386,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Strange Hunter Spark","authId":"","name":"Strange Hunter Spark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strange Hunter Spark","authId":"","name":"Strange Hunter Spark","CNNId":"","myGameChains":null,"banStatus":null},"id":5187218,"name":"Thunder Star Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strange/Hunter/Spark/5187218.jpg","createDate":{"time":1216912452000,"minutes":14,"seconds":12,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strange/Hunter/Spark/5187218.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":35797,"difficulty":2.383505668380344,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":171696,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":180,"rating":2.032188,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Adorable Aidan Shock","authId":"","name":"Adorable Aidan Shock","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Adorable Aidan Shock","authId":"","name":"Adorable Aidan Shock","CNNId":"","myGameChains":null,"banStatus":null},"id":5006419,"name":"Jetray Mega Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Adorable/Aidan/Shock/5006419.jpg","createDate":{"time":1216477189000,"minutes":19,"seconds":49,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":6,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Adorable/Aidan/Shock/5006419.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8306,"difficulty":2.248851090493758,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17247,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":180,"rating":4.182941,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Noisy Noah Narwhal","authId":"","name":"Noisy Noah Narwhal","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Noisy Noah Narwhal","authId":"","name":"Noisy Noah Narwhal","CNNId":"","myGameChains":null,"banStatus":null},"id":5186941,"name":"Mega Metal Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Noisy/Noah/Narwhal/5186941.jpg","createDate":{"time":1216911980000,"minutes":6,"seconds":20,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Noisy/Noah/Narwhal/5186941.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":85303,"difficulty":1.9731010640455708,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":129903,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":179,"rating":2.92418,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mirthful Mitchell Gorilla","authId":"","name":"Mirthful Mitchell Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mirthful Mitchell Gorilla","authId":"","name":"Mirthful Mitchell Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"id":8892177,"name":"Swampfire Fury Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mirthful/Mitchell/Gorilla/8892177.jpg","createDate":{"time":1236205246000,"minutes":20,"seconds":46,"hours":17,"month":2,"timezoneOffset":300,"year":109,"day":3,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mirthful/Mitchell/Gorilla/8892177.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8058,"difficulty":2.399367360634785,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":238741,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":177,"rating":4.239734,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]