If you only want to remove them from the loot tables use:
to see what there are:
Code:
SELECT
`items`.`id`
FROM
`lootdrop_entries`
LEFT JOIN
`items`
ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
`items`.`reclevel` > 60;
Code:
SELECT
`items`.`id`
FROM
`lootdrop_entries`
LEFT JOIN
`items`
ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
`items`.`reqlevel` > 60;
to delete:
Code:
DELETE
`lootdrop_entries`
FROM
`lootdrop_entries`
LEFT JOIN
`items`
ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
`items`.`reclevel` > 60;
and
Code:
DELETE
`lootdrop_entries`
FROM
`lootdrop_entries`
LEFT JOIN
`items`
ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
`items`.`reqlevel` > 60;