ARBORESCENCE =>
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 )) 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 )) GROUP BY mPrix.id_masterProduit ORDER BY mPrix.reference ASC, mPrix.reference_fournisseur ASC LIMIT 0, 40
:id_masterSurBoutik
:id_masterBoutikA
:id_masterBoutikB
:id_masterBoutikC
:id_masterTrieurEnfant null
:price_asked
:search
:order
:shop
NB PRODUIT => 1070
NB BOUTIQUE => 40
LIMIT => LIMIT 0, 40
PAGE DEMANDE => 1
Rouleau entrainement 132450
SP500B
- diameter : 43 MM
- height : 500 MM
- fast tightening vice : Non
REF : 100505
Vice for drill press support
VICE-SP
- fast tightening vice : Non
REF : 100508
ENERGYSTAND-840
- height : 840 MM
- fast tightening vice : Non
- size of the main table : 320x230 MM
REF : 100511
ENERGYROLL-320
- with wheels : Oui
- folding system : Oui
- height : 670-1117 MM
REF : 100514
ENERGYSTAND189R
- with wheels : Non
- folding system : Oui
- height : 880 MM
REF : 100517
ST125B
- diameter : 115/125 MM
- height : 225 MM
- fast tightening vice : Oui
REF : 100522
- diameter : 180/230 MM
- height : 370 MM
- fast tightening vice : Oui
REF : 100532
Etau d'Ă©tabli pivotant 100 mm
EBT150
- material : MĂ©tal SG
- opening : 150 MM
- length : 475 MM
REF : 100710
Mors doux magnétiques 150 mm recoupables 125/100
EBT200
- material : MĂ©tal SG
- opening : 200 MM
- length : 525 MM
REF : 100715
- material : MĂ©tal GS
- length : 340 MM
- width : 70 MM
REF : 100810
Self cleaning dry vacuum cleaner
ENERGYCLEAN-20LA
- : Oui
- Power in CV : 1200 W
- filtration system : Filtre plissé plat
REF : 100901
ENERGYGRIND-100
- Power in CV : 53 W
- Use : Coutellerie
- diameter : 100 MM
REF : 105007
ENERGYGRIND-200
- Power in CV : 90 W
- Use : Coutellerie
- diameter : 200 MM
REF : 105008
ENERGYGRIND-200
- Power in CV : 90 W
- Use : Coutellerie
- diameter : 200 MM
REF : 105009
Box of 15 HSS screwbits LG25mm - intensive range
- Use : Intensif
- packaging : x 15 pcs
REF : 130076
ENERGYSAW-254B3
- Power in CV : 1800 W
- diameter : 254 MM
- maximum cutting capacity : 73 MM
REF : 132003
165 mm table saw with integrated vacuum cleaner
ENERGYSAW-165ASP
- Power in CV : 1200 W
- diameter : 165 MM
- maximum cutting capacity : 40 MM
REF : 132006
ENERGYSAW-185ASP
- Power in CV : 2200 W
- diameter : 185 MM
- maximum cutting capacity : 42 MM
REF : 132007
Scie de table et d'Ă©tabli ASP
ENERGYSAW-216ASP
- Power in CV : 2000 W
- diameter : 216 MM
- maximum cutting capacity : 60 MM
REF : 132008
ENERGYSAW-210SL2
- table saw function : Non
- cutting wood/metal : Non
- radial function : Non
REF : 132031
ENERGYSAW-254SB
- Power in CV : 1600 W
- diameter : 254 MM
- maximum cutting capacity : 78 MM
REF : 132033
ENERGYSAW-305STB
- Power in CV : 1600 W
- diameter : 305 MM
- maximum cutting capacity : 90 MM
REF : 132055
ENERGYBAND-80LD
- Power in CV : 250 W
- wheel diameter : 200 MM
- maximum cutting capacity : 80 MM
REF : 132061
Scie à ruban d'établi bois & métal
ENERGYBAND-80WM
- Power in CV : 710 W
- wheel diameter : 200 MM
- maximum cutting capacity : 80 MM
REF : 132063
ENERGYBAND-120LDB2
- Power in CV : 420 W
- wheel diameter : 250 MM
- maximum cutting capacity : 120 MM
REF : 132067
Band saw with built-in dust collection
ENERGYBAND-160ASP
- Power in CV : 750 W
- wheel diameter : 305 MM
- maximum cutting capacity : 160 MM
REF : 132069
ENERGYSCROLL-405VE
REF : 132159
Bench sander with rotative base
ENERGYSAND-127
- Power in CV : 250 W
- abrasive diameter : 127 MM
- electronic variable speed : Non
REF : 132338
ENERGYSAND-150
- Power in CV : 450 W
- abrasive diameter : 150 MM
- electronic variable speed : Non
REF : 132342
ENERGYSAND-200ASP
REF : 132345
ENERGYPLANE-204ASP
- iron length : 204 MM
- Power in CV : 1500 W
- maximum cutting depth : 6-210 MM
REF : 132450
Raboteuse-dégauchisseuse
ENERGYPLANE-305ASP
- iron length : 308 MM
- Power in CV : 1800 W
- iron thickness : 2,5 MM
REF : 132455
ENERGYDRILL 13B
- Power in CV : 350 W
- chuck tightening capacity : 13 MM
- tension : 230 V
REF : 132613
ENERGYDRILL 16LBE
- Power in CV : 550 W
- type of setting : CĂ´ne morse CM2
- chuck tightening capacity : 16 MM
REF : 132623
ENERGYDRILL 20FLB
- Power in CV : 750 W
- type of setting : CĂ´ne morse CM2
- chuck tightening capacity : 16 MM
REF : 132643
ENERGYGRIND-150P
- Power in CV : 350 W
- Use : Affutage
- diameter : 150 MM
REF : 133053