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