[{"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":"Western Jackie Storm","authId":"","name":"Western Jackie Storm","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Jackie Storm","authId":"","name":"Western Jackie Storm","CNNId":"","myGameChains":null,"banStatus":null},"id":5187035,"name":"Cosmic Space Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Western/Jackie/Storm/5187035.jpg","createDate":{"time":1216912104000,"minutes":8,"seconds":24,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Western/Jackie/Storm/5187035.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":52314,"difficulty":1.6229107542746855,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":201381,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":172,"rating":3.486629,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Modest Erik Bayou","authId":"","name":"Modest Erik Bayou","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Modest Erik Bayou","authId":"","name":"Modest Erik Bayou","CNNId":"","myGameChains":null,"banStatus":null},"id":5186819,"name":"Chase Stone Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Modest/Erik/Bayou/5186819.jpg","createDate":{"time":1216911807000,"minutes":3,"seconds":27,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Modest/Erik/Bayou/5186819.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":67262,"difficulty":1.4600186508422426,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":244650,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":171,"rating":1.728409,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Honest David Volcano","authId":"","name":"Honest David Volcano","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Honest David Volcano","authId":"","name":"Honest David Volcano","CNNId":"","myGameChains":null,"banStatus":null},"id":5187207,"name":"Sonic Turbo Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Honest/David/Volcano/5187207.jpg","createDate":{"time":1216912424000,"minutes":13,"seconds":44,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Honest/David/Volcano/5187207.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15941,"difficulty":1.3589821010435068,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":268381,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":171,"rating":3.112185,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Marco Penguin","authId":"","name":"Atomic Marco Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Marco Penguin","authId":"","name":"Atomic Marco Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":6127205,"name":"Spidermonkey Ultra Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Marco/Penguin/6127205.jpg","createDate":{"time":1219929429000,"minutes":17,"seconds":9,"hours":9,"month":7,"timezoneOffset":240,"year":108,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Marco/Penguin/6127205.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2793,"difficulty":1.8283943608851516,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":161887,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":169,"rating":4.511971,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Heroic Briana Bolt","authId":"","name":"Heroic Briana Bolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Heroic Briana Bolt","authId":"","name":"Heroic Briana Bolt","CNNId":"","myGameChains":null,"banStatus":null},"id":8940252,"name":"Hero Alien Pulse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Heroic/Briana/Bolt/8940252.jpg","createDate":{"time":1236557368000,"minutes":9,"seconds":28,"hours":20,"month":2,"timezoneOffset":240,"year":109,"day":0,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Heroic/Briana/Bolt/8940252.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":62298,"difficulty":2.3812063297003263,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":509067,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":168,"rating":3.947213,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Wolfgang Blob","authId":"","name":"Zany Wolfgang Blob","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Wolfgang Blob","authId":"","name":"Zany Wolfgang Blob","CNNId":"","myGameChains":null,"banStatus":null},"id":5187060,"name":"Vilgax Chase Rustbucket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zany/Wolfgang/Blob/5187060.jpg","createDate":{"time":1216912148000,"minutes":9,"seconds":8,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zany/Wolfgang/Blob/5187060.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":18042,"difficulty":2.393933790231434,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":288533,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":168,"rating":4.649293,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful Patrick Aurora","authId":"","name":"Powerful Patrick Aurora","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful Patrick Aurora","authId":"","name":"Powerful Patrick Aurora","CNNId":"","myGameChains":null,"banStatus":null},"id":5187167,"name":"Mega Nova Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Powerful/Patrick/Aurora/5187167.jpg","createDate":{"time":1216912332000,"minutes":12,"seconds":12,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Powerful/Patrick/Aurora/5187167.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":29828,"difficulty":2.205871601256724,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":133895,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":168,"rating":1.993192,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Hazel Phantom","authId":"","name":"Chilly Hazel Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Hazel Phantom","authId":"","name":"Chilly Hazel Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":5173120,"name":"Techno Drone Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Chilly/Hazel/Phantom/5173120.jpg","createDate":{"time":1216860680000,"minutes":51,"seconds":20,"hours":20,"month":6,"timezoneOffset":240,"year":108,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Chilly/Hazel/Phantom/5173120.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":45556,"difficulty":2.4933395513763355,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74196,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":168,"rating":1.929734,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Savage Sam Virtuoso","authId":"","name":"Savage Sam Virtuoso","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Savage Sam Virtuoso","authId":"","name":"Savage Sam Virtuoso","CNNId":"","myGameChains":null,"banStatus":null},"id":6030870,"name":"Jetray Magno Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Savage/Sam/Virtuoso/6030870.jpg","createDate":{"time":1219421154000,"minutes":5,"seconds":54,"hours":12,"month":7,"timezoneOffset":240,"year":108,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Savage/Sam/Virtuoso/6030870.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4324,"difficulty":1.5405082413902418,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":195927,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":167,"rating":2.116018,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eerie Ron Bonkers","authId":"","name":"Eerie Ron Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eerie Ron Bonkers","authId":"","name":"Eerie Ron Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"id":5186620,"name":"Mega Swampfire Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eerie/Ron/Bonkers/5186620.jpg","createDate":{"time":1216911512000,"minutes":58,"seconds":32,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eerie/Ron/Bonkers/5186620.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22377,"difficulty":1.9968752647451826,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":301977,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":167,"rating":3.141308,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"151","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":"160","currentPageToDisplay":16,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]