SELECT distinct top 10 WebRecord.ID AS wrid, WebRecord.Title, WebRecord.abstract , WebRecordAttach.AttachID AS attachid, WebRecordAttach.TypeID AS attType, WebRecord.BeginDate, WebRecord.GroupID FROM WebRecord INNER JOIN PLNvalidplan ON WebRecord.PlanID = PLNvalidplan.PlanID INNER JOIN WebRecordAttach ON WebRecord.ID = WebRecordAttach.WFID INNER JOIN WebRecordProperty ON WebRecord.GroupID = WebRecordProperty.GRID WHERE (WebRecord.ItemType = 27) AND (WebRecord.LangID = 15) AND (WebRecord.Active = 1) AND (WebRecord.BeginDate < GETDATE()) AND (WebRecordAttach.TypeID = 38) AND (WebRecord.GroupID <> 286177) AND (PLNvalidplan.LifeType = N'084138') ORDER BY WebRecord.BeginDate DESC