Error: Transaction (Process ID 669) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [20018] (severity 13) [
                SELECT 
                    Mn_News.NumNews,
                    COALESCE(Mn_News_Traductions.Nz_TitreTraduction, Mn_News.Nz_Titre) AS Nz_Titre,
                    COALESCE(Mn_News_Traductions.Nz_ParagrapheTraduction, Mn_News.Nz_Paragraphe) AS Nz_Paragraphe,
                    Mn_News.IdAbo, 
                    Mn_News.Signature,
                    COALESCE(Mn_Rubriques_Traductions.Rub_NomTraduction, Mn_Rubriques.Rub_Nom) AS Rub_Nom,
                    Mn_Rubriques.NumRubriques,
                    Mn_News.Nz_DateD, 
                    Mn_News.Nz_Adresse, 
                    Mn_News.Nz_Focus, 
                    Mn_News.Nz_SourceType, 
                    Mn_News.Nz_Source, 
                    Adresses_pays.Pays, 
                    Utilitaires_Langues.NLangue_FR,
                    Mn_News.Nz_Langue, 
                    Mn_News.SaisiIdC, 
                    Mn_News.NumNewsletter,
                    Docs.DocName, 
                    Docs.IdExtension, 
                    Docs.WebLink, 
                    Docs.IdDoc, 
                    Docs.DocLocal, 
                    Docs.DocFileName, 
                    Docs.DocTailleKo, 
                    Docs.DocWidth, 
                    Docs.Docheight, 
                    Docs.SaisieDate, 
                    Docs.Date_Crea
                FROM imp_db.dbo.Mn_News
                    LEFT OUTER JOIN imp_db.dbo.Docs_Links 
                        ON Mn_News.NumNews = Docs_Links.IdLigne 
                        AND Docs_Links.IdTable = 2379 
                    INNER JOIN imp_db.dbo.Docs 
                        ON Docs_Links.IdDoc = Docs.IdDoc 
                    INNER JOIN imp_db.dbo.Mn_Rubriques 
                        ON Mn_News.NumRubriques = Mn_Rubriques.NumRubriques 
                    LEFT OUTER JOIN imp_db.dbo.Mn_News_Traductions 
                        ON Mn_News.NumNews = Mn_News_Traductions.NumNews 
                        AND Mn_News_Traductions.Nz_LangueTraduction = 1
                        AND Mn_News_Traductions.Valide = 1 
                    LEFT OUTER JOIN imp_db.dbo.Mn_Rubriques_Traductions 
                        ON Mn_Rubriques.NumRubriques = Mn_Rubriques_Traductions.NumRubriques 
                        AND Mn_Rubriques_Traductions.NumLangue = 1
                        AND Mn_Rubriques_Traductions.Valide = 1 
                    LEFT OUTER JOIN imp_db.dbo.Adresses_pays 
                        ON Adresses_pays.NumPays = Mn_News.Nz_Pays 
                    LEFT OUTER JOIN imp_db.dbo.Utilitaires_Langues 
                        ON Utilitaires_Langues.NumLangue = Mn_News.Nz_Langue
                WHERE 
                    Mn_News.NumNewsletter = 32
                    AND Mn_News.NumNzDt_Type = 2
                    AND Mn_News.NonValide = 0
                    AND (Mn_News_Traductions.Valide = 1 OR Mn_News_Traductions.Valide IS NULL)
                    AND Mn_News.NumNews = 6139
            ]