Guangzhou JST Seals Technology Co., Ltd.
한국의한국의ko
  • EnglishenEnglish
  • françaisfrfrançais
  • DeutschdeDeutsch
  • русскийruрусский
  • italianoititaliano
  • españolesespañol
  • portuguêsptportuguês
  • العربيةarالعربية
  • #cn中文
  • 산업
    • 건설 산업
    • 석유 및 가스 산업
    • API6D 및 LNG 산업
    • 석유화학 및 반도체 산업
  • 제품
    • 유압 씰 SELECT `a`.*, `b`.*, `a`.`custom_cat_name` AS `custom_cat_name_en` FROM `b2b_custom_cat` AS `a` INNER JOIN `b2b_category_lang` AS `b` WHERE (a.user_user_id = '31304') AND (a.custom_custom_cat_id = '1') AND (b.custom_cat_id=a.custom_cat_id) AND (b.lang_id=12) ORDER BY `a`.`custom_cat_desc` ASC