select jobs.*,company_detail.company_name,company_detail.image,company_detail.company_background from jobs INNER JOIN company_detail ON jobs.employer_id = company_detail.employer_id where jobs.status='1' and jobs.category = 'Pharmaceuticals' order by jobs.created_at DESC
