WITH mydp AS
(
    SELECT
      opbank.PRIORITY,
      adr.UNIQUEID         AS DELIVERYPOINTUNIQUEID,
      adr.code             AS DELIVERYPOINTCODE,
      bp.FISCALCODE,
      --BUSINESSPARTNER
      bp.ADDRESSPHONENUMBER,
      bp.POSTALCODE,
      bp.TOWN,
      --ORDERPARTNER
      --   CUSTOMERSUPPLIERCOMPANYCODE,
      --   CUSTOMERSUPPLIERTYPE,
      --   CUSTOMERSUPPLIERCODE,
      --
      opbank.BBAN          AS OPBankPriority1_BBAN,
      BANK.LONGDESCRIPTION AS BANK_1_LONGDESCR,
      opbank.BIC           AS OPBankPriority1_BIC,
      opbank.IBAN          AS OPBankPriority1_IBAN
    FROM ADDRESS adr LEFT JOIN BUSINESSPARTNER bp ON
                                                    adr.ORIGINBUSINESSPARTNERNUMBERID = bp.NUMBERID
      LEFT OUTER JOIN ORDERPARTNER op ON
                                        op.ORDERBUSINESSPARTNERNUMBERID = bp.NUMBERID
      LEFT JOIN ORDERPARTNERBANK opbank ON
                                          op.CUSTOMERSUPPLIERCOMPANYCODE = opbank.ORDPRNCSMSUPPLIERCOMPANYCODE AND
                                          op.CUSTOMERSUPPLIERTYPE = opbank.ORDPRNCUSTOMERSUPPLIERTYPE AND
                                          op.CUSTOMERSUPPLIERCODE = opbank.ORDPRNCUSTOMERSUPPLIERCODE
      LEFT JOIN BANK ON
                       opbank.BANKCODE = BANK.CODE AND opbank.BANKBRANCHCODE = BANK.BRANCHCODE
)
SELECT
  s3.PRIORITY,
  s3.DELIVERYPOINTUNIQUEID,
  s3.DELIVERYPOINTCODE,
  s3.FISCALCODE,
  s3.ADDRESSPHONENUMBER,
  s3.POSTALCODE,
  s3.TOWN,
  s3.OPBankPriority1_BBAN,
  s3.BANK_1_LONGDESCR,
  s3.OPBankPriority1_BIC,
  s3.OPBankPriority1_IBAN
FROM
  (SELECT DISTINCT
     DELIVERYPOINTUNIQUEID,
     DELIVERYPOINTCODE
   FROM mydp) s1
  JOIN
  (
    SELECT DISTINCT
      DELIVERYPOINTUNIQUEID,
      DELIVERYPOINTCODE,
      MIN(PRIORITY)
    FROM mydp
    GROUP BY DELIVERYPOINTUNIQUEID, DELIVERYPOINTCODE) s2 ON
                                                            s1.DELIVERYPOINTUNIQUEID = s2.DELIVERYPOINTUNIQUEID AND
                                                            s1.DELIVERYPOINTCODE = s2.DELIVERYPOINTCODE
  JOIN mydp s3 ON
                 s2.DELIVERYPOINTUNIQUEID = s3.DELIVERYPOINTUNIQUEID AND
                 s2.DELIVERYPOINTCODE = s3.DELIVERYPOINTCODE