I don't know if you can use a JOIN for that.
You combine two or more tables with a JOIN, and if that JOIN doesn't find something in one of the tables which matches the WHERE criteria, the entire query doesn't return anything if I am not mistaken. So you would have to enter something into that table thread_read (or however you want to call it) for every thread there is on your forum.

This is a good feature...

I REALLY HATE how vbulletin uses cookies for this... If I read a thread i like the stupid ON gif to turn off!!!

yet you have to wait 15 minutes for timeout so it will be marked as read.. isn't that stupid?! When online it's hard to see which forum you have read because the ON gif does not switch to OFF.

I wish vbulletin would have a better system for read/unread threads and forums because the current system really sucks.

I like the idea your trying to do though,.. only if someone could put some sense into vbulletin team to find a workaround for this.

I just posted optimized version here :)
https://vborg.vbsupport.ru/showthrea...threadid=47101
Now it do no add extra db request for each thread on forumdisplay :)

No Files Uploaded.