Discuz! info: MySQL Query Error
Time: 2010-9-7 12:38pm
Script: /bbs/api/javascript.php
SQL: SELECT t.tid,t.fid,t.readperm,t.author,t.authorid,t.subject,t.dateline,t.lastpost,t.lastposter,t.views,t.replies,t.highlight,t.digest,t.typeid,t.sortid
FROM `[Table]threads` t INNER JOIN `[Table]forumrecommend` fc ON fc.tid=t.tid WHERE t.readperm='0'
AND t.fid IN ('19') AND `digest` IN ('1','2','3') AND `displayorder` IN ('1','2','3') AND t.dateline>=1283359102
AND t.displayorder>='0'
AND t.fid>'0'
ORDER BY t.views DESC
LIMIT 0,4;
Error: Column 'displayorder' in where clause is ambiguous
Errno.: 1052
Similar error report has been dispatched to administrator before.