Product description

Code:	4100
Manufacturer:	PINET Industrie
Prices:	are listed at the bottom of the page in the product variant table, or upon request via the form below.
Delivery date:	normally about 7 to 10 days from ordering, depending on quantity and current stock. We verify and confirm specific delivery dates by email, individually according to the order. In case of unavailability of goods, the order can be canceled. More information.

zavřít

3D modely

JMÉNO:
E-MAIL:
WWW:
TEXT:

Díl – objednací číslo: Glass door hinge in brushed stainless steel | 4100
Formát 3D: STEP (*.step) 3D PDF (*.pdf) ACIS (*.sat) Acrobat (*.pdf) ANVIL (*.igs) Ashlar-Vellum Argon (*.sat) Ashlar-Vellum Cobalt (*.sat) Ashlar-Vellum Xenon (*.sat) Auto CAD 3D (*.sat) CADKey 3D (*.sat) CATIA V5 Part/Assembly (*.catproduct) Edrawing Part/Assembly (*.eprt) IFC 2×3 (*.ifc) IGES (*.igs) lnventor (*.sat) Iron CAD (*.sat) JPEG Files (*.jpg) Mechanical Desktop (*.sat) Parasolid Binary (*.x_b) Parasolid Text (*.x_t) Pro/E Part/Assembly (*.prt) Revit (*.sat) SDRC I-DEAS (*.step) SolidEdge (*.x_t) SOLIDWORKS Part/Assembly (*.sldprt) STL (*.stl) TIFF (*.tif) Unigraphics (*.x_t) VDA (*.vda) VRML (*.wrl)

Specifikujte prosím do pole níže konkrétní objednací kód, ke kterému žádáte zaslat 3D model nebo si jej stáhněte z tabulky dostupných variant v dolní části stránky produktu a to tlačítkem 3D nebo Stáhnout.

Objednací kód: Firma: Jméno: Příjmení: E-mail: Telefon: Text:

Dear customers, we inform you in accordance with EU regulation that the information provided is not used or stored by us in any way and is only used to process this request. More information HERE

zavřít

Poptat cenu

JMÉNO:
E-MAIL:
WWW:
TEXT:

Firma: Jméno: Příjmení: E-mail: Telefon: Kód: Text:

Dear customers, we inform you in accordance with EU regulation that the information provided is not used or stored by us in any way and is only used to process this request. More information HERE

Customers from France, the UK, Italy, Spain, Germany, Austria, Switzerland, the Netherlands and Belgium — please contact PINET directly for support.

Download

Catalogue sheet PINET Glass door hinge in brushed stainless steel

SELECT * FROM (
SELECT `tpt_index`, `tph_hodnota_min`, `tph_hodnota_max`, `tph_hodnota_bool`, IFNULL(`tph_hodnota_text_3jaz`, `tph_hodnota_text`) AS `tph_hodnota_text`, `tph_hodnota_select`, `tph_hodnota_vyber`, 
IFNULL(`tp_nazev_3jaz`, `tp_nazev`) AS `tp_nazev`, `tp_prefix`, `tp_jednotka`, `tp_prepocet_jednotek`, `tp_jednotka_bool`, `tp_vodici_znak`, `tp_bool_jen_true`, 
`id_technicke_parametry_typy`, `tp_poradi`, `id_technicke_parametry`, `tph_poradi` 
FROM `technicke_parametry_hodnoty` AS `tph` 
INNER JOIN `technicke_parametry` AS `tp` ON `tp`.`id_technicke_parametry` = `tph`.`technicke_parametry_id_technicke_parametry` AND `tp_neaktivni` = '0' 
INNER JOIN `technicke_parametry_typy` AS `tpt` ON `tpt`.`id_technicke_parametry_typy` = `tp`.`technicke_parametry_typy_id_technicke_parametry_typy` 
AND `tpt_neaktivni` = '0' 
WHERE `tph_neaktivni` = '0' 
AND `tph`.`produkty_id_produkt` = '39343' 
UNION DISTINCT 
SELECT `tpt_index`, NULL AS `tph_hodnota_min`, NULL AS `tph_hodnota_max`, NULL AS `tph_hodnota_bool`, NULL AS `tph_hodnota_text`, NULL AS `tph_hodnota_select`, NULL AS `tph_hodnota_vyber`, 
IFNULL(`tp_nazev_3jaz`, `tp_nazev`) AS `tp_nazev`, `tp_prefix`, `tp_jednotka`, `tp_prepocet_jednotek`, `tp_jednotka_bool`, `tp_vodici_znak`, `tp_bool_jen_true`, 
`id_technicke_parametry_typy`, `tp_poradi`, `id_technicke_parametry`, `tph_poradi` 
FROM `technicke_parametry` AS `tp` 
INNER JOIN `technicke_parametry_hodnoty` AS `tph` ON `tph`.`technicke_parametry_id_technicke_parametry` = `tp`.`id_technicke_parametry` 
LEFT JOIN `technicke_parametry_typy` AS `tpt` ON `tpt`.`id_technicke_parametry_typy` = `tp`.`technicke_parametry_typy_id_technicke_parametry_typy` 
LEFT JOIN `technicke_parametry_skupiny` AS `tps` ON FIND_IN_SET(`tp`.`id_technicke_parametry`,`tps`.`stp_id_technicke_parametry`) 
LEFT JOIN `hierarchie` AS `h` ON FIND_IN_SET(`tps`.`id_technicke_parametry_skupiny`,`h`.`hi_id_skupiny_technickych_parametru`) 
LEFT JOIN `produkty_hierarchie` AS `ph` ON `ph`.`hierarchie_id_hierarchie` = `h`.`id_hierarchie` 
AND `tpt_neaktivni` = '0' 
WHERE `tp_neaktivni` = '0' 
AND `tph`.`produkty_id_produkt` = '39343' 
AND `h`.`id_hierarchie` IN (7865,10571) 
) AS `v` 
WHERE (
	((`tpt_index` = 'VAL' OR `tpt_index` = 'RAN') AND `tph_hodnota_min` IS NOT NULL) 
	OR (`tpt_index` = 'BLN' AND `tph_hodnota_bool` IS NOT NULL) 
	OR (`tpt_index` = 'TXT' AND `tph_hodnota_text` IS NOT NULL) 
	OR (`tpt_index` = 'LIS' AND `tph_hodnota_select` IS NOT NULL) 
	OR (`tpt_index` = 'ENU' OR `tpt_index` = 'ENV' OR `tpt_index` = 'ENT' AND `tph_hodnota_vyber` IS NOT NULL) 
)
GROUP BY  `v`.`id_technicke_parametry` 
ORDER BY `tph_poradi` IS NULL, `tph_poradi`, `tp_poradi` IS NULL, `tp_poradi`, `tp_nazev`, `id_technicke_parametry` 
;