[{"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":"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":3882160,"name":"Sonic Spidermonkey Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Cameron/Bolt/3882160.jpg","createDate":{"time":1214280532000,"minutes":8,"seconds":52,"hours":0,"month":5,"timezoneOffset":240,"year":108,"day":2,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Cameron/Bolt/3882160.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":115446,"difficulty":1.728002808914673,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1039425,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1499,"rating":4.474292,"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":6948393,"name":"Energy Rocket Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Duncan/Fury/6948393.jpg","createDate":{"time":1224906099000,"minutes":41,"seconds":39,"hours":23,"month":9,"timezoneOffset":240,"year":108,"day":5,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Duncan/Fury/6948393.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":70,"difficulty":2.300117317288305,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7889,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1490,"rating":4.672924,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleek Buffy Kazoo","authId":"","name":"Sleek Buffy Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleek Buffy Kazoo","authId":"","name":"Sleek Buffy Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"id":4977660,"name":"Danger Streak Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleek/Buffy/Kazoo/4977660.jpg","createDate":{"time":1216389155000,"minutes":52,"seconds":35,"hours":9,"month":6,"timezoneOffset":240,"year":108,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleek/Buffy/Kazoo/4977660.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26134,"difficulty":2.2622057853378434,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":994062,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1396,"rating":3.155582,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful John Sawtooth","authId":"","name":"Powerful John Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful John Sawtooth","authId":"","name":"Powerful John Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"id":3191393,"name":"Lightning Energy Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Powerful/John/Sawtooth/3191393.jpg","createDate":{"time":1213226866000,"minutes":27,"seconds":46,"hours":19,"month":5,"timezoneOffset":240,"year":108,"day":3,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Powerful/John/Sawtooth/3191393.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":44458,"difficulty":1.5219404567285486,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3559063,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1295,"rating":3.340646,"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":14865204,"name":"Beast Fury Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Duncan/Fury/14865204.jpg","createDate":{"time":1293670916000,"minutes":1,"seconds":56,"hours":20,"month":11,"timezoneOffset":300,"year":110,"day":3,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Duncan/Fury/14865204.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1284,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Zeus Calypso","authId":"","name":"Colossal Zeus Calypso","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Zeus Calypso","authId":"","name":"Colossal Zeus Calypso","CNNId":"","myGameChains":null,"banStatus":null},"id":7078910,"name":"Thunder Power Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colossal/Zeus/Calypso/7078910.jpg","createDate":{"time":1225759172000,"minutes":39,"seconds":32,"hours":19,"month":10,"timezoneOffset":300,"year":108,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colossal/Zeus/Calypso/7078910.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":423307,"difficulty":2.1445936837796147,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2040274,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1172,"rating":3.35735,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Duncan Thunder","authId":"","name":"Wild Duncan Thunder","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Duncan Thunder","authId":"","name":"Wild Duncan Thunder","CNNId":"","myGameChains":null,"banStatus":null},"id":4976075,"name":"Ultimate Doom Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wild/Duncan/Thunder/4976075.jpg","createDate":{"time":1216361327000,"minutes":8,"seconds":47,"hours":2,"month":6,"timezoneOffset":240,"year":108,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wild/Duncan/Thunder/4976075.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":37844,"difficulty":2.6560001462733527,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1214707,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1108,"rating":3.416831,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Lanky Bubba Sphere","authId":"","name":"Lanky Bubba Sphere","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lanky Bubba Sphere","authId":"","name":"Lanky Bubba Sphere","CNNId":"","myGameChains":null,"banStatus":null},"id":8399894,"name":"Force Magno Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lanky/Bubba/Sphere/8399894.jpg","createDate":{"time":1232550136000,"minutes":2,"seconds":16,"hours":10,"month":0,"timezoneOffset":300,"year":109,"day":3,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lanky/Bubba/Sphere/8399894.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":334,"difficulty":2.8961533115039417,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7697,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1105,"rating":4.820479,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eastern Joey Dragon","authId":"","name":"Eastern Joey Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eastern Joey Dragon","authId":"","name":"Eastern Joey Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":10458506,"name":"Cosmic Search Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eastern/Joey/Dragon/10458506.jpg","createDate":{"time":1248742990000,"minutes":3,"seconds":10,"hours":21,"month":6,"timezoneOffset":240,"year":109,"day":1,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eastern/Joey/Dragon/10458506.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":143330,"difficulty":2.5623588134629633,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":635903,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1045,"rating":3.635591,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Hank Dwarf","authId":"","name":"Crafty Hank Dwarf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Hank Dwarf","authId":"","name":"Crafty Hank Dwarf","CNNId":"","myGameChains":null,"banStatus":null},"id":3974995,"name":"Dark Rumble Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crafty/Hank/Dwarf/3974995.jpg","createDate":{"time":1214452623000,"minutes":57,"seconds":3,"hours":23,"month":5,"timezoneOffset":240,"year":108,"day":3,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crafty/Hank/Dwarf/3974995.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":270478,"difficulty":1.976376399728565,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2913646,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1032,"rating":3.811878,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"11","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":"20","currentPageToDisplay":2,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]