codice:
WHERE 
'2009-05-13' BETWEEN valida_da AND valida_fino
AND
'2009-05-16' BETWEEN valida_da AND valida_fino