• 

Product description

Code:	2110M
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

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` = '35511' 
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` = '35511' 
AND `h`.`id_hierarchie` IN (8776,10294,10350,10476) 
) 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` 
;

Related products

Push lockPush lock

2100M

Detail