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