ERROR: Transaction (Process ID 107) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. QUERY: SELECT b.BasicId, Lostijd, bName, bBrand, b.bSubName FROM BasicModule b,BasicModulexCategories x,Categories c WHERE b.SiteId=288 AND b.LanguageId=31 AND b.BasicId = x.BasicId AND x.CategoryId = c.CategoryId AND c.CategoryId = 10086 AND b.Active = 1 AND CAST(b.bStartDate AS DATE) = CAST(GETDATE() AS DATE)