SELECT COUNT(*) AS quant FROM vit_vehicles WHERE (prop_sold_date = 0 OR prop_sold_date >= DATE_SUB(NOW(),INTERVAL 7 DAY)) AND prop_admin_cancel = 0 AND (prop_date_end >= NOW() OR prop_date_end = 0)