SQL: SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM [Table]attachments attach LEFT JOIN [Table]threads t ON t.displayorder>=0 AND t.tid=attach.tid WHERE attach.readperm='0' AND displayorder>='0' AND filetype='image/pjpeg' GROUP BY attach.tid ORDER BY attach.dateline DESC LIMIT 100
Error: Column 'displayorder' in where clause is ambiguous
Errno.: 1052
Similar error report has beed dispatched to administrator before.
SQL: SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM attachments attach LEFT JOIN threads t ON t.displayorder>=0 AND t.tid=attach.tid WHERE attach.readperm= ...