[NatedogEZ]

SELECT le.* FROM items i
INNER JOIN lootdrop_entries le ON i.id = le.item_id
WHERE i.name like "Crude defiant%"


Change the WHERE clause to find the other types and just remove the rows all at once