and hersteller = 'FRIENDS' and serie_bezeichnung like '%Socken%' and naviID != '7480' and naviID != '7408' and naviID != '7442' group by ean