SELECT phpgw_contact_person.first_name || ' ' ||
	phpgw_contact_person.last_name || ' (' || 
	phpgw_contact_org.name || ')' AS id,
	phpgw_contact_person.title || ' ' ||
	phpgw_contact_person.first_name || ' ' ||
	phpgw_contact_person.last_name AS nome,
	phpgw_contact_org.name || ' - ' ||
	phpgw_contact_person.department AS ditta,
	phpgw_contact_addr.add1 || ' ' ||
	phpgw_contact_addr.postal_code || ' ' ||
	phpgw_contact_addr.city || ' (' ||
	phpgw_contact_addr.state || ') ' ||
	phpgw_contact_addr.country AS indirizzo,
	phpgw_contact_comm.comm_data AS telefono
FROM phpgw_contact, phpgw_contact_addr, phpgw_contact_comm,
	phpgw_contact_org, phpgw_contact_org_person, phpgw_contact_person
WHERE phpgw_contact_person.person_id = phpgw_contact.contact_id AND
phpgw_contact_person.person_id = phpgw_contact_org_person.person_id AND
	phpgw_contact_org_person.org_id = phpgw_contact_org.org_id AND
	phpgw_contact_org.org_id = phpgw_contact_addr.contact_id AND
phpgw_contact_addr.contact_id = phpgw_contact_comm.contact_id AND
((phpgw_contact.contact_type_id=1) AND (phpgw_contact.access='public') AND
(phpgw_contact_comm.comm_descr_id=4));


SELECT phpgw_contact_person.first_name || ' ' ||
	phpgw_contact_person.last_name || ' (' || 
	phpgw_contact_org.name || ')' AS id,
	phpgw_contact_comm.comm_data AS fax
FROM phpgw_contact, phpgw_contact_comm,
	phpgw_contact_org, phpgw_contact_org_person, phpgw_contact_person
WHERE phpgw_contact_person.person_id = phpgw_contact.contact_id AND
phpgw_contact_person.person_id = phpgw_contact_org_person.person_id AND
	phpgw_contact_org_person.org_id = phpgw_contact_org.org_id AND
	phpgw_contact_org.org_id = phpgw_contact_comm.contact_id AND
((phpgw_contact.contact_type_id=1) AND (phpgw_contact.access='public') AND
(phpgw_contact_comm.comm_descr_id=13));