There was an SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ( j.v_zhiwei like "%调色%" or cm.company_name like "%调色%" or c.v_name ' at line 1 - select count(*) cum from jobs j left join company_members cm on j.member_id=cm.member_id left join cities c on c.id = j.city_id where 1=1 and j.is_del = "N" and j.is_closed = "N" and j.member_id not in (1, 28158, 652632) and j.city_id not in and ( j.v_zhiwei like "%调色%" or cm.company_name like "%调色%" or c.v_name like "%调色%" )