SELECT jobs_id,jobs_name,b.emp_name,
DATE_FORMAT(a.jobs_start_view,'%Y%m%d ') as jobs_day ,
DATE_FORMAT(a.jobs_start_view, '%Y/%m/%d %H:%i') as jobs_sort_dt ,
jobs_state,jobs_country,city ,country_desc,emp_logo,
jobs_exp_f,jobs_exp_t ,jobs_exp_flag ,jobs_view,
jobs_degree_level,
case when degree_sort='5' then 'ปวส.'
when degree_sort='6' then 'ปวช'
when degree_sort ='7' then 'ม.ปลาย'
when degree_sort ='8' then ' ม.ต้น'
else degree_desc end as degree_desc
,b.emp_type
FROM jobs a LEFT JOIN city on jobs_state=city_skey
left join country d ON jobs_country=d.country_cd
left join degree_level ON jobs_degree_level=degree_sort
,employer b
where jobs_emp_id = b.emp_id
and jobs_status = 'A'
and ( DATE_FORMAT(jobs_start_view,'%Y-%m-%d') <= '2024-04-26'
and DATE_FORMAT(jobs_end_view,'%Y-%m-%d') >= '2024-04-26'
) and (jobs_state ='159') order by jobs_sort_dt desc?page=1 LIMIT 0, 35