MicroDrill 7xD - KB3797

VHM-Mikrobohrer ohne IK 7xD

VHM-Mikrobohrer für den Einsatz mit äußerer Kühlmittelzufuhr.

• 2 Führungsfasen
• ZX1-Beschichtung
• Nachfolgeprodukt für KB187

Available variants

SQLSET: SELECT cg.id as 'group_id' FROM s_articles a, s_article_configurator_sets sets, s_article_configurator_set_group_relations sgr, s_article_configurator_groups cg WHERE configurator_set_id = sets.id AND sets.id = set_id AND sgr.group_id = cg.id AND a.id = 739 order by cg.position

SQL-SortBasis: SELECT attr9 FROM s_articles_attributes aa, s_articles_details ad WHERE aa.articledetailsID = ad.id AND ad.active = 1 AND kind = 1 AND ad.articleID = 739

SQL-Basis: SELECT ad.id AS 'artdetailid', ordernumber, additionaltext, suppliernumber, kind, attr11 FROM s_articles_attributes aa, s_articles_details ad WHERE aa.articledetailsID = ad.id AND ad.active = 1 AND ad.articleID = 739 ORDER BY attr7, attr8, ad.id