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