[djwins]

Is this 3.6 only? I'm on 3.5.4 and get this mysql error:

Invalid SQL:

## GET LATEST THREADS ##
SELECT thread.*, post.pagetext AS preview
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN post AS post ON(post.postid = thread.lastpostid)
WHERE open <> 10 AND thread.lastpostid > 0
AND forumid NOT IN (0,42)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 10;

MySQL Error : Unknown column 'thread.lastpostid' in 'where clause'
Error Number : 1054

EDIT: Yeah 'thread.lastpostid' is new in 3.6