- [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 ('4826475','6537179','6306218','5787183','6293663','5708800','6805973','3184270','6991952','3968406','6995659','6221713','2237402','6996087','5844618','2842342','1039848','1414021','2049277','1110914')
|