Bon de commande fidélité

Bon de commande test avec gestion de la fidélité

non

nb Art1

SELECT 
fr_articles.numart, 
fr_articles.art_titre, 
fr_articles.art_cond, 
fr_articles.art_prix, 
fr_articles.art_poids, 
fr_articles.notva, 
fr_articles.art_codegesco,
fr_articles.art_ordre,
fr_articles.art_photo1,
clientstarifs.nocat 	AS tnocat, 
clientstarifs.noart 	AS tnoart, 

clientstarifs.tarif,

fr_catart.catnom,
fr_catart.descrip,
fr_catart.ordre 		AS catordre, 
fr_articles.art_phrase, 
fr_articles.art_vol,
fr_articles.ptsFidelite,
fr_articles.stock ,
fr_articles.art_rupture ,
fr_articles.art_dateFinRupture,

(SELECT tarif FROM clientstarifs 
	WHERE noclient=1 
		AND noart = fr_articles.numart ) 	AS prixPublic,

(SELECT mention FROM fr_catclitarifs 
	WHERE nocat=clientstarifs.nocat 
		AND noart = fr_articles.numart ) 	AS mention
		
FROM `clientstarifs` 
INNER JOIN fr_articles 	ON clientstarifs.noart = fr_articles.numart 
INNER JOIN fr_catart 	ON fr_catart.id = fr_articles.nocat 
WHERE clientstarifs.nocat 		= '1' 
AND clientstarifs.noclient 		= '1'
AND clientstarifs.tarif > 0
AND fr_articles.art_vente = 1 
AND fr_articles.art_rupture <> 2  ORDER BY catordre, art_ordre ASC