SELECT FIRST 1
    b.id,
    b.pfjsz
FROM u_bank_t b
WHERE b.ugyf_id = 0 AND
      b.utalasi_ktg_opt = 'I' AND
      b.pfjsz IS NOT NULL AND
      CHAR_LENGTH(REPLACE(b.pfjsz, '-', '')) >= 8 AND
      CAST('TODAY' AS DATE) BETWEEN COALESCE(b.ervkezd, CAST('TODAY' AS DATE)) AND COALESCE(b.ervveg, CAST('TODAY' AS DATE)) AND
      EXISTS(SELECT
                 1
             FROM gl_mnb_bic bic
             WHERE bic.bic_code = 'KELRHUHBABC' AND
                   bic.branch_office_code = SUBSTRING(REPLACE(b.pfjsz, '-', '') FROM 1 FOR 8))
ORDER BY b.sorrend