select pv.StringValue, * from tbl_Identity i
left join tbl_PropertyValue pv on pv.ArtifactId=convert(binary(16),i.id)
--where i.AccountName='danzhang'
and pv.PropertyId=32
select * from tbl_PropertyDefinition
select pd.Name, * from tbl_PropertyValue pv left join tbl_PropertyDefinition pd on pv.PropertyId=pd.PropertyId
where pv.StringValue='zhanghongjun@bjgreatsoft.com'