1 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="VYCO") and (A.ArtNr="Y46924") and A.ID_Patt="VSP"
Spectrum
Spectrum Y46924
| vinyl low voc Typ II | 450 g/qm |
| Breite x Länge | 137 x 2743 cm |
| Schwer entflammbar EN 13501 | C - s2, d0 |