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 (54))) AND ISNULL(dbo.tbl_artikel2010.wgid, 0) > 0 AND (dbo.tbl_artikel2010.LID = 6) and (dbo.tbl_artikel2010.menukategorien Like '%esszimmer%') and (dbo.tbl_artikel2010.menukategorien Like '%modern%') 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'%A9A%') AND dbo.tbl_artikel2010.shop = '1'