SET @highx := -3042;
SET @lowx := -4563;
SET @highy := `730;
SET @lowy := -10000;
SET @MAP := 530;
use test2;
TRUNCATE TABLE creatureid;
TRUNCATE TABLE gameobid;
TRUNCATE TABLE questid;
TRUNCATE TABLE itemid;
INSERT INTO `test2`.creatureid (id) (SELECT DISTINCT(id) FROM `remorse_world`.creature where position_x BETWEEN @lowx AND @highx AND position_y BETWEEN @lowy AND @highy AND map = @MAP);
INSERT INTO `test2`.gameobid (id) (SELECT DISTINCT(id) FROM `remorse_world`.gameobject where position_x BETWEEN @lowx AND @highx AND position_y BETWEEN @lowy AND @highy AND map = @MAP);
INSERT INTO `test2`.questid (id) (SELECT DISTINCT(quest) FROM `remorse_world`.creature_questrelation WHERE id IN (SELECT id FROM test2.creatureid));
INSERT INTO `test2`.questid (id) (SELECT DISTINCT(quest) FROM `remorse_world`.creature_involvedrelation WHERE id IN (SELECT id FROM test2.creatureid));
INSERT INTO `test2`.itemid (id) (SELECT DISTINCT(item) FROM `remorse_world`.creature_loot_template WHERE entry IN (SELECT id FROM test2.creatureid));
use remorse_world;
SELECT * FROM creature_loot_template WHERE entry  IN (SELECT id FROM `test2`.creatureid);
SELECT * FROM creature_template WHERE entry  IN (SELECT id FROM `test2`.creatureid);
SELECT `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags` FROM creature WHERE position_x BETWEEN @lowx AND @highx AND position_y BETWEEN @lowy AND @highy AND map = @MAP;
SELECT * FROM creature_involvedrelation WHERE id  IN (SELECT id FROM `test2`.creatureid);
SELECT * FROM creature_questrelation WHERE id  IN (SELECT id FROM `test2`.creatureid);
SELECT * FROM quest_template WHERE entry IN (SELECT id FROM test2.questid);
SELECT * FROM gameobject_template WHERE entry  IN (SELECT id FROM `test2`.gameobid);
SELECT `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state` FROM gameobject WHERE position_x BETWEEN @lowx AND @highx AND position_y BETWEEN @lowy AND @highy AND map = @MAP;
SELECT * FROM item_template where entry IN (SELECT id from `test2`.itemid);
use test2;
TRUNCATE TABLE creatureid;
TRUNCATE TABLE gameobid;
TRUNCATE TABLE questid;
TRUNCATE TABLE itemid;