I have a query that is joining multiple tables. I have it optimized rather well, except for one table. I can’t for the life of me figure out why that table is not using the pk as the key. It is causing the query to filesort and use a temp table, changing the query time from 0.003s to 23s, obviously too long.
Attached is a file with the database and query details.
Any assistance is greatly appreciated, for I don’t know what it could be.