SELECT rubrique.*, rubrique_i18n.* FROM rubrique LEFT JOIN rubrique_i18n ON rubrique_i18n.rubrique_id=rubrique.rubrique_id WHERE rubrique_visible = 'oui' AND rubrique_parent_id= AND langue='fr' AND rubrique.rubrique_id NOT IN (702) GROUP BY rubrique.rubrique_id ORDER BY rubrique_nom ASC You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND langue='fr' AND rubrique.rubrique_id NOT IN (702) GROUP BY rubrique.rubri' at line 7