Envio

Envío gratis a partir de 49€

Kit de estética RFX Factory (Magura)- motoscamaralweb.com
search

Kit de estética RFX Factory (Magura)

124,52 €
Impuestos incluidos Envío gratuito, de 3 a 5 dias.
Cantidad

  Envio

Envío gratis a partir de 49€

Kit RFX Factory para Husqvarna (Magura) TC125 18 TX300 18-21 FC250/350/450 18

Color Azul
Composición Aluminio
Embalaje por unidad
VI1110537001
) AS subset_products INNER JOIN `prstshp_product` p ON p.`id_product` = subset_products.id_product INNER JOIN `prstshp_product_shop` product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `prstshp_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `prstshp_stock_available` stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0) LEFT JOIN `prstshp_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1) LEFT JOIN `prstshp_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1) LEFT JOIN `prstshp_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `prstshp_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `prstshp_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`;