Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
bug_objid	LONG	int				USER_DEFINED
id_number	CHAR	varchar		32		USER_DEFINED
link_type	CHAR	varchar		30		USER_DEFINED

SQL:

select b.objid as bug_objid, m.id_number, 'Duplicate Master' from table_bug b
inner join table_bug m on b.duplicate_bug2bug = m.objid
union all
select b.objid, m.id_number, 'Duplicate' from table_bug b, table_bug m
where b.objid = m.duplicate_bug2bug
union all
select b.objid, m.id_number, 'Replicate' from table_bug b
inner join table_bug m on b.cr_replicate2cr_master = m.objid
union all
select b.objid, m.id_number, 'Replicate Master' from table_bug b, table_bug m
where b.objid = m.cr_replicate2cr_master