for a start, you may want to use the following SQL queries :
Code:
delete from merchantlist using merchantlist, items where merchantlist.item=items.id and items.cost > 100000;
will remove all entries in merchant list where item cost is above 100000
and
Code:
delete from merchantlist using merchantlist, items where merchantlist.item=items.id and items.name like '%Paineel%';
will get you rid of entries in merchant list where name contains Paineel.
i hope this can save you time
