Unknown column 'cate_pr' in 'where clause': SELECT count(*) FROM user_company JOIN user_company_multi ON user_company.usc_id = user_company_multi.usc_id WHERE 1  AND cate_pr = 40