I am not in front of my eqemu computer but i beleive this will work for your chance adjustment
Code:
update lootdrop_entries set chance = 50 where item_id in (select id from items where name regexp '(Crude|Simple|Rough|Ornate|Flawed|Intricate|Elaborate|Elegant)( Defiant)');