[{"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":"Crispy Tabitha Nibbles","authId":"","name":"Crispy Tabitha Nibbles","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Tabitha Nibbles","authId":"","name":"Crispy Tabitha Nibbles","CNNId":"","myGameChains":null,"banStatus":null},"id":5186943,"name":"Drone Storm Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crispy/Tabitha/Nibbles/5186943.jpg","createDate":{"time":1216911984000,"minutes":6,"seconds":24,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crispy/Tabitha/Nibbles/5186943.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16913,"difficulty":2.451516509015048,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":249852,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":176,"rating":3.17682,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Charles Manatee","authId":"","name":"Fearless Charles Manatee","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Charles Manatee","authId":"","name":"Fearless Charles Manatee","CNNId":"","myGameChains":null,"banStatus":null},"id":8489915,"name":"Warrior Nova Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearless/Charles/Manatee/8489915.jpg","createDate":{"time":1233241955000,"minutes":12,"seconds":35,"hours":10,"month":0,"timezoneOffset":300,"year":109,"day":4,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearless/Charles/Manatee/8489915.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":37016,"difficulty":1.4442442512513247,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":154290,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":176,"rating":4.291088,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Infinite Misty Phantom","authId":"","name":"Infinite Misty Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Infinite Misty Phantom","authId":"","name":"Infinite Misty Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":5187162,"name":"Alien Cosmic Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Infinite/Misty/Phantom/5187162.jpg","createDate":{"time":1216912320000,"minutes":12,"seconds":0,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Infinite/Misty/Phantom/5187162.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1245,"difficulty":2.579842783493291,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":333363,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":176,"rating":3.921312,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghostly April Mustang","authId":"","name":"Ghostly April Mustang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghostly April Mustang","authId":"","name":"Ghostly April Mustang","CNNId":"","myGameChains":null,"banStatus":null},"id":5186848,"name":"Cosmic Racer Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghostly/April/Mustang/5186848.jpg","createDate":{"time":1216911841000,"minutes":4,"seconds":1,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghostly/April/Mustang/5186848.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6271,"difficulty":1.704217207052631,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":271687,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":176,"rating":4.522243,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghostly Wilma Aurora","authId":"","name":"Ghostly Wilma Aurora","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghostly Wilma Aurora","authId":"","name":"Ghostly Wilma Aurora","CNNId":"","myGameChains":null,"banStatus":null},"id":5187055,"name":"Escape Racer Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghostly/Wilma/Aurora/5187055.jpg","createDate":{"time":1216912142000,"minutes":9,"seconds":2,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghostly/Wilma/Aurora/5187055.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36749,"difficulty":1.8838826119230452,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":195161,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":176,"rating":3.16445,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Devious Crystal Varmint","authId":"","name":"Devious Crystal Varmint","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Devious Crystal Varmint","authId":"","name":"Devious Crystal Varmint","CNNId":"","myGameChains":null,"banStatus":null},"id":15572642,"name":"Spark Defense Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Devious/Crystal/Varmint/15572642.jpg","createDate":{"time":1303000178000,"minutes":29,"seconds":38,"hours":20,"month":3,"timezoneOffset":240,"year":111,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Devious/Crystal/Varmint/15572642.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":63125,"difficulty":2.2266930208234608,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":378421,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":175,"rating":4.76437,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Aidan Molecule","authId":"","name":"Grizzly Aidan Molecule","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Aidan Molecule","authId":"","name":"Grizzly Aidan Molecule","CNNId":"","myGameChains":null,"banStatus":null},"id":5186509,"name":"Mega Vilgax Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grizzly/Aidan/Molecule/5186509.jpg","createDate":{"time":1216911329000,"minutes":55,"seconds":29,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grizzly/Aidan/Molecule/5186509.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":45795,"difficulty":2.552324433233459,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":304739,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":174,"rating":4.669543,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Igor Wombat","authId":"","name":"Odd Igor Wombat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Igor Wombat","authId":"","name":"Odd Igor Wombat","CNNId":"","myGameChains":null,"banStatus":null},"id":5186830,"name":"Adventure Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Odd/Igor/Wombat/5186830.jpg","createDate":{"time":1216911817000,"minutes":3,"seconds":37,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Odd/Igor/Wombat/5186830.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":153175,"difficulty":2.2732713348295914,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":171813,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":173,"rating":3.206608,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Derek Kumquat","authId":"","name":"Blue Derek Kumquat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Derek Kumquat","authId":"","name":"Blue Derek Kumquat","CNNId":"","myGameChains":null,"banStatus":null},"id":5186553,"name":"Metal Droid Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Derek/Kumquat/5186553.jpg","createDate":{"time":1216911390000,"minutes":56,"seconds":30,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Derek/Kumquat/5186553.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":122818,"difficulty":2.042664921989945,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":190163,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":173,"rating":3.488438,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Cameron Bolt","authId":"","name":"Atomic Cameron Bolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Cameron Bolt","authId":"","name":"Atomic Cameron Bolt","CNNId":"","myGameChains":null,"banStatus":null},"id":3974700,"name":"Cosmic Spidermonkey Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Cameron/Bolt/3974700.jpg","createDate":{"time":1214451883000,"minutes":44,"seconds":43,"hours":23,"month":5,"timezoneOffset":240,"year":108,"day":3,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Cameron/Bolt/3974700.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9010,"difficulty":2.612307739066952,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":190790,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":173,"rating":4.154832,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"141","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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]