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-01-28 07:15:20') AND (at_deal_end_date.value > '2023-01-28 07:15:20') AND (at_socko_date_ok.value = '1') AND (at_stock_status.stock_status = 1) ORDER BY `news_from_date` desc
  1. Prix Spécial 2950.00 CHF
    Prix normal 3850.00 CHF
    1674933320
    13479
    Fin de l'offre
  2. Prix Spécial 2950.00 CHF
    Prix normal 3650.00 CHF
    1674933320
    13479
    Fin de l'offre
  3. Prix Spécial 1295.00 CHF
    Prix normal  
  4. Prix Spécial 1175.00 CHF
    Prix normal  

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-01-28 07:15:20') AND (at_deal_end_date.value > '2023-01-28 07:15:20') 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 350.00 CHF
    Prix normal  
  2. Prix Spécial 349.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-01-28 19:15:21') AND (at_deal_end_date.value >= '2023-01-28 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 115.00 CHF
    Prix normal 235.00 CHF
  2. Prix Spécial 95.00 CHF
    Prix normal 179.00 CHF
  3. Prix Spécial 65.00 CHF
    Prix normal 139.00 CHF
  4. Prix Spécial 79.00 CHF
    Prix normal 169.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-01-28 07:15:21') AND (at_deal_end_date.value > '2023-01-28 07:15:21') 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 285.00 CHF
    Prix normal  
    1674933321
    186278
    Fin de l'offre

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