The script is quite long, but here it is if you want to look at it.

The problematic join occurs in the WHERE NOT EXISTS subquery's first 2 tables;...