SELECT vpp.*, COUNT(vp.prop_no) AS quant FROM vit_pac_precision vpp LEFT JOIN vit_pac vp ON vp.prop_prec_no = vpp.prec_no LEFT JOIN vit_users vu ON vp.prop_usr_no = vu.usr_no WHERE vpp.prec_sub_prop_no = AND (vp.prop_sold = 0 OR vp.prop_sold IS NULL) AND (vp.prop_sold_date = 0 OR vp.prop_sold_date >= DATE_SUB(NOW(), INTERVAL 7 DAY)) AND (vp.prop_date_end >= NOW() OR vp.prop_date_end = 0 OR vp.prop_date_end IS NULL) AND vp.prop_admin_cancel < 1 AND vp.prop_loc_quantite > 0 AND vu.usr_act = -1 AND vp.prop_loc = 1 AND ((prop_loc = 1 AND prop_publish = 1) AND prop_price > 0) AND prop_typereserv < 4 GROUP BY vpp.prec_no HAVING quant > 0 ORDER BY vpp.prec_order, vpp.prec_desc