I wanted to remove defiant and the googles brought me here.
So here is what i just ran on my db if anyone wants to remove the chance for these to drop
Code:
UPDATE peq.loottable_entries
JOIN peq.lootdrop_entries ON peq.lootdrop_entries.lootdrop_id = peq.loottable_entries.lootdrop_id
JOIN peq.items ON peq.items.id = peq.lootdrop_entries.item_id
SET peq.loottable_entries.probability = 0
WHERE peq.items.name like "%defiant%" AND peq.items.lore like "%For%"
haven't tested it yet in game but it should work