blackrock caverns

//blackrock caverns

DELETE FROM `creature` WHERE `id` = 50376 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 51398 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 50417 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 49930 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 40008 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 40817 AND `map` = 645;

DELETE FROM `creature` WHERE `guid` IN (
6646361,
6646359,
6646360,
6646358,
6645772,
6645773,
6645774,
6645764,
6645767,
6645765,
6645766);

UPDATE `creature` SET `position_x` = 73.26, `position_y` = 593.84, `position_z` = 77.74, `orientation` = 5.92 WHERE `guid` = 405270;
UPDATE `creature` SET `MovementType` = 0 WHERE id IN (40015, 39700, 40011, 40013);
UPDATE `creature_template` SET `MovementType` = 0 WHERE entry IN (40015, 39700, 40011, 40013);

UPDATE `creature` SET `MovementType`=0 WHERE `id` = 40817;
UPDATE `creature_template` SET `MovementType`=0 WHERE `entry` = 40817;
UPDATE `creature` SET `MovementType`=0 WHERE `id` = 39705;
UPDATE `creature_template` SET `MovementType`=0 WHERE `entry` = 39705;