SucheHauptArtikel: SELECT * FROM DevilKatalogArtikel WHERE Aktiv=1 AND (Hersteller LIKE "%Scooter%" OR Modell LIKE "%Scooter%" OR KurzBez LIKE "%Scooter%" OR KurzBezEN LIKE "%Scooter%" OR ArtText LIKE "%Scooter%" OR Suchbegriffe LIKE "%Scooter%" OR DevilArtNr LIKE "%Scooter%" OR Hauptgruppe LIKE "%Scooter%" OR Untergruppe LIKE "%Scooter%" OR ZNr LIKE "%Scooter%" ) AND (Hersteller LIKE "%Agility%" OR Modell LIKE "%Agility%" OR KurzBez LIKE "%Agility%" OR KurzBezEN LIKE "%Agility%" OR ArtText LIKE "%Agility%" OR Suchbegriffe LIKE "%Agility%" OR DevilArtNr LIKE "%Agility%" OR Hauptgruppe LIKE "%Agility%" OR Untergruppe LIKE "%Agility%" OR ZNr LIKE "%Agility%" ) AND (Hersteller LIKE "%125%" OR Modell LIKE "%125%" OR KurzBez LIKE "%125%" OR KurzBezEN LIKE "%125%" OR ArtText LIKE "%125%" OR Suchbegriffe LIKE "%125%" OR DevilArtNr LIKE "%125%" OR Hauptgruppe LIKE "%125%" OR Untergruppe LIKE "%125%" OR ZNr LIKE "%125%" ) AND (Hersteller LIKE "%öl%" OR Modell LIKE "%öl%" OR KurzBez LIKE "%öl%" OR KurzBezEN LIKE "%öl%" OR ArtText LIKE "%öl%" OR Suchbegriffe LIKE "%öl%" OR DevilArtNr LIKE "%öl%" OR Hauptgruppe LIKE "%öl%" OR Untergruppe LIKE "%öl%" OR ZNr LIKE "%öl%" ) AND Hersteller<>"" AND KurzBez LIKE "%%" AND Bestand<>0 GROUP BY DevilArtNr ORDER BY KurzBez -