PlugNT.App.UCenter.BLL.UMessage
2013-9-9 17:17:02:

select a.*,b.username as u_username,b.email,b.pic, from ucl_message as a left join cms_user as b on a.user_id=b.id and a.[type]=-1
