Error info: MySQL Query Error

Time: 2010-9-9 10:02am
SQL: select id,nickname,passwd,email,username,gender,birthday,telephone,usertel,msn,qq,country,province,city,area,address,zipcode,content,question,answer,carts,logins,dateline,shopid,nowip,lastip,nowlogin,lastlogin,score,prestore,flag,vipdate,ifsystem from shopuser where id='0' and shopid= limit 1
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 'limit 1' at line 1
Errno.: 1064