SELECT *, (SELECT COUNT(*) FROM vit_pac, vit_users WHERE prop_usr_no = usr_no AND usr_act = -1 AND prop_loc = 1 AND prop_publish = 1 AND prop_tprop_no = vit_type_property.tprop_no   AND ((prop_loc = 1 AND prop_publish = 1) AND prop_price > 0)  AND prop_typereserv < 4 AND (prop_sold_date = 0 OR prop_sold_date >= DATE_SUB(NOW(),INTERVAL 7 DAY))  AND prop_admin_cancel = 0 AND prop_loc_quantite > 0 AND (prop_date_end >= NOW() OR prop_date_end = 0)) AS quant FROM vit_type_property WHERE tprop_site_code = 'pac' AND tprop_no IN (SELECT prop_tprop_no FROM vit_pac WHERE prop_sold = 0  AND prop_admin_cancel = 0 AND prop_loc_quantite > 0 AND (prop_date_end >= NOW() OR prop_date_end = 0)) HAVING QUANT > 0 ORDER BY tprop_desc_fr