Required items

[AndMetal]

I'm sure the syntax is 100% correct, but you should be able to do something like this:

DELETE FROM items 
	WHERE id NOT IN (
		(SELECT components1 FROM spells_new WHERE components1 > 1000), 
		(SELECT components2 FROM spells_new WHERE components2 > 1000), 
		(SELECT components3 FROM spells_new WHERE components3 > 1000), 
		(SELECT components4 FROM spells_new WHERE components4 > 1000), 
		(SELECT NoexpendReagent1 FROM spells_new WHERE NoexpendReagent1 > 1000), 
		(SELECT NoexpendReagent2 FROM spells_new WHERE NoexpendReagent2 > 1000), 
		(SELECT NoexpendReagent3 FROM spells_new WHERE NoexpendReagent3 > 1000), 
		(SELECT NoexpendReagent4 FROM spells_new WHERE NoexpendReagent4 > 1000)
	)

[cavedude]

Originally Posted by AndMetal

I'm sure the syntax is 100% correct, but you should be able to do something like this:

DELETE FROM items 
	WHERE id NOT IN (
		(SELECT components1 FROM spells_new WHERE components1 > 1000), 
		(SELECT components2 FROM spells_new WHERE components2 > 1000), 
		(SELECT components3 FROM spells_new WHERE components3 > 1000), 
		(SELECT components4 FROM spells_new WHERE components4 > 1000), 
		(SELECT NoexpendReagent1 FROM spells_new WHERE NoexpendReagent1 > 1000), 
		(SELECT NoexpendReagent2 FROM spells_new WHERE NoexpendReagent2 > 1000), 
		(SELECT NoexpendReagent3 FROM spells_new WHERE NoexpendReagent3 > 1000), 
		(SELECT NoexpendReagent4 FROM spells_new WHERE NoexpendReagent4 > 1000)
	)

effect_base_value1, 2, 3, and 4 are also used, to summon items I believe.

[Shadow-Wolf]

Originally Posted by AndMetal

I'm sure the syntax is 100% correct, but you should be able to do something like this:

DELETE FROM items 
	WHERE id NOT IN (
		(SELECT components1 FROM spells_new WHERE components1 > 1000), 
		(SELECT components2 FROM spells_new WHERE components2 > 1000), 
		(SELECT components3 FROM spells_new WHERE components3 > 1000), 
		(SELECT components4 FROM spells_new WHERE components4 > 1000), 
		(SELECT NoexpendReagent1 FROM spells_new WHERE NoexpendReagent1 > 1000), 
		(SELECT NoexpendReagent2 FROM spells_new WHERE NoexpendReagent2 > 1000), 
		(SELECT NoexpendReagent3 FROM spells_new WHERE NoexpendReagent3 > 1000), 
		(SELECT NoexpendReagent4 FROM spells_new WHERE NoexpendReagent4 > 1000)
	)

With a little modification adding the fields Cavedude specified this will give me exactly what I needed. Thank you everyone for your help!

[Shadow-Wolf]

Hmm, while the syntax throws no errors there is something wrong with the statements logic as it deletes no items at all, looking into it.

Edit - When running this through an sql validator I get this

The following feature outside Core SQL-200x (draft) is used:
F561, "Full value expressions""