CiviCRM Community Forums (archive)

I have created a view to show contact information for targets of an activity. All of the contact details render correctly when I select the relationship EXCEPT the phone details. The SQL query appears to be valid:

SELECT civicrm_activity.id AS id,
   civicrm_activity.subject AS civicrm_activity_subject,
   civicrm_contact_civicrm_activity_target.sort_name AS civicrm_contact_civicrm_activity_target_sort_name,
   civicrm_contact_civicrm_activity_target.id AS civicrm_contact_civicrm_activity_target_id,
   civicrm_contact_civicrm_activity_target__civicrm_email.email AS civicrm_contact_civicrm_activity_target__civicrm_email_email,
   civicrm_phone.phone AS civicrm_phone_phone,
   civicrm_contact_civicrm_activity_target__civicrm_address.street_address AS civicrm_contact_civicrm_activity_target__civicrm_address_street_address,
   civicrm_contact_civicrm_activity_target__civicrm_address.supplemental_address_1 AS civicrm_contact_civicrm_activity_target__civicrm_address_supplemental_address_1,
   civicrm_contact_civicrm_activity_target__civicrm_address.city AS civicrm_contact_civicrm_activity_target__civicrm_address_city,
   civicrm_address.state_province_id AS civicrm_address_state_province_id,
   civicrm_contact_civicrm_activity_target__civicrm_address.postal_code AS civicrm_contact_civicrm_activity_target__civicrm_address_postal_code
 FROM `woolman_civicrm`.civicrm_activity civicrm_activity
 LEFT JOIN `woolman_civicrm`.civicrm_activity_target civicrm_activity_target ON civicrm_activity.id = civicrm_activity_target.activity_id
 LEFT JOIN `woolman_civicrm`.civicrm_contact civicrm_contact_civicrm_activity_target ON civicrm_activity_target.target_contact_id = civicrm_contact_civicrm_activity_target.id
 LEFT JOIN `woolman_civicrm`.civicrm_email civicrm_contact_civicrm_activity_target__civicrm_email ON civicrm_contact_civicrm_activity_target.id = civicrm_contact_civicrm_activity_target__civicrm_email.contact_id
 LEFT JOIN `woolman_civicrm`.civicrm_contact civicrm_contact ON civicrm_activity.source_contact_id = civicrm_contact.id
 LEFT JOIN `woolman_civicrm`.civicrm_phone civicrm_phone ON civicrm_contact.id = civicrm_phone.contact_id AND civicrm_phone.phone_type_id = 1
 LEFT JOIN `woolman_civicrm`.civicrm_address civicrm_contact_civicrm_activity_target__civicrm_address ON civicrm_contact_civicrm_activity_target.id = civicrm_contact_civicrm_activity_target__civicrm_address.contact_id
 LEFT JOIN `woolman_civicrm`.civicrm_address civicrm_address ON civicrm_contact.id = civicrm_address.contact_id
 WHERE (civicrm_activity.activity_type_id in ('33')) AND (civicrm_activity.id = 7084)
   ORDER BY civicrm_contact_civicrm_activity_target_sort_name ASC
Has anybody else had a similar problem? I have checked to make sure that there is phone data for at least one of the contacts even though all contacts have 'empty' as the value for phone.