[HossMon]

Hey Abe could you read my post here plz
https://vborg.vbsupport.ru/showpost....&postcount=602

I'm running 3.6.9 and I think I may have found the issue...
Ok here's Query

SELECT *
FROM thread AS thread
LEFT JOIN force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '1')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1233786721') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-6-%') AND (force_read_forums = '') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC

But then I notice this for the force_read_users table...

1 SIMPLE force_read_users eq_ref PRIMARY PRIMARY 8 const,bst_db.thread.threadid 1 Using where; Using index; Not exists

Using where; Using index; Not exists

I believe that is what is driving MySQL nuts