Climatiseurs - Ventilateurs

XXXXXXXXXXXXXXXX SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `at_socko_date_ok`.`value` AS `socko_date_ok`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 8 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) 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` = '553') AND (`at_socko_date_ok`.`store_id` = 0) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (at_socko_date_ok.value = 1) AND (at_socko_date_ok.value = 1) AND (at_socko_date_ok.value = 1) AND (at_socko_date_ok.value = 1) AND (at_socko_date_ok.value = 1) AND (e.entity_id IN (57845, 57850, 57865, 57879, 57883, 57830)) ORDER BY FIELD(e.entity_id,57845,57850,57865,57879,57883,57830)

6 articles

par page
Par ordre décroissant
  1. 100%
    Prix Spécial 85,00 CHF
    Prix normal 199,00 CHF
  2. Prix Spécial 44,00 CHF
    Prix normal 79,00 CHF
  3. Prix Spécial 104,00 CHF
    Prix normal 299,00 CHF
  4. Prix Spécial 55,00 CHF
    Prix normal 85,00 CHF
  5. Prix Spécial 45,00 CHF
    Prix normal  
  6. Prix Spécial 375,00 CHF
    Prix normal 799,00 CHF

6 articles

par page
Par ordre décroissant