---

SELECT COUNT(*) FROM promos WHERE promos.promo_vallarta = 'S' AND promos.vie = 1