Oratam

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 (58045, 58230, 58234, 58239, 57995, 57567, 57575, 57980, 57981, 58458, 58469, 58487)) ORDER BY FIELD(e.entity_id,58045,58230,58234,58239,57995,57567,57575,57980,57981,58458,58469,58487)

12 articles

par page
Par ordre décroissant
  1. Prix Spécial 29,00 CHF
    Prix normal 69,00 CHF
  2. Prix Spécial 33,00 CHF
    Prix normal 65,00 CHF
    1702204225
    44974
    Fin de l'offre
  3. Prix Spécial 39,00 CHF
    Prix normal 89,00 CHF
  4. 100%
    Prix Spécial 25,00 CHF
    Prix normal 45,00 CHF
  5. 100%
    Prix Spécial 27,00 CHF
    Prix normal 59,00 CHF
    1702204225
    131374
    Fin de l'offre
  6. Prix Spécial 37,00 CHF
    Prix normal 59,00 CHF
  7. Prix Spécial 12,00 CHF
    Prix normal 24,00 CHF
    1702204225
    131374
    Fin de l'offre
  8. Prix Spécial 39,00 CHF
    Prix normal 85,00 CHF
    1702204225
    44974
    Fin de l'offre
  9. 100%
    Prix Spécial 19,00 CHF
    Prix normal 39,00 CHF
  10. Prix Spécial 29,00 CHF
    Prix normal 49,00 CHF
    1702204225
    44974
    Fin de l'offre
  11. Prix Spécial 16,00 CHF
    Prix normal 39,00 CHF
    1702204225
    131374
    Fin de l'offre
  12. Prix Spécial 19,00 CHF
    Prix normal 54,00 CHF

12 articles

par page
Par ordre décroissant