Mine

UPDATE `l2jdb`.`npc` SET `type` = 'L2SiegeGuard',
`faction_id` = 'goddard_siege_clan' WHERE CONCAT( `npc`.`id` ) between '35326' and '35351';
UPDATE `l2jdb`.`npc` SET `type` = 'L2Doormen' WHERE CONCAT( `npc`.`id` ) between '35356' and '35358';
UPDATE `l2jdb`.`npc` SET `type` = 'L2SiegeGuard',
`faction_id` = 'rune_siege_clan' WHERE CONCAT( `npc`.`id` ) between '35471' and '35496'; 
UPDATE `l2jdb`.`npc` SET `type` = 'L2Doormen' WHERE CONCAT( `npc`.`id` ) between '35503' and '35505'; 
UPDATE `l2jdb`.`npc` SET `type` = 'L2SiegeGuard',
`faction_id` = 'schuttgart_siege_clan' WHERE CONCAT( `npc`.`id` ) between '35518' and '35543'; 
UPDATE `l2jdb`.`npc` SET `type` = 'L2Doormen' WHERE CONCAT( `npc`.`id` ) between '35548' and '35550';
UPDATE `l2jdb`.`npc` SET `type` = 'L2Artefact',
`faction_id` = '' WHERE CONCAT( `npc`.`id` ) =35322 LIMIT 1
UPDATE `l2jdb`.`npc` SET `type` = 'L2Artefact',
`faction_id` = '' WHERE CONCAT( `npc`.`id` ) =35323 LIMIT 1
UPDATE `l2jdb`.`npc` SET `type` = 'L2Artefact',
`faction_id` = '' WHERE CONCAT( `npc`.`id` ) =35469 LIMIT 1
UPDATE `l2jdb`.`npc` SET `type` = 'L2Artefact',
`faction_id` = '' WHERE CONCAT( `npc`.`id` ) =35514 LIMIT 1
UPDATE `l2jdb`.`npc` SET `type` = 'L2Artefact',
`faction_id` = '' WHERE CONCAT( `npc`.`id` ) =35515 LIMIT 1