ARBORESCENCE => BOUTIKB
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 AND colProd.id_masterBoutikB = :id_masterBoutikB 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 AND colProd.id_masterBoutikB = :id_masterBoutikB GROUP BY mPrix.id_masterProduit ORDER BY mPrix.reference ASC, mPrix.reference_fournisseur ASC LIMIT 0, 40
:id_masterSurBoutik
:id_masterBoutikA 1600
:id_masterBoutikB 1621
:id_masterBoutikC
:id_masterTrieurEnfant null
:price_asked
:search
:order
:shop
NB PRODUIT => 16
NB BOUTIQUE => 16
LIMIT => LIMIT 0, 40
PAGE DEMANDE => 1
Box of 15 HSS screwbits LG25mm - intensive range
- Use : Intensif
- packaging : x 15 pcs
REF : 130076
Drills/screw bits case 32 pieces Intensive use
- Use : Intensif
- packaging : x 32 pcs
REF : 190186
Metal/wood 8 pieces drill case Intensive use
- Use : Intensif
- packaging : x 8 pcs
REF : 190426
Metal/concrete/screw bits 37 pieces case Intensive use
- Use : Intensif
- packaging : x 37 pcs
REF : 190596
SDS+ 10 pieces case Intensive use
- Use : Intensif
- packaging : x 10 pcs
REF : 190626
Drill/screw bits case 108 pieces Current use
- Use : Courant
- packaging : x 108 pcs
REF : 190646
HSS metal drills 9 pieces case Intensive use
- Use : Intensif
- packaging : x 9 pcs
REF : 911646
HSS metal drills 19 pieces case Intensive use
- Use : Intensif
- packaging : x 19 pcs
REF : 911656
Concrete drills 5 pieces case Intensive use
- Use : Intensif
- packaging : x 5 pcs
REF : 915566
Concrete drills 8 pieces case intensive use
- Use : Intensif
- packaging : x 8 pcs
REF : 915576
Wood brad point drills 6 pieces case Intensive use
- Use : Intensif
- packaging : x 6 pcs
REF : 917006
Wood brad point drills 10 pieces case Intensive use
- Use : Intensif
- packaging : x 10 pcs
REF : 917016
Screw bits 25 mm 31 pieces Titanium Pro case Intensive use
- Use : Intensif
- packaging : x 31 pcs
REF : 930066
Mini CRV 25 mm screw bits 16 pieces with holder Current use
- Use : Courant
- packaging : x 16 pcs
REF : 930136
Mini S2 25 mm screw bits 16 pieces with holder Intensive use
- Use : Intensif
- packaging : x 16 pcs
REF : 930156
HSS bi metal 6 pieces hole saws case + center drills
- Use : Courant
- packaging : x 8 pcs
REF : 982216
