- [Type] 查询语句错误
- [1317] Query execution was interrupted
- [Query] SELECT m.uid, m.username, m.groupid, m.adminid, m.regdate, m.credits, m.email, m.status AS memberstatus,
ms.lastactivity, ms.lastactivity, ms.invisible AS authorinvisible,
mc.*, mp.gender, mp.site, mp.icq, mp.qq, mp.yahoo, mp.msn, mp.taobao, mp.alipay,
mf.medals, mf.sightml AS signature, mf.customstatus, mh.privacy , mp.realname AS realname, mp.gender AS gender, mp.birthyear AS birthyear, mp.birthmonth AS birthmonth, mp.birthday AS birthday, mp.constellation AS constellation, mp.zodiac AS zodiac, mp.telephone AS telephone, mp.mobile AS mobile, mp.idcardtype AS idcardtype, mp.idcard AS idcard, mp.address AS address, mp.zipcode AS zipcode, mp.birthprovince AS birthprovince, mp.birthcity AS birthcity, mp.birthdist AS birthdist, mp.birthcommunity AS birthcommunity, mp.resideprovince AS resideprovince, mp.residecity AS residecity, mp.residedist AS residedist, mp.residecommunity AS residecommunity, mp.graduateschool AS graduateschool, mp.education AS education, mp.company AS company, mp.occupation AS occupation, mp.position AS position, mp.revenue AS revenue, mp.affectivestatus AS affectivestatus, mp.lookingfor AS lookingfor, mp.bloodtype AS bloodtype, mp.alipay AS alipay, mp.qq AS qq, mp.msn AS msn, mp.taobao AS taobao, mp.site AS site, mp.bio AS bio, mp.interest AS interest
FROM common_member m
LEFT JOIN common_member_field_forum mf USING(uid)
LEFT JOIN common_member_status ms USING(uid)
LEFT JOIN common_member_count mc USING(uid)
LEFT JOIN common_member_profile mp USING(uid)
LEFT JOIN common_member_field_home mh USING(uid)
WHERE m.uid IN ('8027','3800','12129','1873','11008','12096','4441','1771','12182','10970','11032','11049','3735','10861','8230')
|