[jscieza]

I ran this:

SELECT *
FROM `subscribethread`
ORDER BY `subscribethread`.`userid` ASC
LIMIT 0 , 30

And got this.

It looks like the subscribethread table doesn't have a timestamp column so how to compare against the threadread table?

If I read the thread then the notification disappear (as designed). Issue here is that after marking all threads as read (mark forums as read) the notifications for subscribed threads don't disappear.