提示这个(1052) Column 'fid' in order clause is ambiguous
SELECT ff.*, f.fid, f.name, f.threads, f.posts, f.todayposts, f.level as flevel FROM forum_forum f USE INDEX(fup_type) LEFT JOIN forum_forumfield ff ON ff.fid=f.fid WHERE f.fup IN ('212') AND f.type='sub' AND f.status=3 ORDER BY f.displayorder DESC, fid DESC LIMIT 0, 40 |