Vật tư linh kiện

([ProductGroupId]=247 OR [ProductGroupId] IN (SELECT [ProductGroupId] FROM [dbo].[ProductGroup] WHERE [ProductGroupIdFather]=247)) AND [TopLevel]>-1 AND [dbo].[RemoveMark]([Status]) <> 'Ngung san xuat'