left joining tickets to properties