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