MySQL Error
Message: MySQL Query Error
SQL: SELECT *,substring(now(), 1, 4) - sf.birthyear as age,if(1780429584-lastlogin<24*3600 and ((groupid=3 or groupid=11) or namestatus=1),1,0) as viptop,if(groupid=3 or groupid=11,1,0) as isvip,LENGTH(CONCAT(if(birthyear>0,'1',''),if(birthprovince!='','1',''),if(field_4!='','1',''),if(field_5!='','1',''),if(field_48!='','1',''))) as prolen FROM uchome_spacefield sf,uchome_space s WHERE s.groupid not in ('4','8','9','10','11','17','19','66') and (privacy like '%"index";i:0;%' or privacy='') and flag!='-1' and sf.uid=s.uid and avatar=1 and sex= 2 and birthyear <=2004 and birthyear >=2026 and field_1 >=165 and field_1 <=请选择 and (resideprovince ='湖南' or birthprovince ='湖南') order by avatar desc,viptop desc,prolen desc,lastlogin desc,field_78 desc,namestatus desc,isvip desc,experience desc limit 50
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 '\xE8\xAF\xB7\xE9\x80\x89\xE6\x8B\xA9 and (resideprovince ='\xE6\xB9\x96\xE5\x8D\' at line 1
Errno.: 1064
Click here to seek help.