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 ( c.name = 'HSBC' ) order by pid desc LIMIT 0,10
444 HSBC jobs for You
Make the most out of jobaaj by registering for free
Set Personalised Job Alerts
An OTP is sent to your email.