Powered by Smartsupp

Aluminum Die-cast Combi Hinge 40, Non-detachable, Alu Color

Aluminum Die-cast Combi Hinge 40, Non-detachable, Alu Color

Product description

Posledních 6 ks

Materiál:

  • Křídla z litého hliníku, lakované
  • Osa z nerezové oceli
Code: Aluminum Die-cast Combi Hinge 40, Non-detachable, Alu Color
Manufacturer: FATH GmbH Components
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

Poptat cenu
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 

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` = '37115' 
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` = '37115' 
AND `h`.`id_hierarchie` IN (7865,10570) 
) 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` 
;
Detail zavřít

❱