ระดับการศึกษาที่จะสมัครเรียน
SELECT
levels.id AS level_id,
levels.`name` AS level_name,
course_types.id AS type_id,
course_types.`code` AS type_code,
course_types.`name` AS type_name,
job_groups.id AS group_id,
job_groups.`code` AS group_code,
job_groups.`name` AS group_name,
job_fields.id AS field_id,
job_fields.`id` AS field_id,
job_fields.`code` AS field_code,
job_fields.`name` AS field_name,
job_fields.image AS field_image ,
job_fields.image2 AS field_image2
FROM
job_fields
INNER JOIN job_groups ON job_fields.job_group_id = job_groups.id
INNER JOIN course_types ON job_groups.course_type_id = course_types.id
INNER JOIN levels ON course_types.level_id = levels.id WHERE levels.id = ''