Trouver un terrain et une maison neuve à vendre

SELECT  article.*,category.category_name,category.category_parent_id,marque.marque_nom,userfd.userfd_nom, userfd.userfd_prenom, userfd.userfd_pseudo, userfd.userfd_email, userfd.userfd_societe ,ville.*  FROM article JOIN category ON (article.category_id=category.category_id)  LEFT JOIN marque ON (article.marque_id=marque.marque_id)  LEFT JOIN userfd ON (article.userfd_id=userfd.userfd_id)  LEFT JOIN ville ON (article.ville_id=ville.ville_id)   WHERE 1 AND category.category_activate = '1' AND article.article_activate = 1 AND article.category_id IN (766) AND article.article_start_date <= NOW() AND ( DATE(article.article_end_date) >= NOW() OR DATE(article.article_end_date)='0000-00-00')  ORDER BY article.article_order asc  LIMIT 0,1501