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='49' and b.JudjId ='3' order by b.CreateDate asc
دانشجوي گرافيك علمي كاربردي نور هدايت حافظ(نياوران