SELECT *,(SELECT TOP 1 sub FROM sys_v_zipcode WHERE zipcode=jobzip1) AS jobsub FROM job_m_basic WHERE disflag='1' AND datastatus='1' AND jobtype='1' AND sdate<='2026/05/06' AND edate>='2026/05/06' ORDER BY sdate DESC,jobzip1