[CODE]select top 32 T1.ID,T2.Title,T2.Length,T2.ndatetime,T2.Hits,T2.FaceIcon,T2.ChildNum,T2.BoardID,T2.GoodFlag,T2.Username,T2.ID,T2.TitleStyle,T3.ID,T3.TrueName from (LeadBBS_CollectAnc as T1 Left join LeadBBS_Announce as T2 on T1.AnnounceID=T2.ID) left join LeadBBS_User as T3 on T3.Id=T2.Userid where T1.UserID=2 and T1.ID<999999999 Order by T1.ID DESC[/CODE]