select d.*,c.comp_full,h.event_name from event_d d inner join company c on d.comp_code=c.comp_code inner join event_h h on h.event_no=d.event_no left join pubcode_d p on d.Awardsbq=p.code and p.code_type='996' where d.status in ('05','07','06') and h.event_name='2021中国供应链金融优秀企业评选' and p.code_name like '%金融科技%'