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 "%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 LIKE "%Lüfter%" OR Modell LIKE "%Lüfter%" OR KurzBez LIKE "%Lüfter%" OR KurzBezEN LIKE "%Lüfter%" OR ArtText LIKE "%Lüfter%" OR Suchbegriffe LIKE "%Lüfter%" OR DevilArtNr LIKE "%Lüfter%" OR Hauptgruppe LIKE "%Lüfter%" OR Untergruppe LIKE "%Lüfter%" OR ZNr LIKE "%Lüfter%" ) AND Hersteller<>"" AND KurzBez LIKE "%%" AND Bestand<>0 GROUP BY DevilArtNr ORDER BY KurzBez -