Neuheiten

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-09 05:33:18') AND (at_deal_end_date.value > '2023-02-09 05:33:18') AND (at_socko_date_ok.value = '1') AND (at_stock_status.stock_status = 1) ORDER BY `news_from_date` desc
  1. Prix Spécial 1'215.00 CHF
    Prix normal 2'425.00 CHF
    1675920798
    235601
    Dieses Angebot endet in..
  2. Prix Spécial 975.00 CHF
    Prix normal 1'950.00 CHF
    1675920798
    322001
    Dieses Angebot endet in..
  3. Prix Spécial 2'500.00 CHF
    Prix normal 2'950.00 CHF
    1675920798
    235601
    Dieses Angebot endet in..
  4. Prix Spécial 165.00 CHF
    Prix normal 215.00 CHF
    1675920798
    149201
    Dieses Angebot endet in..

Letzter tag

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-09 05:33:18') AND (at_deal_end_date.value > '2023-02-09 05:33:18') 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 420.00 CHF
    Prix normal  
  3. Prix Spécial 349.00 CHF
    Prix normal  
  4. Prix Spécial 350.00 CHF
    Prix normal  

Top Bestsellers

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`, `lang`.`value` AS `langDe`, `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) INNER JOIN `catalog_product_entity_text` AS `lang` ON e.entity_id = lang.entity_id 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-09 05:33:19') AND (at_deal_end_date.value >= '2023-02-09 00:00:00') AND (at_status.value = '1') AND (lang.store_id = 17) AND (lang.attribute_id = 73) 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 149.00 CHF
    Prix normal 295.00 CHF
  3. Prix Spécial 229.00 CHF
    Prix normal 499.00 CHF
  4. Prix Spécial 115.00 CHF
    Prix normal 235.00 CHF

Uhrenbeweger

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-09 05:33:19') AND (at_deal_end_date.value > '2023-02-09 05:33:19') 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 1'990.00 CHF
    Prix normal  
  4. Prix Spécial 410.00 CHF
    Prix normal  

Letzte Videos