Mysql Query help

[spoon]

And if you want required:

mysql> DELETE FROM `items` WHERE `reqlevel` > 60;

[spoon]

If you only want to remove them from the loot tables use:

to see what there are:

SELECT
	`items`.`id`
FROM
	`lootdrop_entries`
	LEFT JOIN
		`items`
	ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
	`items`.`reclevel` > 60;

SELECT
	`items`.`id`
FROM
	`lootdrop_entries`
	LEFT JOIN
		`items`
	ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
	`items`.`reqlevel` > 60;

to delete:

DELETE
	`lootdrop_entries`
FROM
		`lootdrop_entries`
	LEFT JOIN
		`items`
	ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
	`items`.`reclevel` > 60;

and

DELETE
	`lootdrop_entries`
FROM
		`lootdrop_entries`
	LEFT JOIN
		`items`
	ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
	`items`.`reqlevel` > 60;

[AndMetal]

If you wanted to do both at the same time, you should be able to add an OR to the WHERE clause. Same with the SELECT query.

[ChaosSlayer]

recommended level over 60