SELECT u, t
			FROM Entities\User u
			LEFT JOIN u.time_off t WITH (
				t.approved = true
				AND ((:start_date BETWEEN t.start_date AND t.end_date) OR (:end_date BETWEEN t.start_date AND t.end_date)
				OR (t.start_date BETWEEN :start_date AND :end_date) OR (t.end_date BETWEEN :start_date AND :end_date))
			)
			WHERE u.company = :company