Voyante #6670

The Psychic is for the visionary who always has an eye for what is to come. A true seer, the lies of the world are evident to you when everyone else is looking in the wrong direction. You filter out the illusions and only get down to the truth hidden behind them. Forget the crystal ball and wear The Psychic. You'll know what's coming before it even happens.

Measurement: 48 ▢ 23-140 // Color: Green

CHF 239.00

incl. 8.1% VAT

location_on Buy in store

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

Other Variations

Voyante

Find in stores

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

Voyante #6670

Measurement: 48 ▢ 23-140 // Color: Green

CHF 239.00

incl. 8.1% VAT

location_on Buy in store

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

Acetate Sunglasses