SELECT DISTINCT p.id as pid,product_name,company_id,location,p.created_at as job_created,product_type,skills FROM job_product as p INNER JOIN job_role_function as r ON p.j_role = r.id INNER JOIN job_companies_new as c ON p.company_id = c.id INNER JOIN job_product_type as t ON p.product_type = t.id INNER JOIN cateogry as cat ON p.category LIKE CONCAT('%',cat.cat_id,'%') WHERE ( p.status = 'active' and ( p.product_name LIKE '%mba%' or p.product_name LIKE '%jobs%' ) or ( p.skills LIKE '%mba%' or p.skills LIKE '%jobs%' ) or ( c.name LIKE '%mba%' or c.name LIKE '%jobs%' ) or ( cat.cat_name LIKE '%mba%' or cat.cat_name LIKE '%jobs%' ) or ( r.job_role LIKE '%mba%' or r.job_role LIKE '%jobs%' ) ) order by pid desc LIMIT 0,10

13158 jobs for You