SELECT SQL_CALC_FOUND_ROWS * FROM qb_hy_company WHERE 1 AND
levels=1 AND A.city_id IN ('1',0) ORDER BY levelstime DESC LIMIT 0,10Unknown column 'A.city_id' in 'where clause'1054
levels=1 AND A.city_id IN ('1',0) ORDER BY levelstime DESC LIMIT 0,10Unknown column 'A.city_id' in 'where clause'1054
未知列'A.city_id'在where子句别名 A 不存在!
你至少需要
SELECT SQL_CALC_FOUND_ROWS * FROM qb_hy_company A WHERE 1 AND
levels=1 AND A.city_id IN ('1',0) ORDER BY levelstime DESC LIMIT 0,10
levels=1 AND A.city_id IN ('1',0) ORDER BY levelstime DESC LIMIT 0,10即把qb_hy_company 起个别名为 A, qb_hy_company as A 或者qb_hy_company A,两种都可以A.city_id 相当于qb_hy_company.city_id