SELECT
  OPFR_CODE,
  SUM(COUNT)
FROM (
  SELECT
    OPFR_CODE,
    COUNT(1) AS COUNT
  FROM ASV_INSURER
    JOIN ASV_OPFR ON ASV_OPFR.OPFR_ID = ASV_INSURER.OPFR_ID
    JOIN
    ASV_GLOBAL_INSURER_RELATION ON ASV_INSURER
                                   .INSURER_ID =
                                   ASV_GLOBAL_INSURER_RELATION.INSURER_ID
    JOIN (
           SELECT CB_ACCOUNT_GLOBAL_INSURER_ID
           FROM ASV_CB_ACCOUNT
           WHERE CB_ACCOUNT_GLOBAL_INSURER_ID IS NOT NULL
           GROUP BY
             CB_ACCOUNT_GLOBAL_INSURER_ID) omg ON omg
                                                  .CB_ACCOUNT_GLOBAL_INSURER_ID =
                                                  ASV_GLOBAL_INSURER_RELATION.GLOBAL_INSURER_ID
  GROUP BY OPFR_CODE
  UNION ALL

  SELECT
    OPFR_CODE,
    COUNT(1) AS COUNT
  FROM ASV_INSURER
    JOIN ASV_OPFR ON ASV_OPFR.OPFR_ID = ASV_INSURER.OPFR_ID
    JOIN
    ASV_GLOBAL_INSURER_RELATION ON ASV_INSURER.INSURER_ID = ASV_GLOBAL_INSURER_RELATION.INSURER_ID
    JOIN
    ASV_GLOBAL_INSURER ON ASV_GLOBAL_INSURER.GLOBAL_INSURER_ID = ASV_GLOBAL_INSURER_RELATION.GLOBAL_INSURER_ID
    JOIN (
           SELECT CB_ACCOUNT_COMMON_INSURER_ID
           FROM ASV_CB_ACCOUNT
           WHERE CB_ACCOUNT_COMMON_INSURER_ID IS NOT NULL
           GROUP BY
             CB_ACCOUNT_COMMON_INSURER_ID) trololo ON trololo.CB_ACCOUNT_COMMON_INSURER_ID = ASV_GLOBAL_INSURER
    .MAIN_GLOBAL_INSURER_ID
  GROUP BY OPFR_CODE)
GROUP BY OPFR_CODE;