Termostato refrigerante KIA K2700 SD 2 7 D GATES

  Termostato refrigerante es fabricado por GATES para KIA K2700 SD 2 7 D tipo.Todas las informaciones para este producto se enumeran a continuación.

23 din 4 voturi

Repuestos coches para:

Nombres de coches
Modelo
Tipo
▷▷▷ Repuestos de coches KIA K2700 SD 2 7 D
SELECT gra_sup_id, gra_id, gra_doc_type, gra_lng_id, gra_type, gra_norm, gra_supplier_nr, gra_tab_nr, gra_grd_id, if(gra_tex.tex_text, gra_tex_uni.tex_text,'') gra_designation, lga_sort, 2 sort FROM tof_graphics g JOIN tof_link_gra_art ON gra_id = lga_gra_id and lga_art_id ='1229167' and substring(lga_ctm, 65, 1) =1 left outer join tof_designations gra_des on gra_des_id = gra_des.des_id and gra_des.des_lng_id = 8 left outer join tof_des_texts gra_tex on gra_des.des_tex_id = gra_tex.tex_id left outer join tof_designations gra_des_uni on gra_des_id = gra_des_uni.des_id and gra_des_uni.des_lng_id = 255 left outer join tof_des_texts gra_tex_uni on gra_des_uni.des_tex_id = gra_tex_uni.tex_id where ( gra_lng_id = 8 or ( gra_lng_id = 255 and not exists ( select gra_id from tof_graphics g1 where g.gra_id = g1.gra_id and g1.gra_lng_id = 8 ) ) ) and not exists (select 1 from tof_ali_coordinates ali where lga_gra_id = ali.aco_gra_id and lga_art_id = ali.aco_ali_art_id and (6 = ali.aco_gra_lng_id or (ali.aco_gra_lng_id = 255 and not exists (select 1 from tof_ali_coordinates ali_co where ali_co.aco_gra_id = ali.aco_gra_id and ali_co.aco_ali_art_id = ali.aco_ali_art_id and ali_co.aco_gra_lng_id = 8 )))) and gra_norm = '5' UNION SELECT gra_sup_id, gra_id, gra_doc_type, gra_lng_id, gra_type, gra_norm, gra_supplier_nr, gra_tab_nr, gra_grd_id, if(gra_tex.tex_text is null,'', gra_tex_uni.tex_text) gra_designation, lgl_sort lga_sort, 1 sort FROM tof_graphics g JOIN tof_link_gra_la ON gra_id = lgl_gra_id and lgl_la_id = '11630570' and substring(lgl_ctm,65,1) =1 left outer join tof_designations gra_des on gra_des_id = gra_des.des_id and gra_des.des_lng_id = 8 left outer join tof_des_texts gra_tex on gra_des.des_tex_id = gra_tex.tex_id left outer join tof_designations gra_des_uni on gra_des_id = gra_des_uni.des_id and gra_des_uni.des_lng_id = 255 left outer join tof_des_texts gra_tex_uni on gra_des_uni.des_tex_id = gra_tex_uni.tex_id where ( gra_lng_id = 8 or ( gra_lng_id = 255 and not exists ( select gra_id from tof_graphics g1 where g.gra_id = g1.gra_id and g1.gra_lng_id = 8 ) ) ) and not exists (select 1 from tof_ali_coordinates ali where lgl_gra_id = ali.aco_gra_id and 1229167 = ali.aco_ali_art_id and (6 = ali.aco_gra_lng_id or (ali.aco_gra_lng_id = 255 and not exists (select 1 from tof_ali_coordinates ali_co where ali_co.aco_gra_id = ali.aco_gra_id and ali_co.aco_ali_art_id = ali.aco_ali_art_id and ali_co.aco_gra_lng_id = 8 )))) and gra_norm ='5' order by sort, lga_sort