Tiergesundheitsspritzen
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 = '去DE')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 = '去DE')OR(`sda`.association = 'NoModel' AND sd.state = 1 AND sd.link_file!= ''和sd.link_file IS NOT NULL和sd.langue = 'DE-DE' 和sd.catalogue = 2))GROUP BY sd.id ORDER BY sd.is_general_catalog DESC,ASC sdc.ordering,sd.ordering ASC

Filtern第三人以

Alles的rücksetzen
  • Dokumente
  • 第三人以SPRACHE FILTERN
  • PRODUKTE每Familien
素贞
  • SOCOREX®187经典

    GeneralkatalogVeterinärbereich

    促销/Broschüre
  • SOCOREX® 1810

    SOCOREX®1810

    促销/Broschüre
  • SOCOREX®

    SOCOREX®Sterilisationsbeutel

    促销/Broschüre
  • SOCOREX®

    ABFTM值Gleitspray

    传单
  • SOCOREX®187经典

    SOCOREX®VeterinärSpritzen

    Betriebsanleitung
  • SOCOREX® 1810

    SOCOREX®1810

    Betriebsanleitung
  • 算盘™舒斯-Zähler

    快速指南
  • 鱼指南™献给167分之187

    快速指南
  • FishGuide™献给超1810

    快速指南
  • SOCOREX®187经典

    SOCOREX®VeterinärSpritzen

    快速指南
  • SOCOREX® 1810

    SOCOREX®1810

    快速指南
  • SOCOREX®

    ABFTM值Gleitspray

    材料安全数据表