Verfügbare Varianten

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 = 420 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 = 420

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