lower HP and AC by 25% in crushbone version 0
Code:
UPDATE npc_types n
INNER JOIN spawnentry se ON n.id = se.npcID
INNER JOIN spawngroup sg ON sg.id = se.spawngroupID
INNER JOIN spawn2 s ON se.spawngroupID = s.spawngroupID
SET
n.`hp` = `hp` * 0.75,
n.`ac` = `ac` * 0.75
WHERE s.zone = 'crushbone'
and s.version = 0;