SELECT *
FROM `properties`
WHERE (
`gouvernorat_id` = '137'
)
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 les Biens en Mahdia| Darcom Tunisia
Mahdia , Mahdia 