SELECT p.id as pid,product_name,company_id,location,p.created_at as job_created,product_type FROM job_product as p JOIN cateogry as cat ON cat.cat_id IN (p.category) JOIN job_role_function as r ON p.j_role = r.id JOIN job_companies_new as c ON p.company_id = c.id JOIN job_product_type as t ON p.product_type = t.id left join all_cities as aci on p.location = aci.city_name WHERE p.status in ('active', 'expire') and ( p.location LIKE 'ras%' or p.location LIKE 'al%' or p.location LIKE 'khaimah%' ) order by pid desc LIMIT 0,10
46 jobs for You
Make the most out of jobaaj by registering for free
Set Personalised Job Alerts
An OTP is sent to your email.