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
Track device being used
CBN Indexable Insert TPGN, S=Chamfered+Brushed
Corner Equipped
Available variants
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 = 1070
SQL-Basis: SELECT ad.id AS 'artdetailid', ordernumber, additionaltext, suppliernumber, kind
FROM s_articles_attributes aa, s_articles_details ad
WHERE aa.articledetailsID = ad.id
AND ad.active = 1
AND ad.articleID = 1070
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.
