Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
contact_objid	LONG	int				USER_DEFINED
e_mail	CHAR	varchar				USER_DEFINED
first_name	CHAR	varchar				USER_DEFINED
last_name	CHAR	varchar				USER_DEFINED
phone	CHAR	varchar				USER_DEFINED
primary_site	LONG	int				USER_DEFINED
site	CHAR	varchar				USER_DEFINED
site_id	CHAR	varchar				USER_DEFINED
site_objid	LONG	int				USER_DEFINED
status	LONG	int				USER_DEFINED
update_stamp	CLK_TIME	datetime				USER_DEFINED
x_res1	CHAR	varchar				USER_DEFINED
x_res2	CHAR	varchar				USER_DEFINED
x_res3	CHAR	varchar				USER_DEFINED
x_res4	CHAR	varchar				USER_DEFINED
x_res5	CHAR	varchar				USER_DEFINED

SQL:

SELECT c.objid as contact_objid, s.objid as site_objid, c.first_name, c.last_name, c.phone, c.update_stamp,
s.name as site, s.site_id, r.primary_site, c.status as status, c.e_mail,
s.x_res1, s.x_res2, s.x_res3, s.x_res4, s.x_res5
FROM table_contact c
INNER JOIN table_contact_role r ON c.objid = r.contact_role2contact
INNER JOIN table_site s ON s.objid = r.contact_role2site
WHERE c.status = 0 AND r.primary_site = 1