Very slow join query

Databases
2

what does the EXPLAIN say? how are your WHERE conditions affecting the execution plan?