SucheHauptArtikel: SELECT * FROM DevilKatalogArtikel WHERE Aktiv=1 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 "%3%" OR Modell LIKE "%3%" OR KurzBez LIKE "%3%" OR KurzBezEN LIKE "%3%" OR ArtText LIKE "%3%" OR Suchbegriffe LIKE "%3%" OR DevilArtNr LIKE "%3%" OR Hauptgruppe LIKE "%3%" OR Untergruppe LIKE "%3%" OR ZNr LIKE "%3%" ) AND (Hersteller LIKE "%W%" OR Modell LIKE "%W%" OR KurzBez LIKE "%W%" OR KurzBezEN LIKE "%W%" OR ArtText LIKE "%W%" OR Suchbegriffe LIKE "%W%" OR DevilArtNr LIKE "%W%" OR Hauptgruppe LIKE "%W%" OR Untergruppe LIKE "%W%" OR ZNr LIKE "%W%" ) AND (Hersteller LIKE "%Glühlampe%" OR Modell LIKE "%Glühlampe%" OR KurzBez LIKE "%Glühlampe%" OR KurzBezEN LIKE "%Glühlampe%" OR ArtText LIKE "%Glühlampe%" OR Suchbegriffe LIKE "%Glühlampe%" OR DevilArtNr LIKE "%Glühlampe%" OR Hauptgruppe LIKE "%Glühlampe%" OR Untergruppe LIKE "%Glühlampe%" OR ZNr LIKE "%Glühlampe%" ) AND (Hersteller LIKE "%Glassockel%" OR Modell LIKE "%Glassockel%" OR KurzBez LIKE "%Glassockel%" OR KurzBezEN LIKE "%Glassockel%" OR ArtText LIKE "%Glassockel%" OR Suchbegriffe LIKE "%Glassockel%" OR DevilArtNr LIKE "%Glassockel%" OR Hauptgruppe LIKE "%Glassockel%" OR Untergruppe LIKE "%Glassockel%" OR ZNr LIKE "%Glassockel%" ) AND Hersteller<>"" AND KurzBez LIKE "%%" AND Bestand<>0 GROUP BY DevilArtNr ORDER BY KurzBez -