亚博yabo24
SELECT sd.id,sd.lng_parent,sd.title,sd.image,sd.link_file,sd.catalogue AS doc_catalogue,sd.langue AS doc_langue,sdc.title AS categorie,sdc.id AS categorie_id,sg.title AS gamme_title,sg.id AS gamme_id,sda.id_association AS id_modele FROM #__socorex_documents AS SD LEFT JOIN #__socorex_documents_cats AS SDC ON(sdc.lng_parent = sd.id_categorie AND sdc.langue = 'EN-GB')LEFT JOIN #__socorex_documents_associations AS SDA ON(sda.id_document = sd.lng_parent)LEFT JOIN #__socorex_gammes AS SG ON sg.lng_parent = sda.gamme WHERE((sd.state = 1 AND sd.link_file!= '' AND sd.link_file IS NOT NULL和sg.state= 1 AND sdc.state = 1 AND sd.catalogue = 2,sd.langue = 'EN-GB')或(`sda`.association = 'NoModel' AND sd.state = 1 AND sd.link_file!= ''和sd.link_file IS NOT NULL和sd.langue = 'EN-GB' AND sd.catalogue = 2))GROUP BY sd.id ORDER BY sd.is_general_catalog DESC,ASC sdc.ordering,sd.ordering ASC

过滤

重置全部
  • 文件
  • FILTER按语言
  • 产品家族
搜索
  • SOCOREX®187经典

    综合目录兽医亚博电竞平台

    录/单张
  • SOCOREX® 1810

    SOCOREX®1810

    录/单张
  • SOCOREX®

    SOCOREX®灭菌袋

    录/单张
  • SOCOREX®

    ABFTM值喷雾润滑剂

    传单
  • SOCOREX®187经典

    SOCOREX®亚博电竞平台兽医注射器

    操作说明
  • SOCOREX® 1810

    SOCOREX®1810

    操作说明
  • 算盘™射击计数器

    快速指南
  • 鱼指南™为167分之187

    快速指南
  • FishGuide™超1810

    快速指南
  • SOCOREX®187经典

    SOCOREX®亚博电竞平台兽医注射器

    快速指南
  • SOCOREX® 1810

    SOCOREX®1810

    快速指南
  • SOCOREX®

    ABFTM值喷雾润滑剂

    材料安全数据表