Die neuesten Luxusuhren zum Verkauf auf Sovogue.ch
Die Neuheiten auf Sovogue
Die letzten Neuheiten in unserem Katalog von Luxusuhren und großen Marken zu reduzierten Preisen. Profitieren Sie von unseren Rabatten von 30% bis 70% auf unsere Automatikuhren, mechanischen Modelle oder Quarzuhren und verschenken Sie ein wunderschönes Stück Luxus und Geschichte.
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-08 12:39:34') AND (at_deal_end_date.value > '2023-02-08 12:39:34') AND (at_socko_date_ok.value = '1') AND (at_stock_status.stock_status = 1) ORDER BY `e`.`entity_id` desc