bella idea, viene:

SELECT email FROM tabella WHERE 1 AND prov IN ('AL','BI','AT','CN','NO','TO','VB','VC') ORDER BY id

vedi, mi prende correttamente la 2a where (quella PROV) ma la 1a WHERE manco la considera