• 

Product description

Code:	ZL-2201
Manufacturer:	Sugatsune Kogyo Co.
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.
Freight:	Each order of the Sugatsune Kogyo Co. assortment will be charged € 10.60 ex­cluding VAT for UPS shipping from abroad.
	U dílů o délce 1 - 1,5 m je cena dopravy 650 Kč bez DPH a u delších je 960 Kč bez DPH.

zavřít

3D modely

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

Díl – objednací číslo: Glass shelf holder | ZL-2201
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

Download

General Catalog Page

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` = '33060' 
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` = '33060' 
AND `h`.`id_hierarchie` IN (8776,10291,10361,10487) 
) 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` 
;