Tubring25

-- 主查询：以 PartGroup (pg) 为主
SELECT DISTINCT
  pg.GroupName AS PartGroupName,
  bg.GroupName AS BankGroupName,
  pg.GroupId      AS PartGroupId,
  scr.Status      AS SystemControlStatus
FROM GroupMaster pg
  INNER JOIN GroupExtendInfo ge ON ge.GroupId = pg.GroupId AND ge.GroupKind = 4            -- 只要 PartGroup
  INNER JOIN TempBanPart tb ON tb.TargetId = pg.GroupId                                   -- TempBanPart.TargetId = PartGroupId
  INNER JOIN SystemControlRequest scr ON scr.RequestId = tb.RequestId