如何在 LINQ 中对此选择查询使用非重复

我有以下查询：

var query = from product in SH_Products
        from product_group in SH_ProductGroups_Products.Where(c=>c.ProductID == product.ID)
        from manufacturer in SH_Manufacturers.Where(c=>c.ID == product.ManufactureID)   
        from attributeOption_product in SH_AttributeOptions_Products.Where(c=>c.ProductID == product.ID).DefaultIfEmpty()
        where !product.IsDeleted
        && !product_group.IsDeleted
        && !manufacturer.IsDeleted
        && product.Status != 0  
        select new
        {
            product.ID,   
            ProductGroupID = product_group.ProductGroupID,
            AttributeOptionID = (int?)attributeOption_product.AttributeOptionsID,
            product.ManufacturerID
        };
query.Distinct().Dump();

下面是示例输出：

ID    ProductGroupID    AttributeOptionID    ManufacturerID
1     1                 75                   1
1     1                 76                   1
2     3                 17                   2
3     2                 3                    1
4     1                 NULL                 1

如您所见，我们有 2 条记录与 ID = 1 ，我不想这样，我如何删除这个？

我为项目的过滤部分编写了此查询。我有按ProductGroupID、AttributeOptionID、ManufacturerID过滤，都是多选的！

谢谢！