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 ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results