[{"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":"Noble Pedro Llama","authId":"","name":"Noble Pedro Llama","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Noble Pedro Llama","authId":"","name":"Noble Pedro Llama","CNNId":"","myGameChains":null,"banStatus":null},"id":5187159,"name":"Alien Rescue Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Noble/Pedro/Llama/5187159.jpg","createDate":{"time":1216912318000,"minutes":11,"seconds":58,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Noble/Pedro/Llama/5187159.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2448,"difficulty":2.4097172650949368,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":165523,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":211,"rating":3.313139,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Austin Thunder","authId":"","name":"Babbling Austin Thunder","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Austin Thunder","authId":"","name":"Babbling Austin Thunder","CNNId":"","myGameChains":null,"banStatus":null},"id":5164699,"name":"Power Search Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Babbling/Austin/Thunder/5164699.jpg","createDate":{"time":1216850156000,"minutes":55,"seconds":56,"hours":17,"month":6,"timezoneOffset":240,"year":108,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Babbling/Austin/Thunder/5164699.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10785,"difficulty":2.72341081438418,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":68496,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":210,"rating":4.416594,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Adam Klunk","authId":"","name":"Dashing Adam Klunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Adam Klunk","authId":"","name":"Dashing Adam Klunk","CNNId":"","myGameChains":null,"banStatus":null},"id":5187037,"name":"Adventure Challenge Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dashing/Adam/Klunk/5187037.jpg","createDate":{"time":1216912107000,"minutes":8,"seconds":27,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dashing/Adam/Klunk/5187037.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":84749,"difficulty":2.0313522640311104,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":124193,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":208,"rating":3.260376,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Daring Ben Figment","authId":"","name":"Daring Ben Figment","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Daring Ben Figment","authId":"","name":"Daring Ben Figment","CNNId":"","myGameChains":null,"banStatus":null},"id":9129705,"name":"Rustbucket Rumble Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Daring/Ben/Figment/9129705.jpg","createDate":{"time":1238346785000,"minutes":13,"seconds":5,"hours":13,"month":2,"timezoneOffset":240,"year":109,"day":0,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Daring/Ben/Figment/9129705.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":37810,"difficulty":1.6202018490394157,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":248590,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":208,"rating":3.507259,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Carrie Yoyo","authId":"","name":"Towering Carrie Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Carrie Yoyo","authId":"","name":"Towering Carrie Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":6815071,"name":"Thunder Ben Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Towering/Carrie/Yoyo/6815071.jpg","createDate":{"time":1224118235000,"minutes":50,"seconds":35,"hours":20,"month":9,"timezoneOffset":240,"year":108,"day":3,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Towering/Carrie/Yoyo/6815071.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":42861,"difficulty":1.9847401807734906,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":356321,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":207,"rating":3.337895,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bizarre Xavier Zephyr","authId":"","name":"Bizarre Xavier Zephyr","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bizarre Xavier Zephyr","authId":"","name":"Bizarre Xavier Zephyr","CNNId":"","myGameChains":null,"banStatus":null},"id":11317888,"name":"Ultimate Escape Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bizarre/Xavier/Zephyr/11317888.jpg","createDate":{"time":1257909380000,"minutes":16,"seconds":20,"hours":22,"month":10,"timezoneOffset":300,"year":109,"day":2,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bizarre/Xavier/Zephyr/11317888.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":96,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":206,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Clever Blake Sawtooth","authId":"","name":"Clever Blake Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Clever Blake Sawtooth","authId":"","name":"Clever Blake Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"id":6595195,"name":"Power Ultra Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Clever/Blake/Sawtooth/6595195.jpg","createDate":{"time":1223351689000,"minutes":54,"seconds":49,"hours":23,"month":9,"timezoneOffset":240,"year":108,"day":1,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Clever/Blake/Sawtooth/6595195.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2271,"difficulty":2.366893179477677,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":343246,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":205,"rating":4.699673,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spooky Spike Skunk","authId":"","name":"Spooky Spike Skunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spooky Spike Skunk","authId":"","name":"Spooky Spike Skunk","CNNId":"","myGameChains":null,"banStatus":null},"id":3488208,"name":"Force Pursuit Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spooky/Spike/Skunk/3488208.jpg","createDate":{"time":1213734835000,"minutes":33,"seconds":55,"hours":16,"month":5,"timezoneOffset":240,"year":108,"day":2,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spooky/Spike/Skunk/3488208.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":69501,"difficulty":2.472717774103669,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":166254,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":205,"rating":3.663001,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearsome David Avocado","authId":"","name":"Fearsome David Avocado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearsome David Avocado","authId":"","name":"Fearsome David Avocado","CNNId":"","myGameChains":null,"banStatus":null},"id":8923597,"name":"Nova Thunder Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearsome/David/Avocado/8923597.jpg","createDate":{"time":1236467375000,"minutes":9,"seconds":35,"hours":18,"month":2,"timezoneOffset":300,"year":109,"day":6,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearsome/David/Avocado/8923597.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3653,"difficulty":2.584041401525261,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":361275,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":203,"rating":4.878261,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Rex Fox","authId":"","name":"Vigilant Rex Fox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Rex Fox","authId":"","name":"Vigilant Rex Fox","CNNId":"","myGameChains":null,"banStatus":null},"id":17212383,"name":"Spidermonkey Energy Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vigilant/Rex/Fox/17212383.jpg","createDate":{"time":1342095704000,"minutes":21,"seconds":44,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":4,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vigilant/Rex/Fox/17212383.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":153620,"difficulty":2.463828743028753,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1208962,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":203,"rating":4.564564,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"101","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":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]