SucheHauptArtikel: SELECT * FROM DevilKatalogArtikel WHERE Aktiv=1 AND (Hersteller LIKE "%iridium%" OR Modell LIKE "%iridium%" OR KurzBez LIKE "%iridium%" OR KurzBezEN LIKE "%iridium%" OR ArtText LIKE "%iridium%" OR Suchbegriffe LIKE "%iridium%" OR DevilArtNr LIKE "%iridium%" OR Hauptgruppe LIKE "%iridium%" OR Untergruppe LIKE "%iridium%" OR ZNr LIKE "%iridium%" ) AND (Hersteller LIKE "%cr7hix%" OR Modell LIKE "%cr7hix%" OR KurzBez LIKE "%cr7hix%" OR KurzBezEN LIKE "%cr7hix%" OR ArtText LIKE "%cr7hix%" OR Suchbegriffe LIKE "%cr7hix%" OR DevilArtNr LIKE "%cr7hix%" OR Hauptgruppe LIKE "%cr7hix%" OR Untergruppe LIKE "%cr7hix%" OR ZNr LIKE "%cr7hix%" ) AND (Hersteller LIKE "%tuning%" OR Modell LIKE "%tuning%" OR KurzBez LIKE "%tuning%" OR KurzBezEN LIKE "%tuning%" OR ArtText LIKE "%tuning%" OR Suchbegriffe LIKE "%tuning%" OR DevilArtNr LIKE "%tuning%" OR Hauptgruppe LIKE "%tuning%" OR Untergruppe LIKE "%tuning%" OR ZNr LIKE "%tuning%" ) AND (Hersteller LIKE "%zündkerze%" OR Modell LIKE "%zündkerze%" OR KurzBez LIKE "%zündkerze%" OR KurzBezEN LIKE "%zündkerze%" OR ArtText LIKE "%zündkerze%" OR Suchbegriffe LIKE "%zündkerze%" OR DevilArtNr LIKE "%zündkerze%" OR Hauptgruppe LIKE "%zündkerze%" OR Untergruppe LIKE "%zündkerze%" OR ZNr LIKE "%zündkerze%" ) AND (Hersteller LIKE "%22179%" OR Modell LIKE "%22179%" OR KurzBez LIKE "%22179%" OR KurzBezEN LIKE "%22179%" OR ArtText LIKE "%22179%" OR Suchbegriffe LIKE "%22179%" OR DevilArtNr LIKE "%22179%" OR Hauptgruppe LIKE "%22179%" OR Untergruppe LIKE "%22179%" OR ZNr LIKE "%22179%" ) AND Hersteller<>"" AND KurzBez LIKE "%%" AND Bestand<>0 GROUP BY DevilArtNr ORDER BY KurzBez -