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 prixSecondevie prixSec ON mPrix.id_masterPrix = prixSec.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 ( prixSec.seconde_vie_actif IS NULL || prixSec.seconde_vie_actif = 0 ) AND colProd.id_masterBoutikA = :id_masterBoutikA GROUP BY mPrix.id_masterPrix 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 prixSecondevie prixSec ON mPrix.id_masterPrix = prixSec.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 ( prixSec.seconde_vie_actif IS NULL || prixSec.seconde_vie_actif = 0 ) AND colProd.id_masterBoutikA = :id_masterBoutikA GROUP BY mPrix.id_masterPrix ORDER BY mPrix.reference ASC, mPrix.reference_fournisseur ASC LIMIT 0, 40
id_masterSurBoutik
id_masterBoutikA 1600
id_masterBoutikB
id_masterBoutikC
id_masterTrieurEnfant ""
price_asked
search
order
int(0)
shop
int(0)
secondevie
NB PRODUIT => 24
NB BOUTIQUE => 24
LIMIT => LIMIT 0, 40
PAGE DEMANDE => 1
Box of 15 HSS screwbits LG25mm - intensive range
Drywall special case 29 pcs Intensive use
Drills/screw bits case 32 pieces Intensive use
Metal/wood 8 pieces drill case Intensive use
Metal/concrete/screw bits 37 pieces case Intensive use
SDS+ 10 pieces case Intensive use
Drill/screw bits case 108 pieces Current use
60 pcs taps and dies case Peugeot
Mallette du carreleur en perçage 16 pièces
Mallette du plombier perçage et coupe 12 pcs
Mallette Marteau perforateur SDS+ 21 pièces
Coffret vissage à chocs - 10 noix de serrage
Ecrou serrage universel M14
Tap wrench 1/12 mm extractor
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 S2 25 mm screw bits 16 pieces with holder Intensive use
- Use : Intensif
- packaging : x 16 pcs
REF : 930156
Taps 13 pieces case + holder Current use
- Use : Courant
- packaging : x 13 pcs
REF : 982006
HSS bi metal 6 pieces hole saws case + center drills
- Use : Courant
- packaging : x 8 pcs
REF : 982216
