Bucas

D'origine irlandaise, Bucas propose une gamme de couvertures et de couvre-cous de très haute qualité. La marque est connue pour l'utilisation de la doublure stay-dry dans ses couvertures et du tissu Recuptex dans ses produits thérapeutiques. Ils développent une large gamme de produits hautement innovants et techniquement avancés, pour le confort du cheval.

string(1819) "SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`price`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`coup_de_coeur`, `e`.`nb_doigts`, `e`.`nb_doigts_value`, `e`.`attr_test_123`, `e`.`attr_test_123_value`, `e`.`attr_special_order`, `e`.`attr_special_order_value`, `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` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '3471' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_index_eav` AS `attr_6_idx` ON attr_6_idx.entity_id = e.entity_id AND attr_6_idx.attribute_id = '304' AND attr_6_idx.store_id = 1 AND attr_6_idx.value IN('13437') WHERE (e.status = 1) ORDER BY `cat_index_position` desc, `cat_index`.`position` desc LIMIT 24"

Aucun produit ne correspond à la sélection