UPDATE creature set spawntimesecs = '8800' WHERE MAP='540';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='389';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='43';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='36';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='33';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='48';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='34';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='90';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='47';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='189';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='129';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='70';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='209';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='349';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='109';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='230';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='229';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='429';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='329';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='289';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='309';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='540';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='543';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='542';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='540';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='546';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='545';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='550';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='553';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='552';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='557';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='558';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='565';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='544';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='547';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='556';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='554';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='560';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='269';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='534';
UPDATE creature set spawntimesecs = '8800' WHERE MAP='532';




UPDATE creature set spawntimesecs = '10800' WHERE MAP='540' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3'); 
UPDATE creature set spawntimesecs = '10800' WHERE MAP='389' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='43' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='36' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='33' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='48' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='34' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='90' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='47' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='189' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='129' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='70' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='209' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='349' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='109' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='230' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='229' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='429' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='329' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='289' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='309' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='540' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='543' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='542' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='540' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='546' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='545' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='550' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='553' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='552' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='557' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='558' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='565' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='544' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='547' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='556' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='554' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='560' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='269' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='534' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');
UPDATE creature set spawntimesecs = '10800' WHERE MAP='532' AND id IN (SELECT entry FROM `creature_template` WHERE `rank`='3');