ACCESSORI STANDARD PER SERBATOI
STAFFE A COLLARE 8"
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` = '690' AND `IdGruppo` = '53' AND `Valore` != '' LIMIT 1
Codice |
Altezza |
Peso |
ST08-H134 | 134mm |
1.240kg |
ST08-H210 | 210mm |
2.015kg |
ST08-H230 | 230mm |
2.220kg |
ST08-H270 | 270mm |
2.630kg |
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '690' AND `IdGruppo` = '48' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '690' AND `IdGruppo` = '29' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '690' AND `IdGruppo` = '31' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '690' AND `IdGruppo` = '1' AND `Valore` != '' LIMIT 1
No. |
Descrizione |
Materiale |
1 |
Collar 8" |
CS/ SS |
2 |
Nut M10 |
CS/ SS |
3 |
Washer |
CS/ SS |
4 |
Brackets 8" |
CS/ SS |
|
|
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '690' AND `IdGruppo` = '19' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '690' AND `IdGruppo` = '25' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '690' AND `IdGruppo` = '12' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '690' AND `IdGruppo` = '49' AND `Valore` != '' LIMIT 1
SELECT COUNT(*) AS `count` FROM `valori` WHERE (`Cancellato` IS NULL OR `Cancellato` = '0') AND `IdParent` = '690' AND `IdGruppo` = '50' AND `Valore` != '' LIMIT 1