SELECT p.id as pid, product_name, hide_salary, experience_min, experience_max, salary_min, salary_max, skills, company_id, location, p.created_at as job_created, product_type FROM job_product as p LEFT JOIN function_area f ON f.id=p.f_area LEFT JOIN job_companies_new c ON c.id=p.company_id WHERE p.status in ('active', 'expire') and ( p.location REGEXP '(^|\\s|,|/)faridabad(/|,|\\s|$)' ) order by pid desc

jobs for You