and hersteller = 'CANDY' and serie_bezeichnung like '%Sandwichmaker Kontaktgrill%' 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