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 = 'LQF' 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 = 'LQN' 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 = 'LQA' GROUP BY artnr) AS gruppiert