'Select a.* from accessoire a join entry e on a.nom=e.idTranslation left join accessoire_trim at on a.idAccessoire=at.idAccessoire left join trim tr on at.idTrim=tr.idTrim and tr.idStatus<>:STATUS_INACTIVE1 left join boitier_accessoire ba on ba.idAccessoire=a.idAccessoire left join boitier b on b.idBoitier=ba.idBoitier and b.idStatus<>:STATUS_INACTIVE2 where lower(e.text)=lower(:nomAccessoire) and a.idStatus<>:STATUS_INACTIVE3 limit 1;'

ERROR : [1064]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 SEO.objectType='accessoire'' at line 2

Query : Select SEO.*, og.title as OG_title from SEO join openGraph og on SEO.idObject=og.idObject and SEO.objectType=og.objectType where SEO.idObject= and SEO.objectType='accessoire'

Contraste - Accessories -