Olfaktoriker #6534
The «Olfaktoriker» («the olfactionist»): a legendary figure with the nose of a bloodhound and the palate of a Michelin-starred chef. He works in an unassuming lab, crammed with vials and test tubes and starting from seemingly unremarkable materials. containing everything from fragrant lavender notes to pungent musk essences. He’s in it for the molecules, not the money. Yet everyone seeks his expertise. And it’s a dirty business, steeped in secrets and intrigues. One wrong scent can be deadly. Who knew the world of smell could be so filled with intrigue?
Measurement: 53 ▢ 19-140 // Color: Pine
- Swiss Design
- 100% Titanium
- Micro-engraved Details
- Adjustable Temples
- Handmade Frames
- Anti-scratch coated Lenses
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` = '1284' 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
Olfaktoriker #6534
The «Olfaktoriker» («the olfactionist»): a legendary figure with the nose of a bloodhound and the palate of a Michelin-starred chef. He works in an unassuming lab, crammed with vials and test tubes and starting from seemingly unremarkable materials. containing everything from fragrant lavender notes to pungent musk essences. He’s in it for the molecules, not the money. Yet everyone seeks his expertise. And it’s a dirty business, steeped in secrets and intrigues. One wrong scent can be deadly. Who knew the world of smell could be so filled with intrigue?
Measurement: 53 ▢ 19-140 // Color: Pine
- Swiss Design
- 100% Titanium
- Micro-engraved Details
- Adjustable Temples
- Handmade Frames
- Anti-scratch coated Lenses