SELECT job_id,job_title_th as job_title FROM jobs WHERE active = 'Y' AND date(job_release_date) <= NOW()