SELECT p.id as pid,product_name,hide_salary,experience_min,experience_max,skills,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 WHERE p.status in ('active', 'expire') order by pid desc LIMIT 0,10

jobs for You