- [Type] 查询语句错误
- [1016] Can't open file: './discuzx/common_member_profile.frm' (errno: 24)
- [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 ,
mm.magicid
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)
LEFT JOIN common_member_magic mm ON mm.uid=m.uid AND mm.num=1 AND mm.isuse=1
WHERE m.uid IN ('8384569','505837','2609930','2766483','6120884','1411215','2342373','7302514','5852793','9113016','1538753','1973943','9485470','9475472','9290254','5980289','924742','4053773','7525440','7159217')
|