select
    j.job_id,boss_id,company_id,post_time,salary,job_city
from
    deliver_record d right join
    job_info j 
on
    d.job_id = j.job_id
and
    resume_if_checked = 1
order by boss_id