NOTE COSMETIQUE MAROC
 Erreur SQL !
SELECT articles.Photo,articles.LibelleCourt, articles.LibelleLong, promotions.codeArticle, if(promotions.codetaille is null,'TOUTES LES TAILLES',promotions.codetaille) AS TAILLE, IF(promotions.codecouleur IS NULL,'TOUTES LES COULEURS',promotions.codecouleur) AS COULEUR,if(grillescouleurs.Code is null,'',grillescouleurs.image) AS coulPhoto ,promotions.Motif AS Descrip, DATE_FORMAT(promotions.Date1, '%d/%m/%Y') AS DateDeb, DATE_FORMAT(promotions.Date2, '%d/%m/%Y') AS DateFin, round(promotions.TauxRemise,2) AS REMISE,IF(promotions.codeCaisse is null,'Dans Tous les points de vente',concat('Au Point de vente: ',caisses.Libelle)) As caisselib FROM promotions LEFT OUTER JOIN articles ON (promotions.codeArticle = articles.Code OR (promotions.codeArticle IS NULL AND promotions.codeFamille IS NULL) OR (promotions.codeFamille = articles.codeFamille)) LEFT OUTER JOIN grillescouleurs ON (grillescouleurs.code=promotions.codeCouleur) LEFT OUTER JOIN caisses ON (caisses.code=promotions.codeCaisse) WHERE (articles.bWeb = 1) AND (Bloque=0) AND (promotions.Date1 <= Now()) AND (promotions.Date2 >= Now())
Unknown column 'caisses.Libelle' in 'field list'