Discuz! info: MySQL Query Error
User: cepsc
Time: 2007-2-2 9:32pm
Script: /bbs/forumdisplay.php
SQL: SELECT DISTINCT p.authorid AS dotauthor, t.*, p.rate FROM cdb_threads t LEFT JOIN cdb_posts p ON (t.tid=p.tid AND p.authorid='1')
LEFT JOIN cdb_posts p USING(tid, dateline)
WHERE t.tid IN (12,205,429,881,991,361,362,349,348,359,363,357,360,364) AND t.displayorder IN (2, 3)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 0, 14
Error: Not unique table/alias: 'p'
Errno.: 1066
Similar error report has beed dispatched to administrator before.
提示这个错误! |