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 = 'SBL' 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 = 'SBE' 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 = 'SBT' 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 = 'SRL' 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 = 'SRE' 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 = 'SDE' 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 = 'SRB' 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 = 'SEMI' 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 = 'SECO' 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 = 'SEGI' 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 = 'SDEX' GROUP BY artnr) AS gruppiert