Discuz! info: MySQL Query Error
Time: 2024-4-19 5:22pm
Script: /forumdisplay.php
SQL: SELECT re.reward_price, re.tid, ff.fid, ff.name, t.* FROM [Table]threads t
LEFT JOIN [Table]forums ff ON ff.fid=t.fid
LEFT JOIN [Table]threads_reward re on re.tid=t.tid
WHERE t.dateline > (1713518526 - 3304800) AND t.fid not in(12,52,54,31,48,54,32,64,39,37,67,14,110) AND t.displayorder >= 0 AND lastpost>='1713432126' AND t.displayorder IN (0, 1, 2, 3, 4)
ORDER BY t.dateline DESC, t.dateline DESC
LIMIT 0, 60
Error: Column 'lastpost' in where clause is ambiguous
Errno.: 1052
Similar error report has been dispatched to administrator before.