Verfügbare Varianten
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 = 466
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 = 466
ORDER BY attr7, attr8, ad.id
