MySQL Error
Message: MySQL Query Error
SQL: SELECT *,substring(now(), 1, 4) - sf.birthyear as age,if(1774647230-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 <=2006 and birthyear >=1992 and field_1 >=130以下 and field_1 <=168 and (resideprovince ='黑龙江' or birthprovince ='黑龙江') and (residecity ='鸡西' or birthcity ='鸡西') 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 '\xD2\xD4\xCF\xC2 and field_1 <=168 and (resideprovince ='\xBA\xDA\xC1\xFA\xBD\xA' at line 1
Errno.: 1064
Click here to seek help.