SucheHauptArtikel: SELECT * FROM DevilKatalogArtikel WHERE Aktiv=1 AND (Hersteller LIKE "%zn50qt%" OR Modell LIKE "%zn50qt%" OR KurzBez LIKE "%zn50qt%" OR KurzBezEN LIKE "%zn50qt%" OR ArtText LIKE "%zn50qt%" OR Suchbegriffe LIKE "%zn50qt%" OR DevilArtNr LIKE "%zn50qt%" OR Hauptgruppe LIKE "%zn50qt%" OR Untergruppe LIKE "%zn50qt%" OR ZNr LIKE "%zn50qt%" ) AND (Hersteller LIKE "%11%" OR Modell LIKE "%11%" OR KurzBez LIKE "%11%" OR KurzBezEN LIKE "%11%" OR ArtText LIKE "%11%" OR Suchbegriffe LIKE "%11%" OR DevilArtNr LIKE "%11%" OR Hauptgruppe LIKE "%11%" OR Untergruppe LIKE "%11%" OR ZNr LIKE "%11%" ) AND (Hersteller LIKE "%ölfilter%" OR Modell LIKE "%ölfilter%" OR KurzBez LIKE "%ölfilter%" OR KurzBezEN LIKE "%ölfilter%" OR ArtText LIKE "%ölfilter%" OR Suchbegriffe LIKE "%ölfilter%" OR DevilArtNr LIKE "%ölfilter%" OR Hauptgruppe LIKE "%ölfilter%" OR Untergruppe LIKE "%ölfilter%" OR ZNr LIKE "%ölfilter%" ) AND Hersteller<>"" AND KurzBez LIKE "%%" AND Bestand<>0 GROUP BY DevilArtNr ORDER BY KurzBez -