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 as c ON p.company_id = c.id WHERE p.status in ('active', 'expire') and (p.f_area=16) order by pid desc

Consulting jobs for You