Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
contact_objid	LONG	int				USER_DEFINED
contract_objid	LONG	int				USER_DEFINED
e_mail	CHAR	varchar		80		USER_DEFINED
fax_number	CHAR	varchar		20		USER_DEFINED
first_name	CHAR	varchar		30		USER_DEFINED
last_name	CHAR	varchar		30		USER_DEFINED
phone	CHAR	varchar		45		USER_DEFINED
site_id	CHAR	varchar		80		USER_DEFINED
site_name	CHAR	varchar		80		USER_DEFINED
site_objid	LONG	int				USER_DEFINED
status	LONG	int				USER_DEFINED
title	CHAR	varchar		30		USER_DEFINED

SQL:

SELECT distinct
contract.objid AS contract_objid,
contact.objid AS contact_objid, contact.first_name, contact.last_name, contact.phone, contact.fax_number,
contact.title, contact.status, contact.e_mail,
site.objid AS site_objid, site.name AS site_name, site.site_id
FROM
table_contract contract
INNER JOIN mtm_contact2_contract1 AS mtm1 ON contract.objid = mtm1.contract2contact
INNER JOIN table_contact contact ON contact.objid = mtm1.caller2contract
INNER JOIN table_contact_role contact_role ON contact.objid = contact_role.contact_role2contact
INNER JOIN table_site site ON site.objid = contact_role.contact_role2site