Optimise queries by using "where exists" instead of joins if possible

[hylkevds]

Using exists instead of a full join is usually faster, but it may be difficult to determine if exists can be used. See: https://www.postgresql.org/docs/current/functions-subquery.html#FUNCTIONS-SUBQUERY-EXISTS