SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND FilterText6 = 'CWP' GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND FilterText6 = 'CWV' GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND FilterText6 = 'LKPW075' GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND FilterText6 = 'LIPW075' GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND FilterText6 = 'Wandanbauleuchte' GROUP BY artnr) AS gruppiert