Message Title

Unable to find source-code formatter for language: jpql. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml

select mdf.id from MasterDataFileEntity mdf
 where mdf.dataImportStatus = 'SUCCESS'
   and mdf.metaData.country = :countryCode
   and mdf.metaData.transportMode = :transportMode
   and mdf.metaData.product = :product
   and mdf.importFinishedAt =
    (select max(mdf.importFinishedAt) from MasterDataFileEntity mdf
      where mdf.dataImportStatus = 'SUCCESS'
        and mdf.metaData.country = :countryCode
        and mdf.metaData.transportMode = :transportMode
        and mdf.metaData.product = :product)

select m1_0.id from PEL.pel_master_data_file m1_0
 where m1_0.data_import_status='SUCCESS'
   and m1_0.country_code=?
   and m1_0.transport_mode=?
   and m1_0.product=?
   and m1_0.import_finished_at=
    (select max(m2_0.import_finished_at) from PEL.pel_master_data_file m2_0
      where m2_0.data_import_status='SUCCESS'
        and m1_0.country_code=?
        and m1_0.transport_mode=?
        and m1_0.product=?)

The table alias for the subquery for all conditions joined by `and` is wrong, taken not from the subquery but from the main query.