SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1746050340' AND e.updated_in > '1746050340') LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 8 WHERE (e.entity_id IN (1478, 22, 16800)) AND (t_d.attribute_id IN (134)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1746050340' AND e.updated_in > '1746050340') LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 8 WHERE (e.entity_id IN (1478, 22, 16800)) AND (t_d.attribute_id IN (569, 566)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1746050340' AND e.updated_in > '1746050340') LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 8 WHERE (e.entity_id IN (1478, 22, 16800)) AND (t_d.attribute_id IN (572)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) TRE SENSI - BORMIOLI ROCCO - Marques & Gammes

Livraison 24/48h

352 37 13 90 

Basculer la navigation
Rechercher
  • Achat par référence
Trouvez un magasin près de chez vousMagasin
Panier
Basculer la navigation
Basculer la navigation
Rechercher

TRE SENSI

Afficher en Grille Liste

5 articles

Trier par
par page
Filtrer
Promo
Poids
OK
Contenance
Diamètre
Ajouté(s) au panier !
Voir mon panier