SELECT el.GUID, el.LanguageGUID, e.[DATE]
        FROM tbl_Publication e
        LEFT OUTER JOIN tbl_PublicationLang el
            ON e.Guid = el.Guid
            WHERE e.RecordStatus = el.RecordStatus
            AND el.RecordStatus = @RecordStatus
            AND e.RecordStatus = @RecordStatus
            AND e.TypeID = @TypeID
            AND el.LanguageGuid = @LanguageGuid
            AND el.IsDefaultLanguage = 1
            AND el.GUID IS NULL
The following stored procedures USE NOT IN instead OF LEFT OUTE