0 TREFFER bei Abfrage: select distinct A.ManArtNr, A.Thumbnail, A.bigThumb, A.Spezifikation, A.ID_Coll, A.ID_Patt, A.ID_Man,
P.publish, P.NameMuster, P.ozGewicht, P.gqm, P.Breite, P.Laenge, P.Typ, P.EN13501, P.spec_sheet, P.patt_scheme,
C.NameColl, C.BrandVerh, M.NameMan, L.Materialname
from articles as A
left join patterns as P using (ID_Man,ID_Patt)
left join collections as C on (C.ID_Coll=A.ID_Coll and C.ID_Man=A.ID_Man)
left join materials as L using (ID_M)
left join manufacturers as M on (M.ID_Man=A.ID_Man)
where (A.ID_Man="SYMP") and (A.ArtNr="AZ431") and A.ID_Patt="SU"