SELECT *
FROM `properties`
WHERE (
`gouvernorat_id` = '141'
)
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 nabeul| Darcom Tunisia
Nabeul , Hammamet , mrezga 
