...
tov_doc adoc (nolock)
inner join Tov (nolock) on tov.id_doc = adoc.id_doc
inner join sstatedoc (nolock) on sstatedoc.idStateDoc = adoc.id_status_doc
inner join spr_kontr sk (nolock) on sk.id_kontr = adoc.id_kontr_db and sk.Retail = 1 –1 --- розничный клиент
inner join spr_kontr shipk (nolock) on shipk.id_kontr = adoc.idShipper
inner join spr_kontr d (nolock) on d.id_kontr = adoc.id_firm
inner join rKontrTerritory (nolock) on rKontrTerritory.id_kontr = sk.id_kontr
inner join sTerritory (nolock) on sTerritory.idTerritory = rKontrTerritory.idTerritory and sTerritory.idTerritory = 7
...