---

'<a target="_blank" href="view?viewCode=Client_list&id='
  || COALESCE(contract.individual_id, ind.id, td.individual_id, apdi.individual_id) || '">'
|| concat_ws(' ',
     COALESCE(ind.last_name,  apdi.last_name),
     COALESCE(ind.first_name, apdi.first_name),
     COALESCE(ind.middle_name, apdi.middle_name))
|| '</a>' AS client_full_name