Transaction (Process ID 6812) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.SELECT top 1 WebRecord.ID AS wrid,(select top 1 description from radiochannels WITH (NOLOCK) where id=WebRecord.langid) as channelid, WebRecord.Title, WebRecord.Abstract, WebRecord.Description, WebRecordAttach.AttachID AS attachid FROM WebRecord WITH (NOLOCK) INNER JOIN WebRecordAttach WITH (NOLOCK) ON WebRecord.ID = WebRecordAttach.WFID WHERE (WebRecord.Active = 1) AND (WebRecord.BeginDate < GETDATE()) AND (WebRecord.ItemType = 26) AND (WebRecord.PlanID IN (SELECT PlanID FROM PLNvalidplan WITH (NOLOCK) where (LifeType = '017607') AND (PlanFormat = 26))) AND (WebRecordAttach.TypeID = 45) ORDER BY WebRecord.groupid desc