[{"getMostDifficult":{"content":{"limit":200,"numberOfItemsPerPage":10,"pagesArray":["1","2","3","4"],"count":35,"SQLFilter":null,"limitStatement":" AND ROWNUM <= 200","totalRecordsSQL":"Select count(*) as \"PlatinumGames.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 Game.status = 1 and gamestat.timesplayed >='1000000' AND Game.id = GameStat.gameid order by gamestat.timesplayed desc) where rownum <= 200) ORDER BY Gamestat.timesplayed DESC) ","list":[{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":8349243,"name":"Omniverse Rook Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/8349243.jpg","createDate":{"time":1232233595000,"minutes":6,"seconds":35,"hours":18,"month":0,"timezoneOffset":300,"year":109,"day":6,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/8349243.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":79738239,"difficulty":2.9238317626575316,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1643974355,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":7939,"rating":4.308132,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":8150473,"name":"Omniverse Titan Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/8150473.jpg","createDate":{"time":1230872198000,"minutes":56,"seconds":38,"hours":23,"month":0,"timezoneOffset":300,"year":109,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/8150473.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3871609,"difficulty":2.7304161631943655,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":435129956,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":7093,"rating":3.891241,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":8394289,"name":"Pulse Burst Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/8394289.jpg","createDate":{"time":1232488238000,"minutes":50,"seconds":38,"hours":16,"month":0,"timezoneOffset":300,"year":109,"day":2,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/8394289.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":109043114,"difficulty":1.3000728225959752,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":229249333,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":5809,"rating":4.214423,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":8393227,"name":"Breaker Force Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/8393227.jpg","createDate":{"time":1232480146000,"minutes":35,"seconds":46,"hours":14,"month":0,"timezoneOffset":300,"year":109,"day":2,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/8393227.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":56892576,"difficulty":2.272285480171899,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63230160,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4303,"rating":4.502306,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":17189328,"name":"Sonic Alien Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/17189328.jpg","createDate":{"time":1341478515000,"minutes":55,"seconds":15,"hours":4,"month":6,"timezoneOffset":240,"year":112,"day":4,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/17189328.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":37635,"difficulty":2.5746002371269237,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9899349,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":32,"rating":2.776584,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":17210173,"name":"Solar Adventure Kickin Hawk","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/17210173.jpg","createDate":{"time":1342032294000,"minutes":44,"seconds":54,"hours":14,"month":6,"timezoneOffset":240,"year":112,"day":3,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/17210173.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":477920,"difficulty":2.398630612627042,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9549812,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":32,"rating":4.169667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":17197654,"name":"Ultimate Echo Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/17197654.jpg","createDate":{"time":1341689568000,"minutes":32,"seconds":48,"hours":15,"month":6,"timezoneOffset":240,"year":112,"day":6,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/17197654.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":661686,"difficulty":2.5742664581086943,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8018279,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":32,"rating":4.242792,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":17189294,"name":"Adventure Alien Ball Weevil","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/17189294.jpg","createDate":{"time":1341477237000,"minutes":33,"seconds":57,"hours":4,"month":6,"timezoneOffset":240,"year":112,"day":4,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/17189294.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":403634,"difficulty":2.7971155716844422,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7947808,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":17,"rating":4.607915,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":17194268,"name":"Hero Lightning Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/17194268.jpg","createDate":{"time":1341607818000,"minutes":50,"seconds":18,"hours":16,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/17194268.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5484326,"difficulty":1.6417984225855555,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7800302,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":56,"rating":3.09759,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"MagneticCrystal1","authId":"","name":"MagneticCrystal1","CNNId":"","myGameChains":null,"banStatus":null},"id":17203556,"name":"Omniverse Alien Snare-Oh","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/MagneticCrystal1/17203556.jpg","createDate":{"time":1341849810000,"minutes":3,"seconds":30,"hours":12,"month":6,"timezoneOffset":240,"year":112,"day":1,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"MagneticCrystal1/17203556.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":398601,"difficulty":2.501308153655652,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6118238,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":28,"rating":4.234588,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"1","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 Game.status = 1 and gamestat.timesplayed >='1000000' AND Game.id = GameStat.gameid order by gamestat.timesplayed desc) where rownum <= 200) ORDER BY Gamestat.timesplayed DESC","endRecordId":"10","currentPageToDisplay":1,"totalNumberOfPages":4},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]