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 = 'SBA' 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 = 'SDAB | SDAL' 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 = 'SDAW' 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 = 'SDAX' 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 = 'SDAZ' GROUP BY artnr) AS gruppiert