Discuz! info: MySQL Query Error
Time: 2010-9-9 7:40pm
Script: /index.php
SQL: SELECT t.*,m.nickname,mf.nickname as lastnickname FROM [Table]threads t left join [Table]memberfields m on t.authorid=m.uid
left join [Table]members me on t.lastposter=me.username left join [Table]memberfields mf on me.uid=mf.uid
WHERE fid in(12969,12970,12971,12972) AND t.lastpost>='1281613224' AND lastpost>='1281440424' AND t.displayorder IN (0, 1, 2, 3)
ORDER BY t.displayorder DESC, t.lastpost DESC
LIMIT 0, 50
Error: Column 'lastpost' in where clause is ambiguous
Errno.: 1052
Similar error report has been dispatched to administrator before.