SucheHauptArtikel: SELECT * FROM DevilKatalogArtikel WHERE Aktiv=1 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 LIKE "%Nova%" OR Modell LIKE "%Nova%" OR KurzBez LIKE "%Nova%" OR KurzBezEN LIKE "%Nova%" OR ArtText LIKE "%Nova%" OR Suchbegriffe LIKE "%Nova%" OR DevilArtNr LIKE "%Nova%" OR Hauptgruppe LIKE "%Nova%" OR Untergruppe LIKE "%Nova%" OR ZNr LIKE "%Nova%" ) AND (Hersteller LIKE "%city%" OR Modell LIKE "%city%" OR KurzBez LIKE "%city%" OR KurzBezEN LIKE "%city%" OR ArtText LIKE "%city%" OR Suchbegriffe LIKE "%city%" OR DevilArtNr LIKE "%city%" OR Hauptgruppe LIKE "%city%" OR Untergruppe LIKE "%city%" OR ZNr LIKE "%city%" ) AND (Hersteller LIKE "%star%" OR Modell LIKE "%star%" OR KurzBez LIKE "%star%" OR KurzBezEN LIKE "%star%" OR ArtText LIKE "%star%" OR Suchbegriffe LIKE "%star%" OR DevilArtNr LIKE "%star%" OR Hauptgruppe LIKE "%star%" OR Untergruppe LIKE "%star%" OR ZNr LIKE "%star%" ) AND Hersteller<>"" AND KurzBez LIKE "%%" AND Bestand<>0 GROUP BY DevilArtNr ORDER BY KurzBez -