到三级搜索的时候出现错误,提示如下:
•[Type] 查询语句错误
•[1054] Unknown column 'mp.district' in 'where clause'
•[Query] SELECT m.uid,m.username,mp.gender,mp.affectivestatus,mp.resideprovince,mp.residecity FROM common_member_profile mp LEFT JOIN common_member m ON m.uid = mp.uid WHERE m.status='0' AND mp.resideprovince = '山东省' AND mp.residecity = '烟台市' AND mp.district = '开发区' AND 1=1 ORDER BY m.uid DESC limit 0,20