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 '%Fujairah%' OR jobs.city LIKE '%Fujairah%' order by jobs.created_at DESC