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.location LIKE '%Ras%20al%20Khaimah%' OR jobs.city LIKE '%Ras%20al%20Khaimah%' order by jobs.created_at DESC
