- [Type] 查詢語法錯誤
- [1052] Column 'displayorder' in on clause is ambiguous
- [Query] SELECT attach.*,t.tid,t.author,t.authorid,t.subject , f.name groupname
FROM `forum_attachment` attach
INNER JOIN `forum_thread` t
ON `t`.`tid`=`attach`.`tid` AND `displayorder`>='0'
LEFT JOIN forum_forum f ON t.fid=f.fid LEFT JOIN forum_forumfield ff ON f.fid = ff.fid
WHERE `attach`.`dateline`>='1321331474' AND `attach`.`readperm`='0' AND `attach`.`price`='0'
AND t.isgroup='1'AND `attach`.`isimage` IN ('1', '-1')
ORDER BY `attach`.`dateline` DESC
LIMIT 0,4;
|