select 
  obpos_appl0_.EM_Obcfr_Isblockchained as col_0_0_, 
  coalesce(obcfrticke1_.Seqno, 0) as col_1_0_, 
  obcfrticke1_.Hash as col_2_0_, 
  '342fdjks-fs_dsf_dfasdf+dfasf#dfsdf$ddsa df%dfd SE78/dfsdf*~ DsdsAPSnSWmsasw2xx2kqlduKksISMd  poe$sa-Kysw784s80021s2 df--p1s0FINys2s~tar3oz' as col_3_0_, 
  (
    select 
      coalesce(
        max(obcfr_bloc2_.Seqno), 
        0
      ) 
    from 
      OBCFR_BlockchainIssue obcfr_bloc2_ 
    where 
      obcfr_bloc2_.Entity = $1 
      and coalesce(
        obcfr_bloc2_.Obpos_Applications_ID, 
        obcfr_bloc2_.AD_Client_ID
      )= $2
  ) as col_4_0_ 
from 
  OBPOS_APPLICATIONS obpos_appl0_ 
  left outer join OBCFR_Ticket obcfrticke1_ on obpos_appl0_.Obpos_Applications_ID = obcfrticke1_.Obpos_Applications_ID 
where 
  obpos_appl0_.Obpos_Applications_ID = $3 
  and coalesce(obcfrticke1_.Seqno, 0)= coalesce(
    (
      select 
        max(obcfr_tick3_.Seqno) 
      from 
        OBCFR_Ticket obcfr_tick3_ 
      where 
        obcfr_tick3_.Obpos_Applications_ID = $4
    ), 
    0
  )