Change subselects to left joins

Fixes #56

`select_nodes_from_bbox` remains using a `NOT IN` until #68 is figured out