Select Code to Download

I have three tables:

...
But I have not figured out an efficient way, in a single query, to fin
+d titles that do NOT have a particular token.

Any advice?