Polarised Lenses

Zeidler #5951-SUN

Admittedly, somehow we just can't get enough of these bee professions. But bees are indispensable to our planet, and the Zeidler is an essential part of the machinery to save our planet. This profession, once thought forgotten, has recently found a new audience among beekeepers. They differ only in one point: the Zeidler keeps his bees in tree hollows, while the beekeeper holds them on the ground. So Gen X, write it down: the beekeeper of the future wants to become a Zeidler.

Misurazione: 50 ▢ 21-140 // Colore: Crystal

CHF 259.00

IVA del 8.1% inclusa

location_on Acquista in negozio

chevron_right Swiss Design
chevron_right UV 400 Protection
chevron_right German OBE Hinges
chevron_right CR39 Lenses with anti-reflective Coating
chevron_right Handmade Frames
chevron_right Anti-scratch coated Lenses
chevron_right Polarised lenses

Negozi

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` = '1135'
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