SELECT *
FROM `properties`
WHERE `ongoing_project` = 2
AND (
`vocation_id` = 2
AND `statut_id` = 2
OR `statut_id` = 5
OR `vocation_id` = 1
AND `statut_id` = 2
)
AND `published` = 1
ORDER BY `id` DESC
LIMIT 9 Vente immobilier neuf et ancien Tunisie | Darcom Tunisia
Tunis , Ain Zaghouan , Ain Zaghouan Nord 