select
  MBAnalit.OriginalAn,
  MBAnalitSprOriginalAn.NameAn as OriginalAnDisplayFld,
  MBAnalitSprOriginalAn.Kod as OriginalAnKod,
  IsNull(MBAnalitSprOriginalAn.DatOpen, '19000101') as OriginalAnDatOpen,
  IsNull(MBAnalitSprOriginalAn.DatClose, '29000101') as OriginalAnDatClose,
  MBAnalit.OurFirm,
  MBAnalitSprOurFirm.NameAn as OurFirmDisplayFld,
  MBAnalitSprOurFirm.Kod as OurFirmKod,
  IsNull(MBAnalitSprOurFirm.DatOpen, '19000101') as OurFirmDatOpen,
  IsNull(MBAnalitSprOurFirm.DatClose, '29000101') as OurFirmDatClose,
  MBAnalit.TNKBPContractStatus,
  MBAnalit.TNKBPEDocumentType,
  MBAnalit.FIO,
  MBAnalitSprFIO.NameAn as FIODisplayFld,
  MBAnalitSprFIO.Kod as FIOKod,
  IsNull(MBAnalitSprFIO.DatOpen, '19000101') as FIODatOpen,
  IsNull(MBAnalitSprFIO.DatClose, '29000101') as FIODatClose,
  MBAnalit.Employee,
  MBAnalitSprEmployee.NameAn as EmployeeDisplayFld,
  MBAnalitSprEmployee.Kod as EmployeeKod,
  IsNull(MBAnalitSprEmployee.DatOpen, '19000101') as EmployeeDatOpen,
  IsNull(MBAnalitSprEmployee.DatClose, '29000101') as EmployeeDatClose,
  MBAnalit.FIO2,
  MBAnalitSprFIO2.NameAn as FIO2DisplayFld,
  MBAnalitSprFIO2.Kod as FIO2Kod,
  IsNull(MBAnalitSprFIO2.DatOpen, '19000101') as FIO2DatOpen,
  IsNull(MBAnalitSprFIO2.DatClose, '29000101') as FIO2DatClose,
  MBAnalit.TNKBPDealForm,
  MBAnalit.TNKBPString50,
  MBAnalit.Recv2,
  MBAnalit.DateOper,
  MBAnalit.Date2,
  MBAnalit.Date3,
  MBAnalit.Date4,
  MBAnalit.Date5,
  MBAnalit.Data8,
  MBAnalit.Data9,
  MBAnalit.TNKBPExecutionEnding,
  MBAnalit.TNKBPFractionalNumbe,
  MBAnalit.TNKBPLeadingDeal,
  MBAnalitSprTNKBPLeadingDeal.NameAn as TNKBPLeadingDealDisplayFld,
  MBAnalitSprTNKBPLeadingDeal.Kod as TNKBPLeadingDealKod,
  IsNull(MBAnalitSprTNKBPLeadingDeal.DatOpen, '19000101') as TNKBPLeadingDealDatOpen,
  IsNull(MBAnalitSprTNKBPLeadingDeal.DatClose, '29000101') as TNKBPLeadingDealDatClose,
  MBAnalit.Org,
  MBAnalitSprOrg.NameAn as OrgDisplayFld,
  MBAnalitSprOrg.Kod as OrgKod,
  IsNull(MBAnalitSprOrg.DatOpen, '19000101') as OrgDatOpen,
  IsNull(MBAnalitSprOrg.DatClose, '29000101') as OrgDatClose,
  MBAnalit.TNKBPSignPartnerPres,
  MBAnalit.YesNo2,
  MBAnalit.Soder,
  MBAnalit.TNKBPPerfUnitManager,
  MBAnalitSprTNKBPPerfUnitManager.NameAn as TNKBPPerfUnitManagerDisplayFld,
  MBAnalitSprTNKBPPerfUnitManager.Kod as TNKBPPerfUnitManagerKod,
  IsNull(MBAnalitSprTNKBPPerfUnitManager.DatOpen, '19000101') as TNKBPPerfUnitManagerDatOpen,
  IsNull(MBAnalitSprTNKBPPerfUnitManager.DatClose, '29000101') as TNKBPPerfUnitManagerDatClose,
  MBAnalit.TNKBPDealKind,
  MBAnalitSprTNKBPDealKind.NameAn as TNKBPDealKindDisplayFld,
  MBAnalitSprTNKBPDealKind.Kod as TNKBPDealKindKod,
  IsNull(MBAnalitSprTNKBPDealKind.DatOpen, '19000101') as TNKBPDealKindDatOpen,
  IsNull(MBAnalitSprTNKBPDealKind.DatClose, '29000101') as TNKBPDealKindDatClose,
  MBAnalit.YesNo3,
  MBAnalit.Cena,
  MBAnalit.Cena2,
  MBAnalit.TNKBPDealAmount,
  MBAnalit.TNKBPDealAmount2,
  MBAnalit.Currency,
  MBAnalitSprCurrency.NameAn as CurrencyDisplayFld,
  MBAnalitSprCurrency.Kod as CurrencyKod,
  IsNull(MBAnalitSprCurrency.DatOpen, '19000101') as CurrencyDatOpen,
  IsNull(MBAnalitSprCurrency.DatClose, '29000101') as CurrencyDatClose,
  MBAnalit.FractionalNumber,
  MBAnalit.TNKBPYesNo,
  MBAnalit.TNKBPDealReason,
  MBAnalit.TNKBPPartnerSelMode,
  MBAnalitSprTNKBPPartnerSelMode.NameAn as TNKBPPartnerSelModeDisplayFld,
  MBAnalitSprTNKBPPartnerSelMode.Kod as TNKBPPartnerSelModeKod,
  IsNull(MBAnalitSprTNKBPPartnerSelMode.DatOpen, '19000101') as TNKBPPartnerSelModeDatOpen,
  IsNull(MBAnalitSprTNKBPPartnerSelMode.DatClose, '29000101') as TNKBPPartnerSelModeDatClose,
  MBAnalit.TNKBPWithoutAlterVar,
  MBAnalitSprTNKBPWithoutAlterVar.NameAn as TNKBPWithoutAlterVarDisplayFld,
  MBAnalitSprTNKBPWithoutAlterVar.Kod as TNKBPWithoutAlterVarKod,
  IsNull(MBAnalitSprTNKBPWithoutAlterVar.DatOpen, '19000101') as TNKBPWithoutAlterVarDatOpen,
  IsNull(MBAnalitSprTNKBPWithoutAlterVar.DatClose, '29000101') as TNKBPWithoutAlterVarDatClose,
  MBAnalit.Stroka,
  MBAnalit.Stroka2,
  MBAnalit.Data10,
  MBAnalit.TNKBPRepaymentTerms,
  MBAnalitSprTNKBPRepaymentTerms.NameAn as TNKBPRepaymentTermsDisplayFld,
  MBAnalitSprTNKBPRepaymentTerms.Kod as TNKBPRepaymentTermsKod,
  IsNull(MBAnalitSprTNKBPRepaymentTerms.DatOpen, '19000101') as TNKBPRepaymentTermsDatOpen,
  IsNull(MBAnalitSprTNKBPRepaymentTerms.DatClose, '29000101') as TNKBPRepaymentTermsDatClose,
  MBAnalit.PointK,
  MBAnalit.SheduleK,
  MBAnalit.Prim,
  MBAnalit.TNKBPAntiCorrupRes,
  MBAnalit.TNKBPYesNo2,
  MBAnalit.TNKBPYesNo3,
  MBAnalit.FIO3,
  MBAnalitSprFIO3.NameAn as FIO3DisplayFld,
  MBAnalitSprFIO3.Kod as FIO3Kod,
  IsNull(MBAnalitSprFIO3.DatOpen, '19000101') as FIO3DatOpen,
  IsNull(MBAnalitSprFIO3.DatClose, '29000101') as FIO3DatClose,
  MBAnalit.TNKBPCreditRisk2,
  MBAnalit.TNKBPYesNo4,
  MBAnalit.TNKBPEmployee,
  MBAnalitSprTNKBPEmployee.NameAn as TNKBPEmployeeDisplayFld,
  MBAnalitSprTNKBPEmployee.Kod as TNKBPEmployeeKod,
  IsNull(MBAnalitSprTNKBPEmployee.DatOpen, '19000101') as TNKBPEmployeeDatOpen,
  IsNull(MBAnalitSprTNKBPEmployee.DatClose, '29000101') as TNKBPEmployeeDatClose,
  MBAnalit.TNKBPProvisionKind,
  MBAnalitSprTNKBPProvisionKind.NameAn as TNKBPProvisionKindDisplayFld,
  MBAnalitSprTNKBPProvisionKind.Kod as TNKBPProvisionKindKod,
  IsNull(MBAnalitSprTNKBPProvisionKind.DatOpen, '19000101') as TNKBPProvisionKindDatOpen,
  IsNull(MBAnalitSprTNKBPProvisionKind.DatClose, '29000101') as TNKBPProvisionKindDatClose,
  MBAnalit.TNKBPDealAmount3,
  MBAnalit.Stroka3,
  MBAnalit.TNKBPStoringObject,
  cast(NULL as varchar(250)) as Calculation,
  MBAnalit.TNKBPEmployees,
  MBAnalitSprTNKBPEmployees.NameAn as TNKBPEmployeesDisplayFld,
  MBAnalitSprTNKBPEmployees.Kod as TNKBPEmployeesKod,
  IsNull(MBAnalitSprTNKBPEmployees.DatOpen, '19000101') as TNKBPEmployeesDatOpen,
  IsNull(MBAnalitSprTNKBPEmployees.DatClose, '29000101') as TNKBPEmployeesDatClose,
  MBAnalit.Podr,
  MBAnalitSprPodr.NameAn as PodrDisplayFld,
  MBAnalitSprPodr.Kod as PodrKod,
  IsNull(MBAnalitSprPodr.DatOpen, '19000101') as PodrDatOpen,
  IsNull(MBAnalitSprPodr.DatClose, '29000101') as PodrDatClose,
  MBAnalit.TNKBPDealAmount4,
  MBAnalit.TNKBPDealAmount5,
  MBAnalit.TNKBPDealAmount6,
  MBAnalit.TNKBPDealAmount7,
  MBAnalit.Dop2,
  MBAnalit.Dop4,
  MBAnalit.PointK2,
  MBAnalit.Dop5,
  MBAnalit.Description,
  MBAnalit.TNKBPProfileCode,
  MBAnalitSprTNKBPProfileCode.NameAn as TNKBPProfileCodeDisplayFld,
  MBAnalitSprTNKBPProfileCode.Kod as TNKBPProfileCodeKod,
  IsNull(MBAnalitSprTNKBPProfileCode.DatOpen, '19000101') as TNKBPProfileCodeDatOpen,
  IsNull(MBAnalitSprTNKBPProfileCode.DatClose, '29000101') as TNKBPProfileCodeDatClose,
  MBAnalit.Point3,
  MBAnalit.TNKBPFormDC,
  MBAnalit.IDSpr,
  MBAnalit.Date6,
  MBAnalit.TNKBPMeeting,
  MBAnalitSprTNKBPMeeting.NameAn as TNKBPMeetingDisplayFld,
  MBAnalitSprTNKBPMeeting.Kod as TNKBPMeetingKod,
  IsNull(MBAnalitSprTNKBPMeeting.DatOpen, '19000101') as TNKBPMeetingDatOpen,
  IsNull(MBAnalitSprTNKBPMeeting.DatClose, '29000101') as TNKBPMeetingDatClose,
  MBAnalit.TNKBPSum11,
  MBAnalit.TNKBPDealType,
  MBAnalitSprTNKBPDealType.NameAn as TNKBPDealTypeDisplayFld,
  MBAnalitSprTNKBPDealType.Kod as TNKBPDealTypeKod,
  IsNull(MBAnalitSprTNKBPDealType.DatOpen, '19000101') as TNKBPDealTypeDatOpen,
  IsNull(MBAnalitSprTNKBPDealType.DatClose, '29000101') as TNKBPDealTypeDatClose,
  MBAnalit.TNKBPDealCategory,
  MBAnalitSprTNKBPDealCategory.NameAn as TNKBPDealCategoryDisplayFld,
  MBAnalitSprTNKBPDealCategory.Kod as TNKBPDealCategoryKod,
  IsNull(MBAnalitSprTNKBPDealCategory.DatOpen, '19000101') as TNKBPDealCategoryDatOpen,
  IsNull(MBAnalitSprTNKBPDealCategory.DatClose, '29000101') as TNKBPDealCategoryDatClose,
  MBAnalit.TNKBPSum12,
  MBAnalit.TNKBPOilRealPaths,
  MBAnalitSprTNKBPOilRealPaths.NameAn as TNKBPOilRealPathsDisplayFld,
  MBAnalitSprTNKBPOilRealPaths.Kod as TNKBPOilRealPathsKod,
  IsNull(MBAnalitSprTNKBPOilRealPaths.DatOpen, '19000101') as TNKBPOilRealPathsDatOpen,
  IsNull(MBAnalitSprTNKBPOilRealPaths.DatClose, '29000101') as TNKBPOilRealPathsDatClose,
  MBAnalit.TNKBPSum5,
  MBAnalit.Point4,
  MBAnalit.OurFirm2,
  MBAnalitSprOurFirm2.NameAn as OurFirm2DisplayFld,
  MBAnalitSprOurFirm2.Kod as OurFirm2Kod,
  IsNull(MBAnalitSprOurFirm2.DatOpen, '19000101') as OurFirm2DatOpen,
  IsNull(MBAnalitSprOurFirm2.DatClose, '29000101') as OurFirm2DatClose,
  MBAnalit.TNKBPRegFormCode,
  MBAnalit.TNKBPRegForm,
  MBAnalit.Dop3,
  MBAnalit.TNKBPDealType2,
  MBAnalitSprTNKBPDealType2.NameAn as TNKBPDealType2DisplayFld,
  MBAnalitSprTNKBPDealType2.Kod as TNKBPDealType2Kod,
  IsNull(MBAnalitSprTNKBPDealType2.DatOpen, '19000101') as TNKBPDealType2DatOpen,
  IsNull(MBAnalitSprTNKBPDealType2.DatClose, '29000101') as TNKBPDealType2DatClose,
  cast(NULL as varchar(255)) as TNKBPCalculated,
  MBAnalit.TNKBPPerformanceUnit,
  MBAnalitSprTNKBPPerformanceUnit.NameAn as TNKBPPerformanceUnitDisplayFld,
  MBAnalitSprTNKBPPerformanceUnit.Kod as TNKBPPerformanceUnitKod,
  IsNull(MBAnalitSprTNKBPPerformanceUnit.DatOpen, '19000101') as TNKBPPerformanceUnitDatOpen,
  IsNull(MBAnalitSprTNKBPPerformanceUnit.DatClose, '29000101') as TNKBPPerformanceUnitDatClose,
  MBAnalit.TNKBPPartnersCLReg,
  MBAnalitSprTNKBPPartnersCLReg.NameAn as TNKBPPartnersCLRegDisplayFld,
  MBAnalitSprTNKBPPartnersCLReg.Kod as TNKBPPartnersCLRegKod,
  IsNull(MBAnalitSprTNKBPPartnersCLReg.DatOpen, '19000101') as TNKBPPartnersCLRegDatOpen,
  IsNull(MBAnalitSprTNKBPPartnersCLReg.DatClose, '29000101') as TNKBPPartnersCLRegDatClose,
  MBAnalit.TNKBPPersonCLRegForm,
  MBAnalitSprTNKBPPersonCLRegForm.NameAn as TNKBPPersonCLRegFormDisplayFld,
  MBAnalitSprTNKBPPersonCLRegForm.Kod as TNKBPPersonCLRegFormKod,
  IsNull(MBAnalitSprTNKBPPersonCLRegForm.DatOpen, '19000101') as TNKBPPersonCLRegFormDatOpen,
  IsNull(MBAnalitSprTNKBPPersonCLRegForm.DatClose, '29000101') as TNKBPPersonCLRegFormDatClose,
  MBAnalit.LongString,
  MBAnalit.TNKBPSum2,
  MBAnalit.TNKBPContractStrateg,
  MBAnalitSprTNKBPContractStrateg.NameAn as TNKBPContractStrategDisplayFld,
  MBAnalitSprTNKBPContractStrateg.Kod as TNKBPContractStrategKod,
  IsNull(MBAnalitSprTNKBPContractStrateg.DatOpen, '19000101') as TNKBPContractStrategDatOpen,
  IsNull(MBAnalitSprTNKBPContractStrateg.DatClose, '29000101') as TNKBPContractStrategDatClose,
  MBAnalit.TNKBPListGroup,
  MBAnalitSprTNKBPListGroup.NameAn as TNKBPListGroupDisplayFld,
  MBAnalitSprTNKBPListGroup.Kod as TNKBPListGroupKod,
  IsNull(MBAnalitSprTNKBPListGroup.DatOpen, '19000101') as TNKBPListGroupDatOpen,
  IsNull(MBAnalitSprTNKBPListGroup.DatClose, '29000101') as TNKBPListGroupDatClose,
  MBAnalit.TNKBPMembershipList,
  MBAnalit.IntNumber,
  MBAnalit.YesNo4,
  MBAnalit.TNKBPAddAgreeType,
  MBAnalit.TNKBPYesNo5,
  MBAnalit.IntNumber2,
  MBAnalit.TNKBPPrepayDayCount,
  MBAnalit.TNKBPPrepayDayType,
  MBAnalit.TNKBPPaymentDesc,
  MBAnalit.TNKBPFactPayDayCount,
  MBAnalit.TNKBPFactPayDayType,
  MBAnalit.Soder2,
  MBAnalit.TNKBPServiceDayCount,
  MBAnalit.TNKBPServiceDayType,
  MBAnalit.NaimenovanieLV,
  MBAnalit.TNKBPStr500,
  MBAnalit.TNKBPLastCycleStart,
  MBAnalit.TNKBPYesNo6,
  MBAnalit.TNKBPPartnerRegion,
  MBAnalitSprTNKBPPartnerRegion.NameAn as TNKBPPartnerRegionDisplayFld,
  MBAnalitSprTNKBPPartnerRegion.Kod as TNKBPPartnerRegionKod,
  IsNull(MBAnalitSprTNKBPPartnerRegion.DatOpen, '19000101') as TNKBPPartnerRegionDatOpen,
  IsNull(MBAnalitSprTNKBPPartnerRegion.DatClose, '29000101') as TNKBPPartnerRegionDatClose,
  MBAnalit.TNKBPIndividOpinion,
  MBAnalit.TNKBPCategoryChanges,
  MBAnalitSprTNKBPCategoryChanges.NameAn as TNKBPCategoryChangesDisplayFld,
  MBAnalitSprTNKBPCategoryChanges.Kod as TNKBPCategoryChangesKod,
  IsNull(MBAnalitSprTNKBPCategoryChanges.DatOpen, '19000101') as TNKBPCategoryChangesDatOpen,
  IsNull(MBAnalitSprTNKBPCategoryChanges.DatClose, '29000101') as TNKBPCategoryChangesDatClose,
  MBAnalit.TNKBPSubcatChanges,
  MBAnalitSprTNKBPSubcatChanges.NameAn as TNKBPSubcatChangesDisplayFld,
  MBAnalitSprTNKBPSubcatChanges.Kod as TNKBPSubcatChangesKod,
  IsNull(MBAnalitSprTNKBPSubcatChanges.DatOpen, '19000101') as TNKBPSubcatChangesDatOpen,
  IsNull(MBAnalitSprTNKBPSubcatChanges.DatClose, '29000101') as TNKBPSubcatChangesDatClose,
  MBAnalit.TNKBPHasStrategy,
  MBAnalit.TNKBPGroupService,
  MBAnalitSprTNKBPGroupService.NameAn as TNKBPGroupServiceDisplayFld,
  MBAnalitSprTNKBPGroupService.Kod as TNKBPGroupServiceKod,
  IsNull(MBAnalitSprTNKBPGroupService.DatOpen, '19000101') as TNKBPGroupServiceDatOpen,
  IsNull(MBAnalitSprTNKBPGroupService.DatClose, '29000101') as TNKBPGroupServiceDatClose,
  MBAnalit.TNKBPListService,
  MBAnalit.INN,
  MBAnalit.TNKBPStr501,
  MBAnalit.TNKBPString15,
  MBAnalit.TNKBPHasPrequalific,
  MBAnalit.TNKBPString80,
  MBAnalit.TNKBPSting80_2,
  MBAnalit.TNKBPDateTime,
  MBAnalit.TNKBPDateTime2,
  MBAnalit.TNKBPNeedConcordance,
  MBAnalit.TNKBPCondDescent,
  MBAnalitSprTNKBPCondDescent.NameAn as TNKBPCondDescentDisplayFld,
  MBAnalitSprTNKBPCondDescent.Kod as TNKBPCondDescentKod,
  IsNull(MBAnalitSprTNKBPCondDescent.DatOpen, '19000101') as TNKBPCondDescentDatOpen,
  IsNull(MBAnalitSprTNKBPCondDescent.DatClose, '29000101') as TNKBPCondDescentDatClose,
  MBAnalit.TNKBPDateTime3,
  MBAnalit.EDocSigned,
  MBAnalit.TNKBPHoldingOilBuy,
  MBAnalit.TNKBPYesNoX,
  MBAnalit.TNKBPString600,
  MBAnalit.TNKBPYesNo7,
  MBAnalit.TNKBPYesNo8,
  MBAnalit.TNKBPFFS,
  MBAnalit.TNKBPSum1,
  MBAnalit.TNKBPContractProcess,
  MBAnalit.TNKBPTFinAuthorities,
  MBAnalitSprTNKBPTFinAuthorities.NameAn as TNKBPTFinAuthoritiesDisplayFld,
  MBAnalitSprTNKBPTFinAuthorities.Kod as TNKBPTFinAuthoritiesKod,
  IsNull(MBAnalitSprTNKBPTFinAuthorities.DatOpen, '19000101') as TNKBPTFinAuthoritiesDatOpen,
  IsNull(MBAnalitSprTNKBPTFinAuthorities.DatClose, '29000101') as TNKBPTFinAuthoritiesDatClose,
  MBAnalit.TNKBPSum6,
  MBAnalit.SNGPrice9,
  MBAnalit.TNKBPDueDate,
  MBAnalit.TNKBPListGroup2,
  MBAnalitSprTNKBPListGroup2.NameAn as TNKBPListGroup2DisplayFld,
  MBAnalitSprTNKBPListGroup2.Kod as TNKBPListGroup2Kod,
  IsNull(MBAnalitSprTNKBPListGroup2.DatOpen, '19000101') as TNKBPListGroup2DatOpen,
  IsNull(MBAnalitSprTNKBPListGroup2.DatClose, '29000101') as TNKBPListGroup2DatClose,
  MBAnalit.TNKBPListGroup3,
  MBAnalitSprTNKBPListGroup3.NameAn as TNKBPListGroup3DisplayFld,
  MBAnalitSprTNKBPListGroup3.Kod as TNKBPListGroup3Kod,
  IsNull(MBAnalitSprTNKBPListGroup3.DatOpen, '19000101') as TNKBPListGroup3DatOpen,
  IsNull(MBAnalitSprTNKBPListGroup3.DatClose, '29000101') as TNKBPListGroup3DatClose,
  MBAnalit.TNKBPListGroup4,
  MBAnalitSprTNKBPListGroup4.NameAn as TNKBPListGroup4DisplayFld,
  MBAnalitSprTNKBPListGroup4.Kod as TNKBPListGroup4Kod,
  IsNull(MBAnalitSprTNKBPListGroup4.DatOpen, '19000101') as TNKBPListGroup4DatOpen,
  IsNull(MBAnalitSprTNKBPListGroup4.DatClose, '29000101') as TNKBPListGroup4DatClose,
  MBAnalit.TNKBPListGroup5,
  MBAnalitSprTNKBPListGroup5.NameAn as TNKBPListGroup5DisplayFld,
  MBAnalitSprTNKBPListGroup5.Kod as TNKBPListGroup5Kod,
  IsNull(MBAnalitSprTNKBPListGroup5.DatOpen, '19000101') as TNKBPListGroup5DatOpen,
  IsNull(MBAnalitSprTNKBPListGroup5.DatClose, '29000101') as TNKBPListGroup5DatClose,
  MBAnalit.TNKBPListGroupCode2,
  MBAnalit.TNKBPListGroupCode3,
  MBAnalit.TNKBPListGroupCode4,
  MBAnalit.TNKBPListGroupCode5,
  MBAnalit.TNKBPMembershipList2,
  MBAnalit.TNKBPMembershipList3,
  MBAnalit.TNKBPMembershipList4,
  MBAnalit.TNKBPMembershipList5,
  MBAnalit.TNKBPClassMTRAndServ,
  MBAnalitSprTNKBPClassMTRAndServ.NameAn as TNKBPClassMTRAndServDisplayFld,
  MBAnalitSprTNKBPClassMTRAndServ.Kod as TNKBPClassMTRAndServKod,
  IsNull(MBAnalitSprTNKBPClassMTRAndServ.DatOpen, '19000101') as TNKBPClassMTRAndServDatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndServ.DatClose, '29000101') as TNKBPClassMTRAndServDatClose,
  MBAnalit.TNKBPClassMTRAndS2,
  MBAnalitSprTNKBPClassMTRAndS2.NameAn as TNKBPClassMTRAndS2DisplayFld,
  MBAnalitSprTNKBPClassMTRAndS2.Kod as TNKBPClassMTRAndS2Kod,
  IsNull(MBAnalitSprTNKBPClassMTRAndS2.DatOpen, '19000101') as TNKBPClassMTRAndS2DatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndS2.DatClose, '29000101') as TNKBPClassMTRAndS2DatClose,
  MBAnalit.TNKBPClassMTRAndS3,
  MBAnalitSprTNKBPClassMTRAndS3.NameAn as TNKBPClassMTRAndS3DisplayFld,
  MBAnalitSprTNKBPClassMTRAndS3.Kod as TNKBPClassMTRAndS3Kod,
  IsNull(MBAnalitSprTNKBPClassMTRAndS3.DatOpen, '19000101') as TNKBPClassMTRAndS3DatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndS3.DatClose, '29000101') as TNKBPClassMTRAndS3DatClose,
  MBAnalit.TNKBPClassMTRAndS4,
  MBAnalitSprTNKBPClassMTRAndS4.NameAn as TNKBPClassMTRAndS4DisplayFld,
  MBAnalitSprTNKBPClassMTRAndS4.Kod as TNKBPClassMTRAndS4Kod,
  IsNull(MBAnalitSprTNKBPClassMTRAndS4.DatOpen, '19000101') as TNKBPClassMTRAndS4DatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndS4.DatClose, '29000101') as TNKBPClassMTRAndS4DatClose,
  MBAnalit.TNKBPClassMTRAndS5,
  MBAnalitSprTNKBPClassMTRAndS5.NameAn as TNKBPClassMTRAndS5DisplayFld,
  MBAnalitSprTNKBPClassMTRAndS5.Kod as TNKBPClassMTRAndS5Kod,
  IsNull(MBAnalitSprTNKBPClassMTRAndS5.DatOpen, '19000101') as TNKBPClassMTRAndS5DatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndS5.DatClose, '29000101') as TNKBPClassMTRAndS5DatClose,
  MBAnalit.TNKBPGroupService2,
  MBAnalitSprTNKBPGroupService2.NameAn as TNKBPGroupService2DisplayFld,
  MBAnalitSprTNKBPGroupService2.Kod as TNKBPGroupService2Kod,
  IsNull(MBAnalitSprTNKBPGroupService2.DatOpen, '19000101') as TNKBPGroupService2DatOpen,
  IsNull(MBAnalitSprTNKBPGroupService2.DatClose, '29000101') as TNKBPGroupService2DatClose,
  MBAnalit.TNKBPGroupService3,
  MBAnalitSprTNKBPGroupService3.NameAn as TNKBPGroupService3DisplayFld,
  MBAnalitSprTNKBPGroupService3.Kod as TNKBPGroupService3Kod,
  IsNull(MBAnalitSprTNKBPGroupService3.DatOpen, '19000101') as TNKBPGroupService3DatOpen,
  IsNull(MBAnalitSprTNKBPGroupService3.DatClose, '29000101') as TNKBPGroupService3DatClose,
  MBAnalit.TNKBPGroupService4,
  MBAnalitSprTNKBPGroupService4.NameAn as TNKBPGroupService4DisplayFld,
  MBAnalitSprTNKBPGroupService4.Kod as TNKBPGroupService4Kod,
  IsNull(MBAnalitSprTNKBPGroupService4.DatOpen, '19000101') as TNKBPGroupService4DatOpen,
  IsNull(MBAnalitSprTNKBPGroupService4.DatClose, '29000101') as TNKBPGroupService4DatClose,
  MBAnalit.TNKBPGroupService5,
  MBAnalitSprTNKBPGroupService5.NameAn as TNKBPGroupService5DisplayFld,
  MBAnalitSprTNKBPGroupService5.Kod as TNKBPGroupService5Kod,
  IsNull(MBAnalitSprTNKBPGroupService5.DatOpen, '19000101') as TNKBPGroupService5DatOpen,
  IsNull(MBAnalitSprTNKBPGroupService5.DatClose, '29000101') as TNKBPGroupService5DatClose,
  MBAnalit.TNKBPServiceGrpCode2,
  MBAnalit.TNKBPServiceGrpCode3,
  MBAnalit.TNKBPServiceGrpCode4,
  MBAnalit.TNKBPServiceGrpCode5,
  MBAnalit.TNKBPListService2,
  MBAnalit.TNKBPListService3,
  MBAnalit.TNKBPListService4,
  MBAnalit.TNKBPListService5,
  MBAnalit.TNKBPClassMTRAndS6,
  MBAnalitSprTNKBPClassMTRAndS6.NameAn as TNKBPClassMTRAndS6DisplayFld,
  MBAnalitSprTNKBPClassMTRAndS6.Kod as TNKBPClassMTRAndS6Kod,
  IsNull(MBAnalitSprTNKBPClassMTRAndS6.DatOpen, '19000101') as TNKBPClassMTRAndS6DatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndS6.DatClose, '29000101') as TNKBPClassMTRAndS6DatClose,
  MBAnalit.TNKBPClassMTRAndS7,
  MBAnalitSprTNKBPClassMTRAndS7.NameAn as TNKBPClassMTRAndS7DisplayFld,
  MBAnalitSprTNKBPClassMTRAndS7.Kod as TNKBPClassMTRAndS7Kod,
  IsNull(MBAnalitSprTNKBPClassMTRAndS7.DatOpen, '19000101') as TNKBPClassMTRAndS7DatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndS7.DatClose, '29000101') as TNKBPClassMTRAndS7DatClose,
  MBAnalit.TNKBPClassMTRAndS8,
  MBAnalitSprTNKBPClassMTRAndS8.NameAn as TNKBPClassMTRAndS8DisplayFld,
  MBAnalitSprTNKBPClassMTRAndS8.Kod as TNKBPClassMTRAndS8Kod,
  IsNull(MBAnalitSprTNKBPClassMTRAndS8.DatOpen, '19000101') as TNKBPClassMTRAndS8DatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndS8.DatClose, '29000101') as TNKBPClassMTRAndS8DatClose,
  MBAnalit.TNKBPClassMTRAndS9,
  MBAnalitSprTNKBPClassMTRAndS9.NameAn as TNKBPClassMTRAndS9DisplayFld,
  MBAnalitSprTNKBPClassMTRAndS9.Kod as TNKBPClassMTRAndS9Kod,
  IsNull(MBAnalitSprTNKBPClassMTRAndS9.DatOpen, '19000101') as TNKBPClassMTRAndS9DatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndS9.DatClose, '29000101') as TNKBPClassMTRAndS9DatClose,
  MBAnalit.TNKBPClassMTRAndS10,
  MBAnalitSprTNKBPClassMTRAndS10.NameAn as TNKBPClassMTRAndS10DisplayFld,
  MBAnalitSprTNKBPClassMTRAndS10.Kod as TNKBPClassMTRAndS10Kod,
  IsNull(MBAnalitSprTNKBPClassMTRAndS10.DatOpen, '19000101') as TNKBPClassMTRAndS10DatOpen,
  IsNull(MBAnalitSprTNKBPClassMTRAndS10.DatClose, '29000101') as TNKBPClassMTRAndS10DatClose,
  MBAnalit.TNKBPObligationType,
  MBAnalit.TNKBPSectorGroup,
  MBAnalitSprTNKBPSectorGroup.NameAn as TNKBPSectorGroupDisplayFld,
  MBAnalitSprTNKBPSectorGroup.Kod as TNKBPSectorGroupKod,
  IsNull(MBAnalitSprTNKBPSectorGroup.DatOpen, '19000101') as TNKBPSectorGroupDatOpen,
  IsNull(MBAnalitSprTNKBPSectorGroup.DatClose, '29000101') as TNKBPSectorGroupDatClose,
  MBAnalit.TNKBPContractClass,
  MBAnalit.TNKBPCCLevel,
  MBAnalitSprTNKBPCCLevel.NameAn as TNKBPCCLevelDisplayFld,
  MBAnalitSprTNKBPCCLevel.Kod as TNKBPCCLevelKod,
  IsNull(MBAnalitSprTNKBPCCLevel.DatOpen, '19000101') as TNKBPCCLevelDatOpen,
  IsNull(MBAnalitSprTNKBPCCLevel.DatClose, '29000101') as TNKBPCCLevelDatClose,
  MBAnalit.YesNo,
  MBAnalit.TNKBPCostOrigPlace,
  MBAnalitSprTNKBPCostOrigPlace.NameAn as TNKBPCostOrigPlaceDisplayFld,
  MBAnalitSprTNKBPCostOrigPlace.Kod as TNKBPCostOrigPlaceKod,
  IsNull(MBAnalitSprTNKBPCostOrigPlace.DatOpen, '19000101') as TNKBPCostOrigPlaceDatOpen,
  IsNull(MBAnalitSprTNKBPCostOrigPlace.DatClose, '29000101') as TNKBPCostOrigPlaceDatClose,
  MBAnalit.TNKBPBudgetOwner,
  MBAnalitSprTNKBPBudgetOwner.NameAn as TNKBPBudgetOwnerDisplayFld,
  MBAnalitSprTNKBPBudgetOwner.Kod as TNKBPBudgetOwnerKod,
  IsNull(MBAnalitSprTNKBPBudgetOwner.DatOpen, '19000101') as TNKBPBudgetOwnerDatOpen,
  IsNull(MBAnalitSprTNKBPBudgetOwner.DatClose, '29000101') as TNKBPBudgetOwnerDatClose,
  MBAnalit.TNKBPCostDirection,
  MBAnalitSprTNKBPCostDirection.NameAn as TNKBPCostDirectionDisplayFld,
  MBAnalitSprTNKBPCostDirection.Kod as TNKBPCostDirectionKod,
  IsNull(MBAnalitSprTNKBPCostDirection.DatOpen, '19000101') as TNKBPCostDirectionDatOpen,
  IsNull(MBAnalitSprTNKBPCostDirection.DatClose, '29000101') as TNKBPCostDirectionDatClose,
  MBAnalit.TNKBPCostKind,
  MBAnalitSprTNKBPCostKind.NameAn as TNKBPCostKindDisplayFld,
  MBAnalitSprTNKBPCostKind.Kod as TNKBPCostKindKod,
  IsNull(MBAnalitSprTNKBPCostKind.DatOpen, '19000101') as TNKBPCostKindDatOpen,
  IsNull(MBAnalitSprTNKBPCostKind.DatClose, '29000101') as TNKBPCostKindDatClose,
  MBAnalit.TNKBPProjectCode,
  MBAnalitSprTNKBPProjectCode.NameAn as TNKBPProjectCodeDisplayFld,
  MBAnalitSprTNKBPProjectCode.Kod as TNKBPProjectCodeKod,
  IsNull(MBAnalitSprTNKBPProjectCode.DatOpen, '19000101') as TNKBPProjectCodeDatOpen,
  IsNull(MBAnalitSprTNKBPProjectCode.DatClose, '29000101') as TNKBPProjectCodeDatClose,
  MBAnalit.TNKBPArticleBud,
  MBAnalitSprTNKBPArticleBud.NameAn as TNKBPArticleBudDisplayFld,
  MBAnalitSprTNKBPArticleBud.Kod as TNKBPArticleBudKod,
  IsNull(MBAnalitSprTNKBPArticleBud.DatOpen, '19000101') as TNKBPArticleBudDatOpen,
  IsNull(MBAnalitSprTNKBPArticleBud.DatClose, '29000101') as TNKBPArticleBudDatClose,
  MBAnalit.TNKBPSum3Saved,
  MBAnalit.TNKBPSum4Saved,
  MBAnalit.TNKBPYesNo9,
  MBAnalit.TNKBPAssociatedComp,
  MBAnalitSprTNKBPAssociatedComp.NameAn as TNKBPAssociatedCompDisplayFld,
  MBAnalitSprTNKBPAssociatedComp.Kod as TNKBPAssociatedCompKod,
  IsNull(MBAnalitSprTNKBPAssociatedComp.DatOpen, '19000101') as TNKBPAssociatedCompDatOpen,
  IsNull(MBAnalitSprTNKBPAssociatedComp.DatClose, '29000101') as TNKBPAssociatedCompDatClose,
  MBAnalit.TNKBPDealReasonAuth,
  MBAnalit.TNKBPString30,
  MBAnalit.VremyaStr,
  MBAnalit.Data7,
  MBAnalit.TNKBPPrequalContr,
  MBAnalitSprTNKBPPrequalContr.NameAn as TNKBPPrequalContrDisplayFld,
  MBAnalitSprTNKBPPrequalContr.Kod as TNKBPPrequalContrKod,
  IsNull(MBAnalitSprTNKBPPrequalContr.DatOpen, '19000101') as TNKBPPrequalContrDatOpen,
  IsNull(MBAnalitSprTNKBPPrequalContr.DatClose, '29000101') as TNKBPPrequalContrDatClose,
  MBAnalit.TNKBPAuthDelMatrix,
  MBAnalitSprTNKBPAuthDelMatrix.NameAn as TNKBPAuthDelMatrixDisplayFld,
  MBAnalitSprTNKBPAuthDelMatrix.Kod as TNKBPAuthDelMatrixKod,
  IsNull(MBAnalitSprTNKBPAuthDelMatrix.DatOpen, '19000101') as TNKBPAuthDelMatrixDatOpen,
  IsNull(MBAnalitSprTNKBPAuthDelMatrix.DatClose, '29000101') as TNKBPAuthDelMatrixDatClose,
  MBAnalit.String,
  MBAnalit.TNKBPAuthDelMatrix2,
  MBAnalitSprTNKBPAuthDelMatrix2.NameAn as TNKBPAuthDelMatrix2DisplayFld,
  MBAnalitSprTNKBPAuthDelMatrix2.Kod as TNKBPAuthDelMatrix2Kod,
  IsNull(MBAnalitSprTNKBPAuthDelMatrix2.DatOpen, '19000101') as TNKBPAuthDelMatrix2DatOpen,
  IsNull(MBAnalitSprTNKBPAuthDelMatrix2.DatClose, '29000101') as TNKBPAuthDelMatrix2DatClose,
  MBAnalit.Stroka4,
  MBAnalit.TNKBPBusinessVector,
  MBAnalitSprTNKBPBusinessVector.NameAn as TNKBPBusinessVectorDisplayFld,
  MBAnalitSprTNKBPBusinessVector.Kod as TNKBPBusinessVectorKod,
  IsNull(MBAnalitSprTNKBPBusinessVector.DatOpen, '19000101') as TNKBPBusinessVectorDatOpen,
  IsNull(MBAnalitSprTNKBPBusinessVector.DatClose, '29000101') as TNKBPBusinessVectorDatClose,
  MBAnalit.TNKBPAllocation,
  MBAnalit.TNKBPInsider,
  MBAnalit.TNKBPValControl,
  MBAnalit.TNKBPOwner,
  MBAnalitSprTNKBPOwner.NameAn as TNKBPOwnerDisplayFld,
  MBAnalitSprTNKBPOwner.Kod as TNKBPOwnerKod,
  IsNull(MBAnalitSprTNKBPOwner.DatOpen, '19000101') as TNKBPOwnerDatOpen,
  IsNull(MBAnalitSprTNKBPOwner.DatClose, '29000101') as TNKBPOwnerDatClose,
  MBAnalit.TNKBPNumMarsh,
  MBAnalit.TNKBPYesNo10,
  MBAnalit.TNKBPPodpisantSystem,
  MBAnalit.TNKBPResultCheckPart,
  MBAnalit.TNKBPContractFormerC,
  MBAnalitSprTNKBPContractFormerC.NameAn as TNKBPContractFormerCDisplayFld,
  MBAnalitSprTNKBPContractFormerC.Kod as TNKBPContractFormerCKod,
  IsNull(MBAnalitSprTNKBPContractFormerC.DatOpen, '19000101') as TNKBPContractFormerCDatOpen,
  IsNull(MBAnalitSprTNKBPContractFormerC.DatClose, '29000101') as TNKBPContractFormerCDatClose,
  MBAnalit.TNKBPRegDocKinds,
  MBAnalitSprTNKBPRegDocKinds.NameAn as TNKBPRegDocKindsDisplayFld,
  MBAnalitSprTNKBPRegDocKinds.Kod as TNKBPRegDocKindsKod,
  IsNull(MBAnalitSprTNKBPRegDocKinds.DatOpen, '19000101') as TNKBPRegDocKindsDatOpen,
  IsNull(MBAnalitSprTNKBPRegDocKinds.DatClose, '29000101') as TNKBPRegDocKindsDatClose,
  MBAnalit.TNKBPCollegiateOrgan,
  MBAnalitSprTNKBPCollegiateOrgan.NameAn as TNKBPCollegiateOrganDisplayFld,
  MBAnalitSprTNKBPCollegiateOrgan.Kod as TNKBPCollegiateOrganKod,
  IsNull(MBAnalitSprTNKBPCollegiateOrgan.DatOpen, '19000101') as TNKBPCollegiateOrganDatOpen,
  IsNull(MBAnalitSprTNKBPCollegiateOrgan.DatClose, '29000101') as TNKBPCollegiateOrganDatClose,
  MBAnalit.TNKBPSum7,
  MBAnalit.TNKBPSum8,
  MBAnalit.TNKBPSum9,
  MBAnalit.TNKBPConformableDocs,
  MBAnalitSprTNKBPConformableDocs.NameAn as TNKBPConformableDocsDisplayFld,
  MBAnalitSprTNKBPConformableDocs.Kod as TNKBPConformableDocsKod,
  IsNull(MBAnalitSprTNKBPConformableDocs.DatOpen, '19000101') as TNKBPConformableDocsDatOpen,
  IsNull(MBAnalitSprTNKBPConformableDocs.DatClose, '29000101') as TNKBPConformableDocsDatClose,
  MBAnalit.Analit,
  MBAnalit.Vid,
  MBAnalit.IsDouble,
  MBAnalit.StatFlag,
  MBAnalit.NameAn,
  MBAnalit.Kod,
  MBAnalit.Sost,
  MBAnalit.DatOpen,
  MBAnalit.DatClose
from
  MBAnalit MBAnalit,
  MBAnalitSpr MBAnalitSprOriginalAn,
  MBAnalitSpr MBAnalitSprOurFirm,
  MBAnalitSpr MBAnalitSprFIO,
  MBAnalitSpr MBAnalitSprEmployee,
  MBAnalitSpr MBAnalitSprFIO2,
  MBAnalitSpr MBAnalitSprTNKBPLeadingDeal,
  MBAnalitSpr MBAnalitSprOrg,
  MBAnalitSpr MBAnalitSprTNKBPPerfUnitManager,
  MBAnalitSpr MBAnalitSprTNKBPDealKind,
  MBAnalitSpr MBAnalitSprCurrency,
  MBAnalitSpr MBAnalitSprTNKBPPartnerSelMode,
  MBAnalitSpr MBAnalitSprTNKBPWithoutAlterVar,
  MBAnalitSpr MBAnalitSprTNKBPRepaymentTerms,
  MBAnalitSpr MBAnalitSprFIO3,
  MBAnalitSpr MBAnalitSprTNKBPEmployee,
  MBAnalitSpr MBAnalitSprTNKBPProvisionKind,
  MBAnalitSpr MBAnalitSprTNKBPEmployees,
  MBAnalitSpr MBAnalitSprPodr,
  MBAnalitSpr MBAnalitSprTNKBPProfileCode,
  MBAnalitSpr MBAnalitSprTNKBPMeeting,
  MBAnalitSpr MBAnalitSprTNKBPDealType,
  MBAnalitSpr MBAnalitSprTNKBPDealCategory,
  MBAnalitSpr MBAnalitSprTNKBPOilRealPaths,
  MBAnalitSpr MBAnalitSprOurFirm2,
  MBAnalitSpr MBAnalitSprTNKBPDealType2,
  MBAnalitSpr MBAnalitSprTNKBPPerformanceUnit,
  MBAnalitSpr MBAnalitSprTNKBPPartnersCLReg,
  MBAnalitSpr MBAnalitSprTNKBPPersonCLRegForm,
  MBAnalitSpr MBAnalitSprTNKBPContractStrateg,
  MBAnalitSpr MBAnalitSprTNKBPListGroup,
  MBAnalitSpr MBAnalitSprTNKBPPartnerRegion,
  MBAnalitSpr MBAnalitSprTNKBPCategoryChanges,
  MBAnalitSpr MBAnalitSprTNKBPSubcatChanges,
  MBAnalitSpr MBAnalitSprTNKBPGroupService,
  MBAnalitSpr MBAnalitSprTNKBPCondDescent,
  MBAnalitSpr MBAnalitSprTNKBPTFinAuthorities,
  MBAnalitSpr MBAnalitSprTNKBPListGroup2,
  MBAnalitSpr MBAnalitSprTNKBPListGroup3,
  MBAnalitSpr MBAnalitSprTNKBPListGroup4,
  MBAnalitSpr MBAnalitSprTNKBPListGroup5,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndServ,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndS2,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndS3,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndS4,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndS5,
  MBAnalitSpr MBAnalitSprTNKBPGroupService2,
  MBAnalitSpr MBAnalitSprTNKBPGroupService3,
  MBAnalitSpr MBAnalitSprTNKBPGroupService4,
  MBAnalitSpr MBAnalitSprTNKBPGroupService5,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndS6,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndS7,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndS8,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndS9,
  MBAnalitSpr MBAnalitSprTNKBPClassMTRAndS10,
  MBAnalitSpr MBAnalitSprTNKBPSectorGroup,
  MBAnalitSpr MBAnalitSprTNKBPCCLevel,
  MBAnalitSpr MBAnalitSprTNKBPCostOrigPlace,
  MBAnalitSpr MBAnalitSprTNKBPBudgetOwner,
  MBAnalitSpr MBAnalitSprTNKBPCostDirection,
  MBAnalitSpr MBAnalitSprTNKBPCostKind,
  MBAnalitSpr MBAnalitSprTNKBPProjectCode,
  MBAnalitSpr MBAnalitSprTNKBPArticleBud,
  MBAnalitSpr MBAnalitSprTNKBPAssociatedComp,
  MBAnalitSpr MBAnalitSprTNKBPPrequalContr,
  MBAnalitSpr MBAnalitSprTNKBPAuthDelMatrix,
  MBAnalitSpr MBAnalitSprTNKBPAuthDelMatrix2,
  MBAnalitSpr MBAnalitSprTNKBPBusinessVector,
  MBAnalitSpr MBAnalitSprTNKBPOwner,
  MBAnalitSpr MBAnalitSprTNKBPContractFormerC,
  MBAnalitSpr MBAnalitSprTNKBPRegDocKinds,
  MBAnalitSpr MBAnalitSprTNKBPCollegiateOrgan,
  MBAnalitSpr MBAnalitSprTNKBPConformableDocs
where
  MBAnalit.OriginalAn *= MBAnalitSprOriginalAn.Analit
  and MBAnalit.OurFirm *= MBAnalitSprOurFirm.Analit
  and MBAnalit.FIO *= MBAnalitSprFIO.Analit
  and MBAnalit.Employee *= MBAnalitSprEmployee.Analit
  and MBAnalit.FIO2 *= MBAnalitSprFIO2.Analit
  and MBAnalit.TNKBPLeadingDeal *= MBAnalitSprTNKBPLeadingDeal.Analit
  and MBAnalit.Org *= MBAnalitSprOrg.Analit
  and MBAnalit.TNKBPPerfUnitManager *= MBAnalitSprTNKBPPerfUnitManager.Analit
  and MBAnalit.TNKBPDealKind *= MBAnalitSprTNKBPDealKind.Analit
  and MBAnalit.Currency *= MBAnalitSprCurrency.Analit
  and MBAnalit.TNKBPPartnerSelMode *= MBAnalitSprTNKBPPartnerSelMode.Analit
  and MBAnalit.TNKBPWithoutAlterVar *= MBAnalitSprTNKBPWithoutAlterVar.Analit
  and MBAnalit.TNKBPRepaymentTerms *= MBAnalitSprTNKBPRepaymentTerms.Analit
  and MBAnalit.FIO3 *= MBAnalitSprFIO3.Analit
  and MBAnalit.TNKBPEmployee *= MBAnalitSprTNKBPEmployee.Analit
  and MBAnalit.TNKBPProvisionKind *= MBAnalitSprTNKBPProvisionKind.Analit
  and MBAnalit.TNKBPEmployees *= MBAnalitSprTNKBPEmployees.Analit
  and MBAnalit.Podr *= MBAnalitSprPodr.Analit
  and MBAnalit.TNKBPProfileCode *= MBAnalitSprTNKBPProfileCode.Analit
  and MBAnalit.TNKBPMeeting *= MBAnalitSprTNKBPMeeting.Analit
  and MBAnalit.TNKBPDealType *= MBAnalitSprTNKBPDealType.Analit
  and MBAnalit.TNKBPDealCategory *= MBAnalitSprTNKBPDealCategory.Analit
  and MBAnalit.TNKBPOilRealPaths *= MBAnalitSprTNKBPOilRealPaths.Analit
  and MBAnalit.OurFirm2 *= MBAnalitSprOurFirm2.Analit
  and MBAnalit.TNKBPDealType2 *= MBAnalitSprTNKBPDealType2.Analit
  and MBAnalit.TNKBPPerformanceUnit *= MBAnalitSprTNKBPPerformanceUnit.Analit
  and MBAnalit.TNKBPPartnersCLReg *= MBAnalitSprTNKBPPartnersCLReg.Analit
  and MBAnalit.TNKBPPersonCLRegForm *= MBAnalitSprTNKBPPersonCLRegForm.Analit
  and MBAnalit.TNKBPContractStrateg *= MBAnalitSprTNKBPContractStrateg.Analit
  and MBAnalit.TNKBPListGroup *= MBAnalitSprTNKBPListGroup.Analit
  and MBAnalit.TNKBPPartnerRegion *= MBAnalitSprTNKBPPartnerRegion.Analit
  and MBAnalit.TNKBPCategoryChanges *= MBAnalitSprTNKBPCategoryChanges.Analit
  and MBAnalit.TNKBPSubcatChanges *= MBAnalitSprTNKBPSubcatChanges.Analit
  and MBAnalit.TNKBPGroupService *= MBAnalitSprTNKBPGroupService.Analit
  and MBAnalit.TNKBPCondDescent *= MBAnalitSprTNKBPCondDescent.Analit
  and MBAnalit.TNKBPTFinAuthorities *= MBAnalitSprTNKBPTFinAuthorities.Analit
  and MBAnalit.TNKBPListGroup2 *= MBAnalitSprTNKBPListGroup2.Analit
  and MBAnalit.TNKBPListGroup3 *= MBAnalitSprTNKBPListGroup3.Analit
  and MBAnalit.TNKBPListGroup4 *= MBAnalitSprTNKBPListGroup4.Analit
  and MBAnalit.TNKBPListGroup5 *= MBAnalitSprTNKBPListGroup5.Analit
  and MBAnalit.TNKBPClassMTRAndServ *= MBAnalitSprTNKBPClassMTRAndServ.Analit
  and MBAnalit.TNKBPClassMTRAndS2 *= MBAnalitSprTNKBPClassMTRAndS2.Analit
  and MBAnalit.TNKBPClassMTRAndS3 *= MBAnalitSprTNKBPClassMTRAndS3.Analit
  and MBAnalit.TNKBPClassMTRAndS4 *= MBAnalitSprTNKBPClassMTRAndS4.Analit
  and MBAnalit.TNKBPClassMTRAndS5 *= MBAnalitSprTNKBPClassMTRAndS5.Analit
  and MBAnalit.TNKBPGroupService2 *= MBAnalitSprTNKBPGroupService2.Analit
  and MBAnalit.TNKBPGroupService3 *= MBAnalitSprTNKBPGroupService3.Analit
  and MBAnalit.TNKBPGroupService4 *= MBAnalitSprTNKBPGroupService4.Analit
  and MBAnalit.TNKBPGroupService5 *= MBAnalitSprTNKBPGroupService5.Analit
  and MBAnalit.TNKBPClassMTRAndS6 *= MBAnalitSprTNKBPClassMTRAndS6.Analit
  and MBAnalit.TNKBPClassMTRAndS7 *= MBAnalitSprTNKBPClassMTRAndS7.Analit
  and MBAnalit.TNKBPClassMTRAndS8 *= MBAnalitSprTNKBPClassMTRAndS8.Analit
  and MBAnalit.TNKBPClassMTRAndS9 *= MBAnalitSprTNKBPClassMTRAndS9.Analit
  and MBAnalit.TNKBPClassMTRAndS10 *= MBAnalitSprTNKBPClassMTRAndS10.Analit
  and MBAnalit.TNKBPSectorGroup *= MBAnalitSprTNKBPSectorGroup.Analit
  and MBAnalit.TNKBPCCLevel *= MBAnalitSprTNKBPCCLevel.Analit
  and MBAnalit.TNKBPCostOrigPlace *= MBAnalitSprTNKBPCostOrigPlace.Analit
  and MBAnalit.TNKBPBudgetOwner *= MBAnalitSprTNKBPBudgetOwner.Analit
  and MBAnalit.TNKBPCostDirection *= MBAnalitSprTNKBPCostDirection.Analit
  and MBAnalit.TNKBPCostKind *= MBAnalitSprTNKBPCostKind.Analit
  and MBAnalit.TNKBPProjectCode *= MBAnalitSprTNKBPProjectCode.Analit
  and MBAnalit.TNKBPArticleBud *= MBAnalitSprTNKBPArticleBud.Analit
  and MBAnalit.TNKBPAssociatedComp *= MBAnalitSprTNKBPAssociatedComp.Analit
  and MBAnalit.TNKBPPrequalContr *= MBAnalitSprTNKBPPrequalContr.Analit
  and MBAnalit.TNKBPAuthDelMatrix *= MBAnalitSprTNKBPAuthDelMatrix.Analit
  and MBAnalit.TNKBPAuthDelMatrix2 *= MBAnalitSprTNKBPAuthDelMatrix2.Analit
  and MBAnalit.TNKBPBusinessVector *= MBAnalitSprTNKBPBusinessVector.Analit
  and MBAnalit.TNKBPOwner *= MBAnalitSprTNKBPOwner.Analit
  and MBAnalit.TNKBPContractFormerC *= MBAnalitSprTNKBPContractFormerC.Analit
  and MBAnalit.TNKBPRegDocKinds *= MBAnalitSprTNKBPRegDocKinds.Analit
  and MBAnalit.TNKBPCollegiateOrgan *= MBAnalitSprTNKBPCollegiateOrgan.Analit
  and MBAnalit.TNKBPConformableDocs *= MBAnalitSprTNKBPConformableDocs.Analit
  and MBAnalit.Vid = 3321
order by
  MBAnalit.Analit