gistfile1.txt

select
	personlink0_.guid as guid1_99_,
	personlink0_.createdTs as createdT2_99_,
	personlink0_.updatedTs as updatedT3_99_,
	personlink0_.provider_guid as provide10_99_,
	personlink0_. timestamp as timestam4_99_,
	personlink0_.child_guid as child_g11_99_,
	personlink0_.link_create_date as link_cre5_99_,
	personlink0_.deleted as deleted6_99_,
	personlink0_.deleted_by_provider as deleted_7_99_,
	personlink0_.link_end_date as link_end8_99_,
	personlink0_.link_type as link_typ9_99_,
	personlink0_.parent_guid as parent_12_99_
from
	person_link personlink0_
left outer join person person1_ on personlink0_.parent_guid = person1_.guid
left outer join person person2_ on personlink0_.child_guid = person2_.guid
where
	(person1_.guid is null)
and(person2_.guid is null)