Les nouveautés

SELECT `e`.*, `at_deal_start_date`.`value` AS `deal_start_date`, `at_deal_end_date`.`value` AS `deal_end_date`, `at_socko_date_ok`.`value` AS `socko_date_ok`, `at_news_from_date`.`value` AS `news_from_date`, `at_stock_status`.`stock_status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_datetime` AS `at_deal_start_date` ON (`at_deal_start_date`.`entity_id` = `e`.`entity_id`) AND (`at_deal_start_date`.`attribute_id` = '145') AND (`at_deal_start_date`.`store_id` = 0) INNER JOIN `catalog_product_entity_datetime` AS `at_deal_end_date` ON (`at_deal_end_date`.`entity_id` = `e`.`entity_id`) AND (`at_deal_end_date`.`attribute_id` = '146') AND (`at_deal_end_date`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `at_socko_date_ok` ON (`at_socko_date_ok`.`entity_id` = `e`.`entity_id`) AND (`at_socko_date_ok`.`attribute_id` = '642') AND (`at_socko_date_ok`.`store_id` = 0) LEFT JOIN `catalog_product_entity_datetime` AS `at_news_from_date` ON (`at_news_from_date`.`entity_id` = `e`.`entity_id`) AND (`at_news_from_date`.`attribute_id` = '93') AND (`at_news_from_date`.`store_id` = 0) LEFT JOIN `cataloginventory_stock_status` AS `at_stock_status` ON (at_stock_status.`product_id`=e.entity_id) AND (at_stock_status.stock_id=1) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 2 WHERE (at_deal_start_date.value < '2023-02-02 06:32:59') AND (at_deal_end_date.value > '2023-02-02 06:32:59') AND (at_socko_date_ok.value = '1') AND (at_stock_status.stock_status = 1) ORDER BY `news_from_date` desc
  1. Prix Spécial 2750.00 CHF
    Prix normal 3700.00 CHF
    1675362779
    188820
    Fin de l'offre
  2. Prix Spécial 4450.00 CHF
    Prix normal 8700.00 CHF
    1675362779
    188820
    Fin de l'offre
  3. Prix Spécial 31250.00 CHF
    Prix normal 36000.00 CHF
    1675362779
    102420
    Fin de l'offre
  4. Prix Spécial 5750.00 CHF
    Prix normal 21600.00 CHF
    1675362779
    102420
    Fin de l'offre

Derniers jours

SELECT `e`.*, `at_deal_start_date`.`value` AS `deal_start_date`, `at_deal_end_date`.`value` AS `deal_end_date`, `at_socko_date_ok`.`value` AS `socko_date_ok`, `at_stock_status`.`stock_status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_datetime` AS `at_deal_start_date` ON (`at_deal_start_date`.`entity_id` = `e`.`entity_id`) AND (`at_deal_start_date`.`attribute_id` = '145') AND (`at_deal_start_date`.`store_id` = 0) INNER JOIN `catalog_product_entity_datetime` AS `at_deal_end_date` ON (`at_deal_end_date`.`entity_id` = `e`.`entity_id`) AND (`at_deal_end_date`.`attribute_id` = '146') AND (`at_deal_end_date`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `at_socko_date_ok` ON (`at_socko_date_ok`.`entity_id` = `e`.`entity_id`) AND (`at_socko_date_ok`.`attribute_id` = '642') AND (`at_socko_date_ok`.`store_id` = 0) LEFT JOIN `cataloginventory_stock_status` AS `at_stock_status` ON (at_stock_status.`product_id`=e.entity_id) AND (at_stock_status.stock_id=1) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 2 WHERE (at_deal_start_date.value < '2023-02-02 06:32:59') AND (at_deal_end_date.value > '2023-02-02 06:32:59') AND (at_socko_date_ok.value = '1') AND (at_stock_status.stock_status = 1) ORDER BY `at_deal_end_date`.`value` desc
  1. Prix Spécial 349.00 CHF
    Prix normal  
  2. Prix Spécial 350.00 CHF
    Prix normal  
  3. Prix Spécial 350.00 CHF
    Prix normal  
  4. Prix Spécial 349.00 CHF
    Prix normal  

Meilleures ventes

SELECT `e`.*, `at_status`.`value` AS `status`, `at_deal_start_date`.`value` AS `deal_start_date`, `at_deal_end_date`.`value` AS `deal_end_date`, `at_stock_status`.`stock_status`, `at_order_month`.`value` AS `order_month` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 0) INNER JOIN `catalog_product_entity_datetime` AS `at_deal_start_date` ON (`at_deal_start_date`.`entity_id` = `e`.`entity_id`) AND (`at_deal_start_date`.`attribute_id` = '145') AND (`at_deal_start_date`.`store_id` = 0) INNER JOIN `catalog_product_entity_datetime` AS `at_deal_end_date` ON (`at_deal_end_date`.`entity_id` = `e`.`entity_id`) AND (`at_deal_end_date`.`attribute_id` = '146') AND (`at_deal_end_date`.`store_id` = 0) LEFT JOIN `cataloginventory_stock_status` AS `at_stock_status` ON (at_stock_status.`product_id`=e.entity_id) AND (at_stock_status.stock_id=1) LEFT JOIN `catalog_product_entity_int` AS `socko_date_ok_t` ON e.entity_id=socko_date_ok_t.entity_id AND socko_date_ok_t.attribute_id='642' AND socko_date_ok_t.store_id='0' LEFT JOIN `catalog_product_entity_decimal` AS `at_order_month` ON (`at_order_month`.`entity_id` = `e`.`entity_id`) AND (`at_order_month`.`attribute_id` = '204') AND (`at_order_month`.`store_id` = 0) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 2 WHERE (at_status.value = '1') AND (at_deal_start_date.value < '2023-02-02 18:32:59') AND (at_deal_end_date.value >= '2023-02-02 00:00:00') AND (at_status.value = '1') AND (at_stock_status.stock_status = 1) ORDER BY `socko_date_ok_t`.`value` desc, `order_month` desc, `e`.`created_at` desc
  1. Prix Spécial 95.00 CHF
    Prix normal 179.00 CHF
  2. Prix Spécial 1435.00 CHF
    Prix normal 2875.00 CHF
  3. Prix Spécial 115.00 CHF
    Prix normal 235.00 CHF
  4. Prix Spécial 65.00 CHF
    Prix normal 139.00 CHF

Remontoirs

SELECT `e`.*, `at_deal_start_date`.`value` AS `deal_start_date`, `at_deal_end_date`.`value` AS `deal_end_date`, `at_socko_date_ok`.`value` AS `socko_date_ok`, `at_stock_status`.`stock_status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_datetime` AS `at_deal_start_date` ON (`at_deal_start_date`.`entity_id` = `e`.`entity_id`) AND (`at_deal_start_date`.`attribute_id` = '145') AND (`at_deal_start_date`.`store_id` = 0) INNER JOIN `catalog_product_entity_datetime` AS `at_deal_end_date` ON (`at_deal_end_date`.`entity_id` = `e`.`entity_id`) AND (`at_deal_end_date`.`attribute_id` = '146') AND (`at_deal_end_date`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `at_socko_date_ok` ON (`at_socko_date_ok`.`entity_id` = `e`.`entity_id`) AND (`at_socko_date_ok`.`attribute_id` = '642') AND (`at_socko_date_ok`.`store_id` = 0) LEFT JOIN `cataloginventory_stock_status` AS `at_stock_status` ON (at_stock_status.`product_id`=e.entity_id) AND (at_stock_status.stock_id=1) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 2 WHERE (at_deal_start_date.value < '2023-02-02 06:32:59') AND (at_deal_end_date.value > '2023-02-02 06:32:59') AND (at_socko_date_ok.value = '1') AND (e.entity_id IN((SELECT `cat`.`product_id` FROM `catalog_category_product` AS `cat` WHERE (cat.category_id IN('535'))))) AND (at_stock_status.stock_status = 1)
  1. Prix Spécial 139.00 CHF
    Prix normal  
  2. Prix Spécial 349.00 CHF
    Prix normal  
  3. Prix Spécial 1990.00 CHF
    Prix normal  
  4. Prix Spécial 410.00 CHF
    Prix normal  

Derniers commentaires

Boîte de montre BLuxe Moderne

Fabrice • 14/01/2023

Reçu le lendemain de ma commande. Produit de qualité. Boite avec un bel effet carbone. Je recommande si vous avez minimum 4 montres, très pratique et facile à ranger.

Montre Ebel Wave

Martina • 10/01/2023

Très pro l'envoi. Contre signature. Carton soigné. Je me suis bien réjouis d'ouvrir mon envoi. Très belle montre. Reçu dans sa boite et surboite et tous les documents bien soignés. Belle expérience d'achat sur sovogue. Encore un grand merci pour la carte écrite à la main...

Montre Swiss Alpine Military

Sylvain • 01/01/2023

Reçu dans les délais. L'envoi est nickel, montre bien protégée. Boite de la montre intacte. Tous les documents de garantie. Et même de petits cadeaux surprises dans le carton comme du chocolat, stylo et autres, je vous laisse la surprise. Merci pour votre professionalisme...

Montre Victorinox Swiss Army Airboss Mechanical Chronograph

Gabriel • 07/12/2022

Très belle montre automatique. Pour ce prix là avoir de la qualité suisse, de la finesse et de la robustesse, il n'y a que sur Sovogue qu'on peut trouver ce genre de bonne affaire. Et le service est TOP. Je l'ai reçu le lendemain de ma commande.

Boîte de Montre BLuxe Elegance

Matthieu M. • 30/11/2022

Je suis ravi de mon achat, belles finition et très bon prix. Livraison rapide. Merci !

Dernières vidéos