SELECT COUNT(*) AS anzahl FROM dbo.tbl_artikel2010 WITH (NOLOCK) LEFT OUTER JOIN dbo.tbl_lieferanten ON dbo.tbl_artikel2010.LID = dbo.tbl_lieferanten.LID LEFT OUTER JOIN dbo.tbl_artikel2010_farbe ON dbo.tbl_artikel2010.farbe_id = dbo.tbl_artikel2010_farbe.ID WHERE EXISTS (SELECT id, aid, eigenschaft FROM dbo.tbl_artikel2010_eigenschaften WITH (NOLOCK) WHERE (aid = dbo.tbl_artikel2010.AID) AND (eigenschaft IN (91))) AND ISNULL(dbo.tbl_artikel2010.wgid, 0) > 0 AND (dbo.tbl_artikel2010.LID = 21) and (dbo.tbl_artikel2010.menukategorien Like '%flur%') and (dbo.tbl_artikel2010.menukategorien Like '%klassisch%') and (dbo.tbl_artikel2010.wgid<>130) AND (COALESCE (dbo.tbl_artikel2010.unsichtbar, 'false') <> 'true') AND (dbo.tbl_artikel2010.artikelbezug = 0) AND (dbo.tbl_artikel2010.wgidall LIKE N'%A4A%') AND dbo.tbl_artikel2010.shop = '1'