SELECT DISTINCT
chb.ck_filename, chb.ck_reason, ' ' as reason , chb.ck_id, chb.ck_remarks, '
' pr_teuda, dls.degarrant,
trn.trdate ,trn.trvid ,plh.ph_name ,bsn.bu_name , dls.deid, chb.ck_trid
trid,trn.tramount, dls.debuid,bsn.bu_mobiles,plh.ph_phone,
chb.ck_created,emp.emp_name as sohen,plh.ph_id,
(
select gvpl.gvpl_descr  from gviya gv1, gviya_place gvpl where
gv1.gv_gvpl_id = gvpl.gvpl_id
and gv1.gv_id =
(select max(gviya.gv_id)  from gviya
where gv_trid = chb.ck_trid)
) as gv_place,