SELECT
    [Extent1].[AccountAdoptionId] AS [AccountAdoptionId],
    [Extent1].[PublicationDetailId] AS [PublicationDetailId],
    [Extent1].[CompanyFilingNo] AS [CompanyFilingNo],
    [Extent1].[CompanyEffectiveDate] AS [CompanyEffectiveDate],
    [Extent1].[AdoptionMethodId] AS [AdoptionMethodId],
    [Extent1].[ExpectedFileDate] AS [ExpectedFileDate],
    [Extent1].[FilingActionId] AS [FilingActionId],
    [Extent1].[IsFilingActionNA] AS [IsFilingActionNA],
    [Extent1].[CreatedBy] AS [CreatedBy],
    [Extent1].[CreatedOn] AS [CreatedOn],
    [Extent1].[UpdatedBy] AS [UpdatedBy],
    [Extent1].[UpdatedOn] AS [UpdatedOn],
    [Extent1].[Is_Deleted] AS [Is_Deleted],
    [Extent1].[DeletionReason] AS [DeletionReason],
    [Extent1].[DeletionBy] AS [DeletionBy],
    [Extent1].[DeletionDate] AS [DeletionDate],
    [Extent1].[CompanyId] AS [CompanyId],
    [Extent2].[PublicationDetailId] AS [PublicationDetailId1],
    [Extent2].[PublicationId] AS [PublicationId],
    [Extent2].[CircularTypeId] AS [CircularTypeId],
    [Extent2].[LOBId] AS [LOBId],
    [Extent2].[StateCode] AS [StateCode],
    [Extent2].[ReferenceFilingNo] AS [ReferenceFilingNo],
    [Extent2].[DOINumber] AS [DOINumber],
    [Extent2].[BureauEffectiveDate] AS [BureauEffectiveDate],
    [Extent2].[BureauCompanyActionId] AS [BureauCompanyActionId],
    [Extent2].[IsActive] AS [IsActive],
    [Extent2].[BureauEffectiveDateStatus] AS [BureauEffectiveDateStatus],
    [Extent2].[Comments] AS [Comments],
    [Extent2].[IsAdoption] AS [IsAdoption],
    [Extent2].[IsNewCreated] AS [IsNewCreated],
    [Extent2].[CreatedBy] AS [CreatedBy1],
    [Extent2].[CreatedOn] AS [CreatedOn1],
    [Extent2].[UpdatedBy] AS [UpdatedBy1],
    [Extent2].[UpdatedOn] AS [UpdatedOn1],
    [Extent2].[CLSubLine] AS [CLSubLine],
    [Extent2].[ILSubLine] AS [ILSubLine],
    [Extent2].[MLSubLine] AS [MLSubLine],
    [Extent2].[MandatoryEffectiveDate] AS [MandatoryEffectiveDate],
    [Extent3].[PublicationId] AS [PublicationId1],
    [Extent3].[BureauId] AS [BureauId],
    [Extent3].[Title] AS [Title],
    [Extent3].[PublicationNo] AS [PublicationNo],
    [Extent3].[PriorPublicationNo] AS [PriorPublicationNo],
    [Extent3].[BureauPublicationDate] AS [BureauPublicationDate],
    [Extent3].[BMCPublicationDate] AS [BMCPublicationDate],
    [Extent3].[URL] AS [URL],
    [Extent3].[Summary] AS [Summary],
    [Extent3].[PublicationStatusId] AS [PublicationStatusId],
    [Extent3].[BureauActionId] AS [BureauActionId],
    [Extent3].[CompanionCircularNo] AS [CompanionCircularNo],
    [Extent3].[Toi] AS [Toi],
    [Extent3].[SubToi] AS [SubToi],
    [Extent3].[SpecialTopicIds] AS [SpecialTopicIds],
    [Extent3].[Countrywide] AS [Countrywide],
    [Extent3].[IsPublicationActive] AS [IsPublicationActive],
    [Extent3].[ReferenceFilingNo] AS [ReferenceFilingNo1],
    [Extent3].[DOINumber] AS [DOINumber1],
    [Extent3].[CreatedBy] AS [CreatedBy2],
    [Extent3].[CreatedOn] AS [CreatedOn2],
    [Extent3].[UpdatedBy] AS [UpdatedBy2],
    [Extent3].[UpdatedOn] AS [UpdatedOn2],
    [Extent3].[DeletionReason] AS [DeletionReason1],
    [Extent3].[DeletionBy] AS [DeletionBy1],
    [Extent3].[DeletionDate] AS [DeletionDate1],
    [Extent3].[CompanyProgramIds] AS [CompanyProgramIds],
    [Extent4].[CircularTypeId] AS [CircularTypeId1],
    [Extent4].[Name] AS [Name],
    [Extent5].[LOBId] AS [LOBId1],
    [Extent5].[LOBName] AS [LOBName],
    [Extent5].[CreatedBy] AS [CreatedBy3],
    [Extent5].[CreatedOn] AS [CreatedOn3],
    [Extent5].[UpdatedBy] AS [UpdatedBy3],
    [Extent5].[UpdatedOn] AS [UpdatedOn3],
    [Extent7].[BureauCompanyActionId] AS [BureauCompanyActionId1],
    [Extent7].[Name] AS [Name1],
    [Extent8].[BureauId] AS [BureauId1],
    [Extent8].[BureauName] AS [BureauName],
    [Extent8].[BureauCode] AS [BureauCode],
    [Extent8].[BureauDescription] AS [BureauDescription],
    [Extent8].[URL] AS [URL1],
    [Extent8].[OrganizationType] AS [OrganizationType],
    [Extent8].[AccountId] AS [AccountId],
    [Extent8].[CreatedBy] AS [CreatedBy4],
    [Extent8].[CreatedOn] AS [CreatedOn4],
    [Extent8].[UpdatedBy] AS [UpdatedBy4],
    [Extent8].[UpdatedOn] AS [UpdatedOn4],
    [Extent9].[PublicationStatusId] AS [PublicationStatusId1],
    [Extent9].[Name] AS [Name2],
    [Extent6].[BureauActionId] AS [BureauActionId1],
    [Extent6].[Name] AS [Name3],
    [Extent10].[BMC_Company_Id] AS [BMC_Company_Id],
    [Extent10].[NAIC_Company_No] AS [NAIC_Company_No],
    [Extent10].[NAIC_Company_Name] AS [NAIC_Company_Name],
    [Extent10].[CompanyFein] AS [CompanyFein],
    [Extent10].[SerffCompanyName] AS [SerffCompanyName],
    [Extent10].[Comments] AS [Comments1],
    [Extent10].[Source] AS [Source],
    [Extent10].[Current_Fl] AS [Current_Fl],
    [Extent10].[NAIC_Group_No] AS [NAIC_Group_No],
    [Extent10].[Created_By] AS [Created_By],
    [Extent10].[Created_Dt] AS [Created_Dt],
    [Extent10].[Updated_By] AS [Updated_By],
    [Extent10].[Updated_Dt] AS [Updated_Dt],
    [Extent10].[NAICShortName] AS [NAICShortName],
    [Extent10].[StreetAddress1] AS [StreetAddress1],
    [Extent10].[StreetAddress2] AS [StreetAddress2],
    [Extent10].[Phone] AS [Phone],
    [Extent10].[IsSerffCompany] AS [IsSerffCompany],
    [Extent11].[AdoptionMethodId] AS [AdoptionMethodId1],
    [Extent11].[Name] AS [Name4]
    FROM           [dbo].[AccountsAdoptions] AS [Extent1]
    INNER JOIN [dbo].[PublicationDetails] AS [Extent2] ON [Extent1].[PublicationDetailId] = [Extent2].[PublicationDetailId]
    INNER JOIN [dbo].[Publications] AS [Extent3] ON [Extent2].[PublicationId] = [Extent3].[PublicationId]
    INNER JOIN [dbo].[Lookup_CircularTypes] AS [Extent4] ON [Extent2].[CircularTypeId] = [Extent4].[CircularTypeId]
    INNER JOIN [dbo].[Bureau_LineOfBusinesses] AS [Extent5] ON [Extent2].[LOBId] = [Extent5].[LOBId]
    INNER JOIN [dbo].[Lookup_BureauActions] AS [Extent6] ON [Extent3].[BureauActionId] = [Extent6].[BureauActionId]
    INNER JOIN [dbo].[Lookup_BureauCompanyActions] AS [Extent7] ON [Extent2].[BureauCompanyActionId] = [Extent7].[BureauCompanyActionId]
    INNER JOIN [dbo].[Bureaus] AS [Extent8] ON [Extent3].[BureauId] = [Extent8].[BureauId]
    INNER JOIN [dbo].[Lookup_PublicationStatuses] AS [Extent9] ON [Extent3].[PublicationStatusId] = [Extent9].[PublicationStatusId]
    INNER JOIN [dbo].[BMC_Company] AS [Extent10] ON [Extent1].[CompanyId] = [Extent10].[BMC_Company_Id]
    INNER JOIN [dbo].[Lookup_AdoptionMethods] AS [Extent11] ON [Extent1].[AdoptionMethodId] = [Extent11].[AdoptionMethodId]
    WHERE (0 = [Extent1].[Is_Deleted]) AND ([Extent2].[IsActive] = 1) AND ([Extent2].[PublicationDetailId] = 308134) AND ([Extent10].[NAIC_Company_No] = 25143)