SELECT *, (SELECT COUNT(*) FROM vit_pac, vit_users WHERE prop_usr_no = usr_no AND usr_act = -1 AND prop_tpsub_no = vit_type_property_sub.tpsub_no  AND ( prop_usr_no = '9898' OR  prop_usr_no = '4651' OR  prop_usr_no = '5174' OR  prop_usr_no = '9898' OR  prop_usr_no = '4651' OR  prop_usr_no = '5174')  AND ((prop_paypal = 1 OR prop_loc = 1) AND prop_price > 0)  AND (prop_no_interne = 'vtt' OR prop_title like '%vtt%' OR prop_engtitle like '%vtt%' OR prop_desc like '%vtt%' OR prop_engdesc like '%vtt%' OR prop_index like '%vtt%') AND (prop_no_interne = '' OR prop_title like '%%' OR prop_engtitle like '%%' OR prop_desc like '%%' OR prop_engdesc like '%%' OR prop_index like '%%') AND (prop_no_interne = 'vtt' OR prop_title like '%vtt%' OR prop_engtitle like '%vtt%' OR prop_desc like '%vtt%' OR prop_engdesc like '%vtt%' OR prop_index like '%vtt%') AND (prop_no_interne = '' OR prop_title like '%%' OR prop_engtitle like '%%' OR prop_desc like '%%' OR prop_engdesc like '%%' OR prop_index like '%%')  AND (prop_sold_date = 0 OR prop_sold_date >= DATE_SUB(NOW(),INTERVAL 7 DAY)) AND prop_admin_cancel < 1 AND prop_loc_quantite > 0 AND (prop_date_end >= NOW() OR prop_date_end = 0)) AS quant FROM vit_type_property_sub WHERE tpsub_del = 0 AND tpsub_tprop_no = 24 AND tpsub_no IN (SELECT prop_tpsub_no FROM vit_pac WHERE prop_sold = 0  AND ( prop_usr_no = '9898' OR  prop_usr_no = '4651' OR  prop_usr_no = '5174' OR  prop_usr_no = '9898' OR  prop_usr_no = '4651' OR  prop_usr_no = '5174') AND prop_admin_cancel < 1 AND prop_loc_quantite > 0 AND (prop_date_end >= NOW() OR prop_date_end = 0)) HAVING quant > 0 ORDER BY tpsub_desc_fr