SQL: SELECT t.* ,m.regdate FROM threads t ,[Table]members m
WHERE t.authorid = m.uid AND t.fid='14' AND lastpost>='1239172302' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 29 Error: Column 'lastpost' in where clause is ambiguous Errno.: 1052