Invalid SQL : SELECT annonces.IdAnnonce as CodeAnnonce,
annonces.maj as DateAnnonce,
lcase(annonces.Titre) as Titre ,
rpad(annonces.description,45,' ') as Description,
annonces.photo1m as Photo,
annonces.prix as Prix,
annonces.etat as Etat,
moto_type.libelle as Type,
typepieces.Libelle as Categorie
FROM annonces
LEFT JOIN clients on annonces.IdClient = clients.IdClient
left join typepieces on annonces.IdTypePieces = typepieces.IdTypePieces
LEFT JOIN moto_type on annonces.IdType = moto_type.IdType
WHERE annonces.IdClient=5 and annonces.Piece=1 and annonces.enligne=1 and annonces.etat < 3 ORDER by Departement ASC, CodeAnnonce DESC
Unknown column 'Departement' in 'order clause'
1054