[Uleat]

DELETE FROM `lootdrop_entries`
WHERE `item_id` IN (
  SELECT `id` FROM `items` WHERE `Name` LIKE 'Ornate Defiant%' 
);

With something like that, you can tailor the inner query to your desires before you ever run the outer one.