select sbr_staff.*, sbr_office.name as office_name, sbr_office.telephone as office_phone from sbr_staff left outer join sbr_office on sbr_office.id = sbr_staff.lookup_sbr_office where sbr_staff.url like 'spencer-pinion' and sbr_staff.url not like '' and (sbr_staff.deleted is null or sbr_staff.deleted = 'False')