select top 3 *, as itemname,item.english as itemenglish, as itemauthor,item.userid as itemuserid,item.username as itemusername,item.authorenglish as authorenglish,'' as wisdomurl,'' as itemurl,'' as authorurl,'' as hasfull from Wisdom left join item on where 1=1 and wisdom.length<N'50' and ('樂小米' or N'樂小米' ) and (wisdom.usersubmit=0 or wisdom.usersubmit=2 ) and (item.usersubmit=0 or item.usersubmit=2 ) order by newid()

Transaction (Process ID 91) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.