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` 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) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 WHERE (at_deal_start_date.value < '2022-11-29 02:01:19') AND (at_deal_end_date.value > '2022-11-29 02:01: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('913'))))) ORDER BY `news_from_date` desc

Derniers commentaires

Sompex Lampe de table LED Apéro Festif and Wine

Marc • 20/11/2022

J'en ai acheté une pour offrir un mon père. C'est un très beau cadeau comme on peut le personnaliser avec la bouteille qu'on veut.

Camera de Surveillance Bulbe 2 en 1

Rémo • 18/11/2022

Facile d'installation et d'utilisation. Juste Génial.

1 paire de chaussettes de compression et récupération

Laurence • 16/11/2022

Super produit, bon maintien et confortable à porter. Elles ont du succès auprès de mes amis.

Pantalon Training Polaire Activewear

Jean • 14/11/2022

Très agréable à porter. Je recommande.

Pantalon Training Polaire Activewear

Marielle • 13/11/2022

J'ai acheté un M et il me va très bien. Tiens bon chaud à l'extérieur quand je vais balader mon chien.