LEFT JOIN sAddresses cond on aDates.conductor_ID = cond.ID LEFT JOIN sAddresses orch on aDates.orchestra_ID = orch.ID