ACCESSORI STANDARD PER SERBATOI
STAFFE A COLLARE 6"
Le nostre Staffe piu diffuse per un fissaggio del Serbatoio versatile, pratico ed efficiente
CERTIFICAZIONI PRODOTTO
STANDARD
OPZIONALI
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '53' AND `Valore` != '' LIMIT 1
Codice |
Altezza |
Peso |
ST06-H109 | 109mm |
0.825kg |
ST06-H170 | 170mm |
1.225kg |
ST06-H200 | 200mm |
1.450kg |
ST06-H220 | 220mm |
1.585kg |
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '48' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '29' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '31' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '1' AND `Valore` != '' LIMIT 1
No. |
Descrizione |
Materiale |
1 |
Collar 6" |
CS/ SS |
2 |
Nut M10 |
CS/ SS |
3 |
Washer |
CS/ SS |
4 |
Brackets 6" |
CS/ SS |
|
|
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '19' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '25' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '12' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '49' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '716' AND `IdGruppo` = '50' AND `Valore` != '' LIMIT 1