select top 3 *,Item.name as itemname,item.english as itemenglish,item.author 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 Wisdom.itemid=item.id where 1=1 and wisdom.length<N'50' and ( wisdom.author=N'樂小米' or item.author= 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.