In general, when you want to make a slow SELECT ... WHERE faster, the first thing to check is whether or not you can add an index. All references between different tables should usually be done with ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results