logo FM RICAMBI di Bruno Mariangela
  1. HOME
  2. Categorie ricambi auto
  3. Sistema frenante
  4. Freno a disco
  5. Pastiglia freno

RU POST. DAIMLER DAIMLER XJ (X30_) 109 - brembo - A00258

Articolo
RU POST. DAIMLER DAIMLER XJ (X30_) 109
Non disponibile

€ 18,45
IVA inclusa

Dati tecnici
LUNGHEZZA [ MM ] 455
TIPO FRENO FRENO A DISCO
N° INDICATORI USURA 2
Riferimenti originali
DBC6596 JAGUAR
SELECT cat2.id, lang_cat2.nome, lang_cat1.nome AS categoria1, cat2.codice FROM cms_categorie AS cat2 INNER JOIN cms_categorie_albero alb ON (cat2.id=alb.categoria_id AND alb.livello=2) INNER JOIN cms_categorie AS cat1 ON(cat1.id=alb.parent_id AND cat1.codice='azienda') INNER JOIN cms_categorie_lang AS lang_cat2 ON (cat2.id=lang_cat2.categoria_id AND lang_cat2.lang='it') INNER JOIN cms_categorie_lang AS lang_cat1 ON (cat1.id=lang_cat1.categoria_id AND lang_cat1.lang='it') WHERE cat2.attivo='1' ORDER BY alb.ordinazione ASC, cat2.id DESCSELECT cat2.id, lang_cat2.nome, lang_cat1.nome AS categoria1, cat2.codice FROM cms_categorie AS cat2 INNER JOIN cms_categorie_albero alb ON (cat2.id=alb.categoria_id AND alb.livello=2) INNER JOIN cms_categorie AS cat1 ON(cat1.id=alb.parent_id AND cat1.codice='pagamenti') INNER JOIN cms_categorie_lang AS lang_cat2 ON (cat2.id=lang_cat2.categoria_id AND lang_cat2.lang='it') INNER JOIN cms_categorie_lang AS lang_cat1 ON (cat1.id=lang_cat1.categoria_id AND lang_cat1.lang='it') WHERE cat2.attivo='1' ORDER BY alb.ordinazione ASC, cat2.id DESCSELECT cat2.id, lang_cat2.nome, lang_cat1.nome AS categoria1, cat2.codice FROM cms_categorie AS cat2 INNER JOIN cms_categorie_albero alb ON (cat2.id=alb.categoria_id AND alb.livello=2) INNER JOIN cms_categorie AS cat1 ON(cat1.id=alb.parent_id AND cat1.codice='garanzie') INNER JOIN cms_categorie_lang AS lang_cat2 ON (cat2.id=lang_cat2.categoria_id AND lang_cat2.lang='it') INNER JOIN cms_categorie_lang AS lang_cat1 ON (cat1.id=lang_cat1.categoria_id AND lang_cat1.lang='it') WHERE cat2.attivo='1' ORDER BY alb.ordinazione ASC, cat2.id DESC
Copyright Sofinn