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