Discuz! info: MySQL Query Error
Time: 2010-9-9 7:53pm
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(12944,12945,12942,12943) AND t.lastpost>='1281614034' AND lastpost>='1252497234' 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.