select distinct a.Name,a.ModifiedDate,b.*,c.Abstract,c.Picture as userPicture,d.Title as judjTitle
from tbl_userregister as a
left join tbl_judjuser as b
on a.Id=b.UserRegId
left join tbl_userproperty as c
on a.Id=c.UserId
left join tbl_judgment as d
on b.JudjId=d.Id
where b.UserRegId='105' and b.JudjId ='4'
order by b.CreateDate asc