This website uses cookies, which are necessary for the technical operation of the website and are always set. Other cookies, which increase the comfort when using this website, are used for direct advertising or to facilitate interaction with other websites and social networks, are only set with your consent.
Configuration
Technically required
These cookies are necessary for the basic functions of the shop.
"Allow all cookies" cookie
"Decline all cookies" cookie
CSRF token
Cookie preferences
Currency change
Customer recognition
Customer-specific caching
Individual prices
PayPal payments
Selected shop
Session
Comfort functions
These cookies are used to make the shopping experience even more appealing, for example for the recognition of the visitor.
Note
Statistics & Tracking
Affiliate program
Google GA4 Tracking
Track device being used
Hülse für Keramikfaser-Bürste
Zur Aufnahme einer Keramikfaser-Bürste
Die Hülse bietet der Keramikfaser-Bürste Führung und verhindert ein Aufspreizen durch Fliehkraft.
Die Verstellschraube der Hülse ermöglicht das Nutzen der Keramikfasern auf voller Länge.
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 = 678
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 = 678
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 = 678
ORDER BY attr7, attr8, ad.id
This website uses cookies, which are necessary for the technical operation of the website and are always set. Other cookies, which increase the usability of this website, serve for direct advertising or simplify interaction with other websites and social networks, will only be used with your consent.
