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 = 473
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 = 473
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 = 473
ORDER BY attr7, attr8, ad.id
