Máy Scan Canon

[ProductBranchId]=10 AND ([ProductGroupId]=89 OR [ProductGroupId] IN (SELECT [ProductGroupId] FROM [dbo].[ProductGroup] WHERE [ProductGroupIdFather]=89)) AND [TopLevel]>-1