|
|
|
|
|
|
A:SQL Error: Unknown database 'fastmag_demo'
Select Niveau1 as Rayon , Niveau2 as Famille , niveau1 as Traduction1 , Niveau2 as Traduction2 from vshopMenu V , ProduitsFiches P where V.Barcode=P.Barcode and P.VisibleWeb=1 Union all select f.Rayon, f.Famille, f.Rayon as Traduction1, f.Famille as Traduction2 from ProduitsFiches f left outer join ProduitsLangues l ON ((f.BarCode = l.BarCode) And (l.Langue = '')) where (VisibleWeb=1)
|
Femme - Chemise
SQL Error: Unknown database 'fastmag_demo'
select f.*, s.Couleur, Sum(s.Stock) as QteStock from ProduitsFiches f , stock s where f.BarCode = s.BarCode and (s.CodeMag IN ( 'OPERA' )) And (f.Rayon='FEMME') and (f.Famille='CHEMISE') and (VisibleWeb=1) group by BarCode, Couleur having QteStock > 0 order by OrdreTriVShop desc, BarCode
|
|
|
|
|
