SucheHauptArtikel: SELECT * FROM DevilKatalogArtikel WHERE Aktiv=1 AND (Hersteller LIKE "%Glühbirne%" OR Modell LIKE "%Glühbirne%" OR KurzBez LIKE "%Glühbirne%" OR KurzBezEN LIKE "%Glühbirne%" OR ArtText LIKE "%Glühbirne%" OR Suchbegriffe LIKE "%Glühbirne%" OR DevilArtNr LIKE "%Glühbirne%" OR Hauptgruppe LIKE "%Glühbirne%" OR Untergruppe LIKE "%Glühbirne%" OR ZNr LIKE "%Glühbirne%" ) AND (Hersteller LIKE "%12%" OR Modell LIKE "%12%" OR KurzBez LIKE "%12%" OR KurzBezEN LIKE "%12%" OR ArtText LIKE "%12%" OR Suchbegriffe LIKE "%12%" OR DevilArtNr LIKE "%12%" OR Hauptgruppe LIKE "%12%" OR Untergruppe LIKE "%12%" OR ZNr LIKE "%12%" ) AND (Hersteller LIKE "%V%" OR Modell LIKE "%V%" OR KurzBez LIKE "%V%" OR KurzBezEN LIKE "%V%" OR ArtText LIKE "%V%" OR Suchbegriffe LIKE "%V%" OR DevilArtNr LIKE "%V%" OR Hauptgruppe LIKE "%V%" OR Untergruppe LIKE "%V%" OR ZNr LIKE "%V%" ) AND (Hersteller LIKE "%5%" OR Modell LIKE "%5%" OR KurzBez LIKE "%5%" OR KurzBezEN LIKE "%5%" OR ArtText LIKE "%5%" OR Suchbegriffe LIKE "%5%" OR DevilArtNr LIKE "%5%" OR Hauptgruppe LIKE "%5%" OR Untergruppe LIKE "%5%" OR ZNr LIKE "%5%" ) AND (Hersteller LIKE "%Watt%" OR Modell LIKE "%Watt%" OR KurzBez LIKE "%Watt%" OR KurzBezEN LIKE "%Watt%" OR ArtText LIKE "%Watt%" OR Suchbegriffe LIKE "%Watt%" OR DevilArtNr LIKE "%Watt%" OR Hauptgruppe LIKE "%Watt%" OR Untergruppe LIKE "%Watt%" OR ZNr LIKE "%Watt%" ) AND Hersteller<>"" AND KurzBez LIKE "%%" AND Bestand<>0 GROUP BY DevilArtNr ORDER BY KurzBez -