SELECT * FROM tbl_job WHERE 1=1 and status = '1' ORDER BY posted_date DESC
Total- Vacancies:
Job Title
Employer
Location
Expiry date
Posting Date
Veterinary Technician