and serie_bezeichnung like '%Wasserhhne%' and naviID != '515' and naviID != '6885' and naviID != '7021' group by ean
...