SELECT 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 = JOIN job_companies_new as c ON p.company_id = JOIN job_product_type as t ON p.product_type = left join all_cities as aci on p.location = aci.city_name WHERE p.status in ('active', 'expire') and ( p.product_name LIKE '%cs%' or p.product_name LIKE '%jobs%' or p.skills LIKE '%cs%' or p.skills LIKE '%jobs%' or LIKE '%cs%' or LIKE '%jobs%' or cat.cat_name LIKE '%cs%' or cat.cat_name LIKE '%jobs%' or r.job_role LIKE '%cs%' or r.job_role LIKE '%jobs%' ) order by pid desc LIMIT 0,10

6,275 Cs jobs for You

Make the most out of jobaaj by registering for free
Personalized Recommendation
Real-time Updates
Recruiters directly reach out
Boost Visibility