Zoologe #6589
The Zoologist is for those who understand the laws of the jungle - that survival of the fittest really means survival of the smartest. Every time you look through these glasses, you gaze over the ecosystems of the world, from the streets of the big city to the deepest forests.
These lenses sharpen your eye for the natural instincts that the rest of humanity has forgotten. Tough, tested and ready for anything, you don't wear them to observe - you wear them as part of your basic survival gear. Because you’re the true king of the urban jungle.
Measurement: 59 ▢ 18-152 // Color: Blue
- Swiss Design
- Premium natural acetate
- Carefully crafted and polished by hand
- OBE hinges Made in Germany
- Adjustable temple ends
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` = '1327' 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
Zoologe #6589
The Zoologist is for those who understand the laws of the jungle - that survival of the fittest really means survival of the smartest. Every time you look through these glasses, you gaze over the ecosystems of the world, from the streets of the big city to the deepest forests.
These lenses sharpen your eye for the natural instincts that the rest of humanity has forgotten. Tough, tested and ready for anything, you don't wear them to observe - you wear them as part of your basic survival gear. Because you’re the true king of the urban jungle.
Measurement: 59 ▢ 18-152 // Color: Blue
- Swiss Design
- Premium natural acetate
- Carefully crafted and polished by hand
- OBE hinges Made in Germany
- Adjustable temple ends