Changed to LEFT join because if a client doesn't have these fields, it will always return no data