add LEFT join to attributes