select  * from mvOrgCatalogueBranches where OrganizationID = 3042 order by Leftkey

3042	9579	3	Раздел 1 Материалы строительные, дорожные и для реставрационно-восстановительных работ
3042	9580	4	1. Строительные и дорожные материалы
3042	9922	739	1.10. Нерудные материалы
3042	9940	784	Щебень гравийный, фракция, мм:

        Dim x As Integer = 1, iIsMaterial As Integer = IIf(mExport = ExportType.etPricesMat, 1, 0), oList As IEnumerable, iCatCount As Integer, iTotal As Integer
        If mOrganizationID = 0 Then
            Dim mvC As List(Of mvCatalogue) = (From v In db.mvCatalogue Where v.BranchPriceCount > 0 And v.Level > 2 And v.IsMaterialCatalogue = iIsMaterial Order By v.LeftKey).ToList
            iTotal  = db.mvCatalogue.Where(Function(v) v.BranchPriceCount > 0 And v.Level > 2 And v.IsMaterialCatalogue = iIsMaterial).Sum(Function(v) v.PriceCount).Value
            iCatCount = mvC.Count
            oList = mvC
        Else
            Dim mvOCB As List(Of mvOrgCatalogueBranches) = (From v In db.mvOrgCatalogueBranches Where v.OrganizationID = mOrganizationID Order By v.LeftKey).ToList
            iTotal = db.mvOrgProduction.Count(Function(v) v.OrganizationID = mOrganizationID)
            iCatCount = mvOCB.Count
            oList  = mvOCB
        End If

	select distinct OP.OrganizationID, C2.CatalogueID, C2.LeftKey, C2.Name 
	from mvOrgProduction OP
	inner join tblCatalogue C on C.CatalogueID = OP.CatalogueID 
	left join tblCatalogue C2 on C2.LeftKey<=C.LeftKey and C2.RightKey>=C.RightKey 
	where C2.Level > 2

with v as (
	select distinct OP.OrganizationID, C2.CatalogueID, C2.LeftKey, C2.Name 
	from mvOrgProduction OP
	inner join tblCatalogue C on C.CatalogueID = OP.CatalogueID 
	left join tblCatalogue C2 on C2.LeftKey<=C.LeftKey and C2.RightKey>=C.RightKey 
	where C2.Level > 2
)
select NEWID() ID, *
from v