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