select concat(tam_fname,' ',tam_lname) as arcnmae,tpd_propdate,tpd_propsdesc,tpd_pname,tpd_status,tpd_propid,tpb_btype,
tpad_status,tpad_apptype from tp_pbuild_detail
inner join tp_proposal_detail on tpd_org_id=tpb_org_id and tpd_loc_id=tpb_loc_id and tpd_propid=tpb_propid inner join tp_architect_master on tpd_org_id=tam_org_id and tpd_loc_id=tam_loc_id and tpd_archid=tam_id
inner join tp_application_detail on tpd_propid=tpad_propid where tpad_apptype='O' and tpad_status='R' and DATE_FORMAT(tpad_appdate,'%Y')='2024'