SucheHauptArtikel: SELECT * FROM DevilKatalogArtikel WHERE Aktiv=1 AND (Hersteller LIKE "%düsennadel%" OR Modell LIKE "%düsennadel%" OR KurzBez LIKE "%düsennadel%" OR KurzBezEN LIKE "%düsennadel%" OR ArtText LIKE "%düsennadel%" OR Suchbegriffe LIKE "%düsennadel%" OR DevilArtNr LIKE "%düsennadel%" OR Hauptgruppe LIKE "%düsennadel%" OR Untergruppe LIKE "%düsennadel%" OR ZNr LIKE "%düsennadel%" ) AND (Hersteller LIKE "%rs%" OR Modell LIKE "%rs%" OR KurzBez LIKE "%rs%" OR KurzBezEN LIKE "%rs%" OR ArtText LIKE "%rs%" OR Suchbegriffe LIKE "%rs%" OR DevilArtNr LIKE "%rs%" OR Hauptgruppe LIKE "%rs%" OR Untergruppe LIKE "%rs%" OR ZNr LIKE "%rs%" ) AND (Hersteller LIKE "%450%" OR Modell LIKE "%450%" OR KurzBez LIKE "%450%" OR KurzBezEN LIKE "%450%" OR ArtText LIKE "%450%" OR Suchbegriffe LIKE "%450%" OR DevilArtNr LIKE "%450%" OR Hauptgruppe LIKE "%450%" OR Untergruppe LIKE "%450%" OR ZNr LIKE "%450%" ) AND Hersteller<>"" AND KurzBez LIKE "%%" AND Bestand<>0 GROUP BY DevilArtNr ORDER BY KurzBez -