select t1.catid, t1.catname, t1.slug_url, t1.slugpath, case when isnull(mc.parentcatid,0) = 2606 then '' else mcp.slug_url end pslug_url from dbo.mt360peak_cat_heir(1720, 1) t1 join mt360peak_category mc on mc.catid = t1.catid left join mt360peak_category mcp on mc.parentcatid = mcp.catid order by t1.seqid desc : Transaction (Process ID 130) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.