[{"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":"Beastly Wyatt Ninja","authId":"","name":"Beastly Wyatt Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Beastly Wyatt Ninja","authId":"","name":"Beastly Wyatt Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":4971883,"name":"Hero Gear Burst","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Beastly/Wyatt/Ninja/4971883.jpg","createDate":{"time":1216341920000,"minutes":45,"seconds":20,"hours":20,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Beastly/Wyatt/Ninja/4971883.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":144,"difficulty":1.2380952380952381,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":495,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":673,"rating":2.962963,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Happy Max Volcano","authId":"","name":"Happy Max Volcano","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Happy Max Volcano","authId":"","name":"Happy Max Volcano","CNNId":"","myGameChains":null,"banStatus":null},"id":10488892,"name":"Shadow Droid Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Happy/Max/Volcano/10488892.jpg","createDate":{"time":1249071277000,"minutes":14,"seconds":37,"hours":16,"month":6,"timezoneOffset":240,"year":109,"day":5,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Happy/Max/Volcano/10488892.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27964,"difficulty":1.4772921560206846,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":659741,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":653,"rating":3.870391,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Royal Billy Mosquito","authId":"","name":"Royal Billy Mosquito","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Royal Billy Mosquito","authId":"","name":"Royal Billy Mosquito","CNNId":"","myGameChains":null,"banStatus":null},"id":9157718,"name":"Rampage Streak Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Royal/Billy/Mosquito/9157718.jpg","createDate":{"time":1238567182000,"minutes":26,"seconds":22,"hours":2,"month":3,"timezoneOffset":240,"year":109,"day":3,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Royal/Billy/Mosquito/9157718.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":59954,"difficulty":2.162282888543628,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":934262,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":633,"rating":4.457228,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Napoleon Shinobi","authId":"","name":"Flying Napoleon Shinobi","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Napoleon Shinobi","authId":"","name":"Flying Napoleon Shinobi","CNNId":"","myGameChains":null,"banStatus":null},"id":17216071,"name":"Hyper Metal Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Flying/Napoleon/Shinobi/17216071.jpg","createDate":{"time":1342162106000,"minutes":48,"seconds":26,"hours":2,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Flying/Napoleon/Shinobi/17216071.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":200292,"difficulty":2.4814329274263116,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2361312,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":619,"rating":4.678509,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Jared Wizard","authId":"","name":"Aquatic Jared Wizard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Jared Wizard","authId":"","name":"Aquatic Jared Wizard","CNNId":"","myGameChains":null,"banStatus":null},"id":6610167,"name":"Sonic Solar Spidermonkey","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aquatic/Jared/Wizard/6610167.jpg","createDate":{"time":1223424754000,"minutes":12,"seconds":34,"hours":20,"month":9,"timezoneOffset":240,"year":108,"day":2,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aquatic/Jared/Wizard/6610167.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1209,"difficulty":2.908459973095347,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1158755,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":582,"rating":4.043082,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Larry Ion","authId":"","name":"Icy Larry Ion","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Larry Ion","authId":"","name":"Icy Larry Ion","CNNId":"","myGameChains":null,"banStatus":null},"id":17214721,"name":"Star Atomic Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Larry/Ion/17214721.jpg","createDate":{"time":1342131070000,"minutes":11,"seconds":10,"hours":18,"month":6,"timezoneOffset":240,"year":112,"day":4,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Larry/Ion/17214721.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":153271,"difficulty":2.4941981792370043,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1484039,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":575,"rating":4.45478,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Juggling Waldo Jungle","authId":"","name":"Juggling Waldo Jungle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Juggling Waldo Jungle","authId":"","name":"Juggling Waldo Jungle","CNNId":"","myGameChains":null,"banStatus":null},"id":15231954,"name":"Space Rustbucket Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Juggling/Waldo/Jungle/15231954.jpg","createDate":{"time":1297819762000,"minutes":29,"seconds":22,"hours":20,"month":1,"timezoneOffset":300,"year":111,"day":2,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Juggling/Waldo/Jungle/15231954.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":188150,"difficulty":2.181471617930497,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":336581,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":514,"rating":4.828495,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Alex Bolt","authId":"","name":"Bouncing Alex Bolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Alex Bolt","authId":"","name":"Bouncing Alex Bolt","CNNId":"","myGameChains":null,"banStatus":null},"id":6298430,"name":"Spidermonkey Adventure Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bouncing/Alex/Bolt/6298430.jpg","createDate":{"time":1221081764000,"minutes":22,"seconds":44,"hours":17,"month":8,"timezoneOffset":240,"year":108,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bouncing/Alex/Bolt/6298430.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4545,"difficulty":2.1722504155117575,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":688589,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":465,"rating":1.850329,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Duncan Fury","authId":"","name":"Blue Duncan Fury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Duncan Fury","authId":"","name":"Blue Duncan Fury","CNNId":"","myGameChains":null,"banStatus":null},"id":6813112,"name":"Spidermonkey Sonic Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Duncan/Fury/6813112.jpg","createDate":{"time":1224113983000,"minutes":39,"seconds":43,"hours":19,"month":9,"timezoneOffset":240,"year":108,"day":3,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Duncan/Fury/6813112.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":81,"difficulty":2.627222222222222,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":916,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":455,"rating":4.540816,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearsome Ariana Chipmunk","authId":"","name":"Fearsome Ariana Chipmunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearsome Ariana Chipmunk","authId":"","name":"Fearsome Ariana Chipmunk","CNNId":"","myGameChains":null,"banStatus":null},"id":6001520,"name":"Blaster Smash Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearsome/Ariana/Chipmunk/6001520.jpg","createDate":{"time":1219266484000,"minutes":8,"seconds":4,"hours":17,"month":7,"timezoneOffset":240,"year":108,"day":3,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearsome/Ariana/Chipmunk/6001520.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":231213,"difficulty":1.1279906932537185,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":367018,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":452,"rating":2.948121,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"31","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":"40","currentPageToDisplay":4,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]