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 1500
:id_masterBoutikB 1521
:id_masterBoutikC
:id_masterTrieurEnfant null
:price_asked
:search
:order
:shop
NB PRODUIT => 25
NB BOUTIQUE => 25
LIMIT => LIMIT 0, 40
PAGE DEMANDE => 1
18V Cordless drill with 2 battery packs of 2,0Ah
ENERGYDRILL-18V20
- battery amperage : 2 AH
- chuck tightening capacity : 13 MM
- type of battery : Lithium-Ion
REF : 250312
18V Impact cordless drill with 2 battery packs of 2,0Ah
ENERGYDRILL-18VP20
- battery amperage : 2 AH
- chuck tightening capacity : 13 MM
- type of battery : Lithium-Ion
REF : 250314
18V Impact cordless drill with 2 battery packs of 2,0Ah
ENERGYDRILL-18VP20N
- battery amperage : 2.0 AH
- diameter : 13 MM
- type of battery : Li-ion
REF : 250315
18V Impact cordless drill with 2 battery packs of 4,0Ah
ENERGYDRILL-18VP40N
- battery amperage : 4 AH
- type of battery : Lithium-Ion
- electronic variable speed : Non
REF : 250317
18V Brushless impact cordless drill with battery packs 2,0 and 5,0Ah
ENERGYDRILL-18VPBL2
- battery amperage : 2.0 + 5.0 AH
- type of battery : Li-ion
- electronic variable speed : Oui
REF : 250324
Perceuse Ă percussion BRUSHLESS 18V 2,0 et 2,0Ah
ENERGYDRILL-18VPBL3
- battery amperage : 2.0 AH
- type of battery : Li-ion
- electronic variable speed : Oui
REF : 250325
Perceuse Ă percussion BRUSHLESS 18V 4,0 et 4,0Ah
ENERGYDRILL-18VPBL4
- battery amperage : 4.0 AH
- type of battery : Li-ion
- electronic variable speed : Oui
REF : 250326
Visseuse Ă choc Brushless chargeur bat 5.0Ah
ENERGYDRIVER-18VBL
- battery amperage : 5.0 AH
- type of battery : Li-ion
- electronic variable speed : Oui
REF : 650308
Clé à choc Brushless chargeur + bat 5.0Ah
ENERGYWRENCH-18VBL
- battery amperage : 5.0 AH
- type of battery : Li-ion
- electronic variable speed : Oui
REF : 650309
Bundle 18V Brushless rotary hammer + battery 5,0Ah + charger
ENERGYPUNCH-18VBL
- battery amperage : 5.0 AH
- type of battery : Li-ion
- electronic variable speed : Oui
REF : 650331
Marteau perforateur BL 18V chargeur 2 bat 5,0 Ah
ENERGYPUNCH-18VBL
- battery amperage : 5.0 + 5.0 AH
- type of battery : Li-ion
- electronic variable speed : Oui
REF : 650332
Perforateur 5Ah + chargeur & mallette 21 pcs
- battery amperage : 5.0 AH
- type of battery : Li-ion
- electronic variable speed : Oui
REF : 650333
Bundle 18V jig saw + battery 2,0Ah + charger
ENERGYSAW-J18V
- battery amperage : 2.0 AH
- maximum cutting capacity : 100 MM
- type of battery : Li-ion
REF : 650341
Bundle 18V Brushless 165 mm circular saw + battery 2,0Ah + charger
ENERGYSAW-C18VBL
- diameter : 165 MM
- battery amperage : 2.0 AH
- type of battery : Li-ion
REF : 650351
Scie circulaire 165mm 18V + chargeur + bat 5,0 Ah
ENERGYSAW-C18VBL
- diameter : 165 MM
- battery amperage : 5.0 AH
- type of battery : Li-ion
REF : 650352
Bundle 18V 125 mm orbital sander + battery 2,0Ah + charger
ENERGYSAND-18V
- battery amperage : 2.0 AH
- diameter : 125 MM
- type of battery : Li-ion
REF : 650361
Bundle 18V Brushless 125 mm angle grinder + battery 2,0Ah + charger
ENERGYGRIND-18VBL
- battery amperage : 2.0 AH
- diameter : 125 MM
- type of battery : Li-ion
REF : 650371
Meuleuse d'angle 125mm 18V + chargeur + bat 5,0 Ah
ENERGYGRIND-18VBL
- battery amperage : 5 AH
- diameter : 125 MM
- electronic variable speed : Oui
REF : 650372
Bundle 18V Brushless renovator + battery 5,0Ah + charger
ENERGYBRUSH-18VBL
- battery amperage : 5.0 AH
- diameter : 80 MM
- type of battery : Li-ion
REF : 650381
Rénovateur 2x5Ah + chargeur
- battery amperage : 5.0 AH
- diameter : 80 MM
- type of battery : Li-ion
REF : 650382
Bundle 18V multitools + battery 2,0Ah + charger
ENERGYTOOL-18V
- battery amperage : 2.0 AH
- type of battery : Li-ion
- electronic variable speed : Oui
REF : 650391
Mélangeur 18V + chargeur + bat 5,0 Ah
ENERGYMIX-18VBL
- battery amperage : 5 AH
- diameter : 100 MM
- type of battery : Li-ion
REF : 650431
Lustreuse polisseuse 18V + chargeur + bat 5,0 Ah
ENERGYSHINE-18VBL
- battery amperage : 5 AH
- diameter : 150 MM
- type of battery : Li-ion
REF : 650435
Brushless cordless drywall sander
ENERGYSAND-18VBL-ASP
- battery amperage : 5.0 AH
- diameter : 150 MM
- type of battery : Li-ion
REF : 650440
Décapeur à air chaud 18V + chargeur + bat 5,0 Ah
ENERGYHEAT-18V
- battery amperage : 5.0 AH
- type of battery : Li-ion
- electronic variable speed : Non
REF : 650450