select
a.applicant_without_request x_applicant_without_request,
a.phone_number x_phone_number,
a.estimated_onboard_date x_estimated_onboard_date,
a.supervisor_id x_supervisor_id,
a.x_onboardaddress x_x_onboardaddress,
a.x_jobtitle x_x_jobtitle,
a.x_salary x_x_salary,
a.x_recruitment_sources x_x_recruitment_sources,
c.x_education_type x_x_education_type,
c.education_start x_education_start,
c.education_end x_education_end,
c.school x_school,
c.profession x_profession,
c.education_background x_education_background,
c.academic_degree x_academic_degree,
c.x_school_classes x_x_school_classes,
c.certificate_code x_certificate_code,
c.x_verification x_x_verification,
c.the_highest_degree x_the_highest_degree,
d.x_foreignlanguages x_x_foreignlanguages,
d.x_languageslevel x_x_languageslevel,
d.x_proficiency x_x_proficiency,
d.x_languagenotes x_x_languagenotes,
e.certificate x_certificate,
e.start_date x_start_date_ct,
e.end_date x_end_date_ct,
e.training_id x_training_id,
f.company x_company,
f.industry x_industry,
f.start_date x_start_date_work,
f.end_date x_end_date_work,
f.department x_department,
f.job x_job,
f.referee x_referee,
f.referee_contact x_referee_contact
from hr_recruitment_enroll a
left join hr_applicant b
on a.applicant_id=b.id
left join applicant_education c
on b.id=c.applicant_id
left join x_builder_language_model d
on b.id = d.x_code
left join applicant_train_experience e
on e.applicant_id = b.id
left join hr_employment_history f
on f.applicant_id=b.id