These cookies are necessary for the basic functions of the shop.
"Allow all cookies" cookie
"Decline all cookies" cookie
These cookies are used to make the shopping experience even more appealing, for example for the recognition of the visitor.
Statistics & Tracking
Track device being used
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 = 527
ORDER BY attr7, attr8, ad.id