我出错了啦。。。
晕了。。。
Discuz! info: MySQL Query Error
User: MDBBS
Time: 2009-1-8 11:50am
Script: /bbs/index.php
SQL: SELECT attach.*,t.tid,t.fid,t.digest,t.author,t.subject,t.displayorder
FROM `[Table]attachments` attach
INNER JOIN `[Table]threads` t
ON `t`.`tid`=`attach`.`tid` AND `displayorder`>='0'
WHERE `attach`.`dateline`>=1228794652 AND `attach`.`readperm`='0' AND `attach`.`price`='0'
AND `attach`.`isimage`='1'
GROUP BY `attach`.`tid`
ORDER BY `attach`.`dateline` DESC
LIMIT 0,5;
Error: Column 'displayorder' in on clause is ambiguous
Errno.: 1052 |