Flusssieder #5972-SUN

As perplexing as the name may appear, the actual profession is quite cool. In the old days, a Flusssieder was used to make glass. And where would we be without glass? Probably in a dark hole. So, thank you, dear Flusssieder, for making our high-quality panorama peepholes so beautifully transparent. That fits perfectly, because without glass, there would be none of our gorgeous eyewear for you, so in that sense, it's a system-relevant profession, at least to us.

Mesure: 52 ▢ 20-142 // Coleur: Tamac

CHF 198.00

incl. 8.1% TVA

location_on Acheter en boutique

chevron_right Design suisse
chevron_right Protection UV-400
chevron_right Charnières à ressort OBE allemandes
chevron_right Verres CR39 avec traitement antireflet
chevron_right Fait à la main
chevron_right Revêtement résistant aux rayures

Autres variations

#5971-SUN

Trouver dans les magasins

Autres tailles

Tourmanager

SELECT `product`.`id` `product_id`, `product`.`product_color_id`, `product`.`product_color_id_2`, `product`.`product_measurement`, `product_group`.`id`, `product_group`.`name` `name_de`, `product_group`.`name_en` `name_en`, `product_group`.`name_fr` `name_fr`, `product_group`.`name_it` `name_it`, `product_group`.`promotion` `group_promotion`, `product_group`.`promotion_euro` `group_promotion_euro`, `product_group`.`measurement`, `product_group`.`product_category_id`, `product_category`.`name_de` `category_de`, `product_category`.`name_en` `category_en`, `product_category`.`name_fr` `category_fr`, `product_category`.`name_it` `category_it`, `product_gender`.`name_de` `gender_de`, `product_gender`.`name_en` `gender_en`, `product_gender`.`name_fr` `gender_fr`, `product_gender`.`name_it` `gender_it`, `reorder_items`.`delivery_date` `next_delivery`, `reorder_items`.`euro_delivery_date` `euro_next_delivery`
FROM (`product`, `product_group`, `product_category`, `product_gender`, `product_fits`)
LEFT JOIN `reorder_items` ON `product`.`id` = `reorder_items`.`product_id`
WHERE `product_group`.`id` = `product`.`product_group_id`
AND `product_group`.`id` = `product_fits`.`fit_group_id`
AND `product`.`online` = 1
AND `product`.`invisible` = 0
AND `product_group`.`online` = 1
AND `product_group`.`invisible` = 0
AND `product_fits`.`product_group_id` = '1139'
AND   (
`product`.`stock` > 0
OR    (
`product`.`stock` = 0
AND `product`.`sold_out` = 1
  )
OR    (
`product`.`stock` <= 0
AND `reorder_items`.`delivery_date` != '0000-00-00'
  )
 )
GROUP BY `product`.`id`
ORDER BY `product`.`is_thumb` DESC