and (config7 like '%%' && config7 like '%Wrmeisoliertes Gehuse%' && config7 like '%Auftaufunktion%' && config7 like '%Brtchenaufsatz%' && config7 like '%Entfernbares Krmelauffangblech%') and naviID != '4641' and naviID != '4642' and naviID != '4643' and naviID != '4644' and naviID != '4632' and naviID != '4640' and naviID != '7723' and naviID != '7894' group by ean