- [Type] 查询语句错误
- [1016] Can't open file: './discuzx/common_member_magic.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 ('1064182','2133928','2059313','934629','2815700','2754187','3616577','2395261','2820511','3291375','2262425','1030263')
|