[{"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":"Elusive Austin Chipmunk","authId":"","name":"Elusive Austin Chipmunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elusive Austin Chipmunk","authId":"","name":"Elusive Austin Chipmunk","CNNId":"","myGameChains":null,"banStatus":null},"id":3079026,"name":"Patrol Universe Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elusive/Austin/Chipmunk/3079026.jpg","createDate":{"time":1213043827000,"minutes":37,"seconds":7,"hours":16,"month":5,"timezoneOffset":240,"year":108,"day":1,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elusive/Austin/Chipmunk/3079026.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1638,"difficulty":2.7505201109864115,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":273608,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":249,"rating":4.098354,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Adam Bagpipe","authId":"","name":"Elite Adam Bagpipe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Adam Bagpipe","authId":"","name":"Elite Adam Bagpipe","CNNId":"","myGameChains":null,"banStatus":null},"id":14189292,"name":"Plasma Cosmic Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/Adam/Bagpipe/14189292.jpg","createDate":{"time":1289926057000,"minutes":47,"seconds":37,"hours":11,"month":10,"timezoneOffset":300,"year":110,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/Adam/Bagpipe/14189292.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":42151,"difficulty":1.6522867775656216,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":728475,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":247,"rating":2.006626,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hectic Harvey Monolith","authId":"","name":"Hectic Harvey Monolith","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hectic Harvey Monolith","authId":"","name":"Hectic Harvey Monolith","CNNId":"","myGameChains":null,"banStatus":null},"id":3471566,"name":"Storm Rocket Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hectic/Harvey/Monolith/3471566.jpg","createDate":{"time":1213720328000,"minutes":32,"seconds":8,"hours":12,"month":5,"timezoneOffset":240,"year":108,"day":2,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hectic/Harvey/Monolith/3471566.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2006,"difficulty":2.0778532443987934,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":234761,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":245,"rating":3.975435,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Musical Devin Zigzag","authId":"","name":"Musical Devin Zigzag","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Musical Devin Zigzag","authId":"","name":"Musical Devin Zigzag","CNNId":"","myGameChains":null,"banStatus":null},"id":3471967,"name":"Animo Force Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Musical/Devin/Zigzag/3471967.jpg","createDate":{"time":1213720728000,"minutes":38,"seconds":48,"hours":12,"month":5,"timezoneOffset":240,"year":108,"day":2,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Musical/Devin/Zigzag/3471967.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11650,"difficulty":2.3901823187856035,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":265651,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":238,"rating":3.774787,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful Jake Cipher","authId":"","name":"Powerful Jake Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful Jake Cipher","authId":"","name":"Powerful Jake Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":3210087,"name":"Thunder Hero Jetray","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Powerful/Jake/Cipher/3210087.jpg","createDate":{"time":1213281102000,"minutes":31,"seconds":42,"hours":10,"month":5,"timezoneOffset":240,"year":108,"day":4,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Powerful/Jake/Cipher/3210087.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1031,"difficulty":2.1588300723165665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":461762,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":234,"rating":3.42189,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Wes Phantom","authId":"","name":"Fearless Wes Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Wes Phantom","authId":"","name":"Fearless Wes Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":6066404,"name":"Champion Quake Nova","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearless/Wes/Phantom/6066404.jpg","createDate":{"time":1219568457000,"minutes":0,"seconds":57,"hours":5,"month":7,"timezoneOffset":240,"year":108,"day":0,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearless/Wes/Phantom/6066404.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3676,"difficulty":1.787453063851149,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":313248,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":232,"rating":4.454241,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Abstract Kyle Bramble","authId":"","name":"Abstract Kyle Bramble","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abstract Kyle Bramble","authId":"","name":"Abstract Kyle Bramble","CNNId":"","myGameChains":null,"banStatus":null},"id":17216572,"name":"Echo Target Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abstract/Kyle/Bramble/17216572.jpg","createDate":{"time":1342184949000,"minutes":9,"seconds":9,"hours":9,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abstract/Kyle/Bramble/17216572.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":324853,"difficulty":2.392499123549171,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":913389,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":232,"rating":4.83922,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Cody Splat","authId":"","name":"Jolly Cody Splat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Cody Splat","authId":"","name":"Jolly Cody Splat","CNNId":"","myGameChains":null,"banStatus":null},"id":5186556,"name":"Energy Clash Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jolly/Cody/Splat/5186556.jpg","createDate":{"time":1216911398000,"minutes":56,"seconds":38,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jolly/Cody/Splat/5186556.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":58246,"difficulty":1.4221855475057423,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":483172,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":231,"rating":2.858449,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Tara Ukulele","authId":"","name":"Spectral Tara Ukulele","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Tara Ukulele","authId":"","name":"Spectral Tara Ukulele","CNNId":"","myGameChains":null,"banStatus":null},"id":9135037,"name":"Vilgax Fury Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spectral/Tara/Ukulele/9135037.jpg","createDate":{"time":1238360354000,"minutes":59,"seconds":14,"hours":16,"month":2,"timezoneOffset":240,"year":109,"day":0,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spectral/Tara/Ukulele/9135037.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":47032,"difficulty":2.4983820883473737,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":657122,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":230,"rating":4.234151,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Bubba Zombie","authId":"","name":"Dashing Bubba Zombie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Bubba Zombie","authId":"","name":"Dashing Bubba Zombie","CNNId":"","myGameChains":null,"banStatus":null},"id":5187093,"name":"Solar Hyper Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dashing/Bubba/Zombie/5187093.jpg","createDate":{"time":1216912191000,"minutes":9,"seconds":51,"hours":11,"month":6,"timezoneOffset":240,"year":108,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dashing/Bubba/Zombie/5187093.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":42684,"difficulty":1.5261216609072121,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":194997,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":226,"rating":1.938984,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]