( SELECT COUNT(*) AS nbrattr, tprop_desc_fr, tprop_no FROM vit_properties, vit_cities, vit_type_property, vit_users WHERE usr_no = prop_usr_no AND usr_act = -1 AND tprop_no = prop_tprop_no AND prop_city_no = city_no AND ((SELECT COUNT(*) FROM vit_prop_pictures WHERE ppic_prop_no = prop_no) > 0) AND (prop_price >= 19.99) AND (prop_date_end >= NOW() OR prop_date_end = 0) AND (prop_sold_date = 0 OR prop_sold_date >= DATE_SUB(NOW(),INTERVAL 7 DAY)) AND prop_admin_cancel = 0 GROUP BY prop_tprop_no ORDER BY nbrattr DESC) UNION ( SELECT COUNT(*) AS nbrattr, tprop_desc_fr, tprop_no FROM vit_vehicles, vit_cities, vit_type_property, vit_users WHERE usr_no = prop_usr_no AND usr_act = -1 AND tprop_no = prop_tprop_no AND prop_city_no = city_no AND ((SELECT COUNT(*) FROM vit_veh_pictures WHERE ppic_prop_no = prop_no) > 0) AND (prop_price >= 19.99) AND (prop_date_end >= NOW() OR prop_date_end = 0) AND (prop_sold_date = 0 OR prop_sold_date >= DATE_SUB(NOW(),INTERVAL 7 DAY)) AND prop_admin_cancel = 0 GROUP BY prop_tprop_no ORDER BY nbrattr DESC) UNION ( SELECT COUNT(*) AS nbrattr, tprop_desc_fr, tprop_no FROM vit_pac, vit_cities, vit_type_property, vit_users WHERE usr_no = prop_usr_no AND usr_act = -1 AND tprop_no = prop_tprop_no AND prop_city_no = city_no AND ((SELECT COUNT(*) FROM vit_pac_pictures WHERE ppic_prop_no = prop_no) > 0) AND (prop_price >= 19.99) AND (prop_date_end >= NOW() OR prop_date_end = 0) AND (prop_sold_date = 0 OR prop_sold_date >= DATE_SUB(NOW(),INTERVAL 7 DAY)) AND prop_admin_cancel = 0 GROUP BY prop_tprop_no ORDER BY nbrattr DESC) ORDER BY nbrattr DESC