ARBORESCENCE => BOUTIKA
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS mPrix.* ,
CASE WHEN (( PHT_forcing < PHT_Promo OR PHT_Promo = 0 ) AND ( PHT_forcing < PHT OR PHT = 0 ) AND (PHT_forcing > 0)) THEN PHT_forcing
WHEN PHT_promo < PHT_forcing AND PHT_promo < PHT AND PHT_promo > 0 THEN PHT_promo
ELSE PHT END AS FinalPrice
FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN prixExceptions prixExc ON mPrix.id_masterPrix = prixExc.id_masterPrix LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit
WHERE ( ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) OR ( mPrix.support = 1 )) AND colProd.id_masterBoutikA = :id_masterBoutikA GROUP BY mPrix.id_masterProduit ORDER BY mPrix.reference ASC, mPrix.reference_fournisseur ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS mPrix.* ,
CASE WHEN (( PHT_forcing < PHT_Promo OR PHT_Promo = 0 ) AND ( PHT_forcing < PHT OR PHT = 0 ) AND (PHT_forcing > 0)) THEN PHT_forcing
WHEN PHT_promo < PHT_forcing AND PHT_promo < PHT AND PHT_promo > 0 THEN PHT_promo
ELSE PHT END AS FinalPrice
FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN prixExceptions prixExc ON mPrix.id_masterPrix = prixExc.id_masterPrix LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit
WHERE ( ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) OR ( mPrix.support = 1 )) AND colProd.id_masterBoutikA = :id_masterBoutikA GROUP BY mPrix.id_masterProduit ORDER BY mPrix.reference ASC, mPrix.reference_fournisseur ASC LIMIT 0, 40
:id_masterSurBoutik
:id_masterBoutikA 1700
:id_masterBoutikB
:id_masterBoutikC
:id_masterTrieurEnfant null
:price_asked
:search
:order
:shop
NB PRODUIT => 9
NB BOUTIQUE => 9
LIMIT => LIMIT 0, 40
PAGE DEMANDE => 1
ENERGYBRUSH-1500
- Power in CV : 1500 W
- abrasive diameter : 120 MM
- electronic variable speed : Oui
REF : 150610
Rénovateur + 2 brosses à lamelles A40
- Power in CV : 1500 W
- abrasive diameter : 120 MM
- electronic variable speed : Oui
REF : 650610
Rénovateur + Caisse à outils 27L
- Power in CV : 1500 W
- abrasive diameter : 120 MM
- electronic variable speed : Oui
REF : 650612
STEEL BRASS COATED WIRE 0,3MM 120*100MM FOR 150610
- work width : 100 MM
- diameter : 120 MM
REF : 800301
NYLON WIRE ABRASIVES COATED 120*100MM FOR 150610
- work width : 100 MM
- diameter : 120 MM
REF : 800302
2* ABRASIVE FLAP WHEELS GRIT40 120*100MM FOR 150610
- work width : 100 MM
- diameter : 120 MM
REF : 800303
2 *ABRASIVE FLAP WHEELS GRIT80 120*100MM FOR 150610
2* ABRASIVE PAPER WHEEL GRIT40 120*100MM FOR 150610
2* ABRASIVE PAPER WHEEL GRIT80 120*100MM FOR 150610
