SELECT * FROM datos.comercios WHERE (co_fecha BETWEEN '2000-1-1' AND '2010-12-31') OR (co_pais like '%esp%')