could not execute query [ SELECT this_.[Id] as column1_476_14_, this_.[SubDesignerId] as column2_476_14_, this_.[ShippingPriceCustomized] as column3_476_14_, this_.[PlanNumber] as column4_476_14_, this_.[PlanType] as column5_476_14_, this_.[ArchId] as column6_476_14_, this_.[PlanId] as column7_476_14_, this_.[TotalLivingArea] as column8_476_14_, this_.[F1] as column9_476_14_, this_.[F2] as column10_476_14_, this_.[F3] as column11_476_14_, this_.[OtherStories] as column12_476_14_, this_.[LowerLevelFinished] as column13_476_14_, this_.[MaxWidth] as column14_476_14_, this_.[MaxDepth] as column15_476_14_, this_.[NumberOfFullBathrooms] as column16_476_14_, this_.[NumberOfHalfBathrooms] as column17_476_14_, this_.[NumberOfStories] as column18_476_14_, this_.[GarageType] as column19_476_14_, this_.[GarageSize] as column20_476_14_, this_.[ExteriorWallSize] as column21_476_14_, this_.[ExteriorWallOther] as column22_476_14_, this_.[Conversion2x6] as column23_476_14_, this_.[TotalSquareFootage] as column24_476_14_, this_.[OnlineSales] as column25_476_14_, this_.[OfflineSales] as column26_476_14_, this_.[Bump] as column27_476_14_, this_.[BumpOffset] as column28_476_14_, this_.[EnteredDate] as column29_476_14_, this_.[IsTemporary] as column30_476_14_, this_.[HasVirtualTour] as column31_476_14_, this_.[Icf] as column32_476_14_, this_.[Created] as column33_476_14_, this_.[Deleted] as column34_476_14_, this_.[Approved] as column35_476_14_, this_.[DesignerId] as column36_476_14_, this_.[PriceId] as column37_476_14_, this_.[OnlineSales] + this_.[OfflineSales] + this_.[Bump] + this_.[BumpOffset] as formula14_14_, designer2_.[Id] as column1_484_0_, designer2_.[DesignerCode] as column2_484_0_, designer2_.[DesignerName] as column3_484_0_, designer2_.[Status] as column4_484_0_, designer2_.[EditorialAddress] as column5_484_0_, designer2_.[EditorialCity] as column6_484_0_, designer2_.[EditorialState] as column7_484_0_, designer2_.[EditorialZip] as column8_484_0_, designer2_.[FulfillmentAddress] as column9_484_0_, designer2_.[FulfillmentCity] as column10_484_0_, designer2_.[FulfillmentState] as column11_484_0_, designer2_.[FulfillmentZip] as column12_484_0_, designer2_.[DesignerEmailAddress] as column13_484_0_, designer2_.[DesignerWebSiteURL] as column14_484_0_, designer2_.[EditorialAddress2] as column15_484_0_, designer2_.[FulfillmentAddress2] as column16_484_0_, designer2_.[EditorialCountry] as column17_484_0_, designer2_.[EditorialBusinessPhoneNumber] as column18_484_0_, designer2_.[EditorialBusinessFaxNumber] as column19_484_0_, designer2_.[FulfillmentContactName] as column20_484_0_, designer2_.[FulfillmentEmailAddress] as column21_484_0_, designer2_.[FulfillmentPhoneNumber] as column22_484_0_, designer2_.[FulfillmentFaxNumber] as column23_484_0_, designer2_.[PrincipalName] as column24_484_0_, designer2_.[PrincipalPhoneNumber] as column25_484_0_, designer2_.[PrincipalAlternatePhoneNumber] as column26_484_0_, designer2_.[PrincipalEmailAddress] as column27_484_0_, designer2_.[AdminContactName] as column28_484_0_, designer2_.[AdminContactPhoneNumber] as column29_484_0_, designer2_.[AdminContactAlternatePhoneNumber] as column30_484_0_, designer2_.[AdminEmailAddress] as column31_484_0_, designer2_.[ReportContactName] as column32_484_0_, designer2_.[ReportContactPhoneNumber] as column33_484_0_, designer2_.[ReportContactAlternatePhoneNumber] as column34_484_0_, designer2_.[ReportEmailAddress] as column35_484_0_, designer2_.[MailingContactName] as column36_484_0_, designer2_.[MailingContactPhoneNumber] as column37_484_0_, designer2_.[MailingContactAlternatePhoneNumber] as column38_484_0_, designer2_.[MailingContactEmailAddress] as column39_484_0_, designer2_.[CADReleaseRequired] as column40_484_0_, designer2_.[BuildingLocationRequired] as column41_484_0_, designer2_.[ZipCodeAreaRestriction] as column42_484_0_, designer2_.[UnlimitedBuildLicense] as column43_484_0_, designer2_.[SellMaterialListWithoutPlanOrder] as column44_484_0_, designer2_.[Notes] as column45_484_0_, designer2_.[Policy] as column46_484_0_, designer2_.[Created] as column47_484_0_, designer2_.[Deleted] as column48_484_0_, archplanpr3_.[Id] as column1_517_1_, archplanpr3_.[PricingOption] as column2_517_1_, archplanpr3_.[PricingOptionValue] as column3_517_1_, archplanpr3_.[Created] as column4_517_1_, archplanpr3_.[PriceOfStudySet] as column5_517_1_, archplanpr3_.[PriceOfFiveSet] as column6_517_1_, archplanpr3_.[PriceOfEightSet] as column7_517_1_, archplanpr3_.[PriceOfReproduceableSet] as column8_517_1_, archplanpr3_.[PriceOfPDF] as column9_517_1_, archplanpr3_.[PriceOfCAD] as column10_517_1_, archplanpr3_.[PriceOfAdditionalFoundationChange] as column11_517_1_, archplanpr3_.[PriceOfAdditionalBasementChange] as column12_517_1_, archplanpr3_.[PriceOfAdditionalDaylightChange] as column13_517_1_, archplanpr3_.[PriceOfAdditionalSlabChange] as column14_517_1_, archplanpr3_.[PriceOfAdditionalCrawlChange] as column15_517_1_, archplanpr3_.[PriceOfFoundationChange] as column16_517_1_, archplanpr3_.[PriceOfMirrorReversalSet] as column17_517_1_, archplanpr3_.[PriceOfRightRearReverseSet] as column18_517_1_, archplanpr3_.[PriceOfRightRearReverseVellumSet] as column19_517_1_, archplanpr3_.[PriceOfML] as column20_517_1_, archplanpr3_.[PriceOfMLIfUnavailable] as column21_517_1_, archplanpr3_.[PriceOfConvert2x6Set] as column22_517_1_, archplanpr3_.[PriceOfRoofTruss] as column23_517_1_, archplanpr3_.[PriceOfMetricConversion] as column24_517_1_, archplanpr3_.[PriceOfAdditionalSet] as column25_517_1_, archplanpr3_.[PriceOfStudySetPerSqFoot] as column26_517_1_, archplanpr3_.[PriceOfFiveSetPerSqFoot] as column27_517_1_, archplanpr3_.[PriceOfEightSetPerSqFoot] as column28_517_1_, archplanpr3_.[PriceOfReproduceableSetPerSqFoot] as column29_517_1_, archplanpr3_.[PriceOfPdfPerSqFoot] as column30_517_1_, archplanpr3_.[PriceOfCadPerSqFoot] as column31_517_1_, archplanpr3_.[PriceOfBasementChangePerSqFoot] as column32_517_1_, archplanpr3_.[PriceOfCrawlChangePerSqFoot] as column33_517_1_, archplanpr3_.[PriceOfDaylightChangePerSqFoot] as column34_517_1_, archplanpr3_.[PriceOfFoundationChangePerSqFoot] as column35_517_1_, archplanpr3_.[PriceOfSlabChangePerSqFoot] as column36_517_1_, archplanpr3_.[PriceOfConvert2x6PerSqFoot] as column37_517_1_, archplanpr3_.[DesignerId] as column38_517_1_, archplansq4_.[Id] as column1_481_2_, archplansq4_.[Garage] as column2_481_2_, archplansq4_.[BasementUnfinished] as column3_481_2_, archplansq4_.[Bonus] as column4_481_2_, archplansq4_.[FrontPorch] as column5_481_2_, archplansq4_.[RearPorch] as column6_481_2_, archplansq4_.[ScreenedPorch] as column7_481_2_, archplansq4_.[PorchFront] as column8_481_2_, archplansq4_.[PorchRear] as column9_481_2_, archplansq4_.[PorchCombined] as column10_481_2_, archplansq4_.[Deck] as column11_481_2_, archplansq4_.[DeckAndPorch] as column12_481_2_, archplansq4_.[BalconyVeranda] as column13_481_2_, archplansq4_.[Lanai] as column14_481_2_, archplansq4_.[CoveredPatio] as column15_481_2_, archplansq4_.[Entry] as column16_481_2_, archplansq4_.[Storage] as column17_481_2_, archplansq4_.[Workshop] as column18_481_2_, archplansq4_.[Attic] as column19_481_2_, archplansq4_.[Loft] as column20_481_2_, archplansq4_.[Other] as column21_481_2_, archplansq4_.[OtherLabel] as column22_481_2_, archplansq4_.[TotalSquareFeet] as column23_481_2_, archplansq4_.[Created] as column24_481_2_, archplanop5_.[Id] as column1_521_3_, archplanop5_.[PlanName] as column2_521_3_, archplanop5_.[MaxRidgeHeight] as column3_521_3_, archplanop5_.[LowerLevelCeilingHeight] as column4_521_3_, archplanop5_.[FirstFloorCeilingHeight] as column5_521_3_, archplanop5_.[SecondFloorCeilingHeight] as column6_521_3_, archplanop5_.[Other] as column7_521_3_, archplanop5_.[OtherName] as column8_521_3_, archplanop5_.[PrimaryRoofPitch] as column9_521_3_, archplanop5_.[SecondaryRoofPitch] as column10_521_3_, archplanop5_.[RoofLoadLive] as column11_521_3_, archplanop5_.[RoofLoadDead] as column12_521_3_, archplanop5_.[RoofFramingType] as column13_521_3_, archplanop5_.[MaterialList] as column14_521_3_, archplanop5_.[Reproducible] as column15_521_3_, archplanop5_.[ReversePlan] as column16_521_3_, archplanop5_.[CadAvailable] as column17_521_3_, archplanop5_.[PDF] as column18_521_3_, archplanad6_.[Id] as column1_502_4_, archplanad6_.[Title] as column2_502_4_, archplanad6_.[Text] as column3_502_4_, archplanad6_.[RoomDimensions] as column4_502_4_, archplanad6_.[Description] as column5_502_4_, archplanad6_.[PlanCode] as column6_502_4_, archplanme7_.[Id] as column1_516_5_, archplanme7_.Title as Title516_5_, archplanme7_.MetaTags as MetaTags516_5_, archplanme7_.MetaDescription as MetaDesc4_516_5_, attributes8_.[ArchPlanId] as column2___16_, attributes8_.[Id] as column1_16_, attributes8_.[Id] as column1_475_6_, attributes8_.[ArchPlanId] as column2_475_6_, attributes8_.[TypeId] as column3_475_6_, attributes8_.[ValueId] as column4_475_6_, archplanat9_.[Id] as column1_487_7_, archplanat9_.[Name] as column2_487_7_, archplanat9_.[Code] as column3_487_7_, archplanat9_.[Style] as column4_487_7_, archplanat9_.[IsSearchable] as column5_487_7_, archplanat9_.[Sequence] as column6_487_7_, categories10_.[ArchPlanId] as column1___17_, archplanca11_.[Id] as column2_17_, archplanca11_.[Id] as column1_490_8_, archplanca11_.[Name] as column2_490_8_, archplanca11_.[Code] as column3_490_8_, archplanca11_.[HomePageLocation] as column4_490_8_, archplanca11_.[SamplePlanNumber] as column5_490_8_, archplanca11_.[Seo] as column6_490_8_, archplanca11_.[Status] as column7_490_8_, archplanca11_.[ShortDescription] as column8_490_8_, archplanca11_.[LongDescription] as column9_490_8_, archplanca11_.[IsSupplementalStyle] as column10_490_8_, archplanca11_.[Deleted] as column11_490_8_, archplanca12_.[Id] as column1_489_9_, archplanca12_.Title as Title489_9_, archplanca12_.MetaTags as MetaTags489_9_, archplanca12_.MetaDescription as MetaDesc4_489_9_, numberofbe13_.[ArchPlanId] as column1___18_, archplanbe14_.[Id] as column2_18_, archplanbe14_.[Id] as column1_494_10_, archplanbe14_.[Name] as column2_494_10_, archplanbe14_.[Code] as column3_494_10_, foundation15_.[PlanId] as column1___19_, foundation16_.[Id] as column2_19_, foundation16_.[Id] as column1_495_11_, foundation16_.[Name] as column2_495_11_, foundation16_.[Code] as column3_495_11_, foundation16_.[Index] as column4_495_11_, foundation16_.[AltIndex] as column5_495_11_, altfoundat17_.[PlanId] as column1___20_, foundation18_.[Id] as column2_20_, foundation18_.[Id] as column1_495_12_, foundation18_.[Name] as column2_495_12_, foundation18_.[Code] as column3_495_12_, foundation18_.[Index] as column4_495_12_, foundation18_.[AltIndex] as column5_495_12_, ceilinghei19_.[ArchPlanId] as column5___21_, ceilinghei19_.[Id] as column1_21_, ceilinghei19_.[Id] as column1_522_13_, ceilinghei19_.[Room] as column2_522_13_, ceilinghei19_.[RoomType] as column3_522_13_, ceilinghei19_.[Height] as column4_522_13_, ceilinghei19_.[ArchPlanId] as column5_522_13_ FROM [ArchPlans] this_ left outer join [Designers] designer2_ on this_.[DesignerId]=designer2_.[Id] left outer join [ArchPlanPrices] archplanpr3_ on this_.[PriceId]=archplanpr3_.[Id] left outer join [ArchPlanSquareFootage] archplansq4_ on this_.[Id]=archplansq4_.[Id] left outer join [ArchPlanOptionalInformation] archplanop5_ on this_.[Id]=archplanop5_.[Id] left outer join [ArchPlanAdditionalInformation] archplanad6_ on this_.[Id]=archplanad6_.[Id] left outer join [ArchPlanMetaTags] archplanme7_ on this_.[Id]=archplanme7_.[Id] left outer join [ArchPlanAttributes] attributes8_ on this_.[Id]=attributes8_.[ArchPlanId] left outer join [ArchPlanAttributeTypes] archplanat9_ on attributes8_.[TypeId]=archplanat9_.[Id] left outer join [ArchPlansByCategories] categories10_ on this_.[Id]=categories10_.[ArchPlanId] left outer join [ArchPlanCategories] archplanca11_ on categories10_.[ArchPlanCategoryId]=archplanca11_.[Id] left outer join [ArchPlanCategoryMetaTags] archplanca12_ on archplanca11_.[Id]=archplanca12_.[Id] left outer join [ArchPlansByBedroomNumbers] numberofbe13_ on this_.[Id]=numberofbe13_.[ArchPlanId] left outer join [ArchPlanBedroomNumbers] archplanbe14_ on numberofbe13_.[ArchPlanBedroomNumberId]=archplanbe14_.[Id] left outer join [ArchPlan2Foundation] foundation15_ on this_.[Id]=foundation15_.[PlanId] left outer join [Foundation] foundation16_ on foundation15_.[FoundationId]=foundation16_.[Id] left outer join [ArchPlan2AltFoundation] altfoundat17_ on this_.[Id]=altfoundat17_.[PlanId] left outer join [Foundation] foundation18_ on altfoundat17_.[FoundationId]=foundation18_.[Id] left outer join ArchPlanCeilingHeights ceilinghei19_ on this_.[Id]=ceilinghei19_.[ArchPlanId] WHERE this_.[PlanNumber] = ? and this_.[Deleted] is null ] Positional parameters: 0 21413dr [SQL: SELECT this_.[Id] as column1_476_14_, this_.[SubDesignerId] as column2_476_14_, this_.[ShippingPriceCustomized] as column3_476_14_, this_.[PlanNumber] as column4_476_14_, this_.[PlanType] as column5_476_14_, this_.[ArchId] as column6_476_14_, this_.[PlanId] as column7_476_14_, this_.[TotalLivingArea] as column8_476_14_, this_.[F1] as column9_476_14_, this_.[F2] as column10_476_14_, this_.[F3] as column11_476_14_, this_.[OtherStories] as column12_476_14_, this_.[LowerLevelFinished] as column13_476_14_, this_.[MaxWidth] as column14_476_14_, this_.[MaxDepth] as column15_476_14_, this_.[NumberOfFullBathrooms] as column16_476_14_, this_.[NumberOfHalfBathrooms] as column17_476_14_, this_.[NumberOfStories] as column18_476_14_, this_.[GarageType] as column19_476_14_, this_.[GarageSize] as column20_476_14_, this_.[ExteriorWallSize] as column21_476_14_, this_.[ExteriorWallOther] as column22_476_14_, this_.[Conversion2x6] as column23_476_14_, this_.[TotalSquareFootage] as column24_476_14_, this_.[OnlineSales] as column25_476_14_, this_.[OfflineSales] as column26_476_14_, this_.[Bump] as column27_476_14_, this_.[BumpOffset] as column28_476_14_, this_.[EnteredDate] as column29_476_14_, this_.[IsTemporary] as column30_476_14_, this_.[HasVirtualTour] as column31_476_14_, this_.[Icf] as column32_476_14_, this_.[Created] as column33_476_14_, this_.[Deleted] as column34_476_14_, this_.[Approved] as column35_476_14_, this_.[DesignerId] as column36_476_14_, this_.[PriceId] as column37_476_14_, this_.[OnlineSales] + this_.[OfflineSales] + this_.[Bump] + this_.[BumpOffset] as formula14_14_, designer2_.[Id] as column1_484_0_, designer2_.[DesignerCode] as column2_484_0_, designer2_.[DesignerName] as column3_484_0_, designer2_.[Status] as column4_484_0_, designer2_.[EditorialAddress] as column5_484_0_, designer2_.[EditorialCity] as column6_484_0_, designer2_.[EditorialState] as column7_484_0_, designer2_.[EditorialZip] as column8_484_0_, designer2_.[FulfillmentAddress] as column9_484_0_, designer2_.[FulfillmentCity] as column10_484_0_, designer2_.[FulfillmentState] as column11_484_0_, designer2_.[FulfillmentZip] as column12_484_0_, designer2_.[DesignerEmailAddress] as column13_484_0_, designer2_.[DesignerWebSiteURL] as column14_484_0_, designer2_.[EditorialAddress2] as column15_484_0_, designer2_.[FulfillmentAddress2] as column16_484_0_, designer2_.[EditorialCountry] as column17_484_0_, designer2_.[EditorialBusinessPhoneNumber] as column18_484_0_, designer2_.[EditorialBusinessFaxNumber] as column19_484_0_, designer2_.[FulfillmentContactName] as column20_484_0_, designer2_.[FulfillmentEmailAddress] as column21_484_0_, designer2_.[FulfillmentPhoneNumber] as column22_484_0_, designer2_.[FulfillmentFaxNumber] as column23_484_0_, designer2_.[PrincipalName] as column24_484_0_, designer2_.[PrincipalPhoneNumber] as column25_484_0_, designer2_.[PrincipalAlternatePhoneNumber] as column26_484_0_, designer2_.[PrincipalEmailAddress] as column27_484_0_, designer2_.[AdminContactName] as column28_484_0_, designer2_.[AdminContactPhoneNumber] as column29_484_0_, designer2_.[AdminContactAlternatePhoneNumber] as column30_484_0_, designer2_.[AdminEmailAddress] as column31_484_0_, designer2_.[ReportContactName] as column32_484_0_, designer2_.[ReportContactPhoneNumber] as column33_484_0_, designer2_.[ReportContactAlternatePhoneNumber] as column34_484_0_, designer2_.[ReportEmailAddress] as column35_484_0_, designer2_.[MailingContactName] as column36_484_0_, designer2_.[MailingContactPhoneNumber] as column37_484_0_, designer2_.[MailingContactAlternatePhoneNumber] as column38_484_0_, designer2_.[MailingContactEmailAddress] as column39_484_0_, designer2_.[CADReleaseRequired] as column40_484_0_, designer2_.[BuildingLocationRequired] as column41_484_0_, designer2_.[ZipCodeAreaRestriction] as column42_484_0_, designer2_.[UnlimitedBuildLicense] as column43_484_0_, designer2_.[SellMaterialListWithoutPlanOrder] as column44_484_0_, designer2_.[Notes] as column45_484_0_, designer2_.[Policy] as column46_484_0_, designer2_.[Created] as column47_484_0_, designer2_.[Deleted] as column48_484_0_, archplanpr3_.[Id] as column1_517_1_, archplanpr3_.[PricingOption] as column2_517_1_, archplanpr3_.[PricingOptionValue] as column3_517_1_, archplanpr3_.[Created] as column4_517_1_, archplanpr3_.[PriceOfStudySet] as column5_517_1_, archplanpr3_.[PriceOfFiveSet] as column6_517_1_, archplanpr3_.[PriceOfEightSet] as column7_517_1_, archplanpr3_.[PriceOfReproduceableSet] as column8_517_1_, archplanpr3_.[PriceOfPDF] as column9_517_1_, archplanpr3_.[PriceOfCAD] as column10_517_1_, archplanpr3_.[PriceOfAdditionalFoundationChange] as column11_517_1_, archplanpr3_.[PriceOfAdditionalBasementChange] as column12_517_1_, archplanpr3_.[PriceOfAdditionalDaylightChange] as column13_517_1_, archplanpr3_.[PriceOfAdditionalSlabChange] as column14_517_1_, archplanpr3_.[PriceOfAdditionalCrawlChange] as column15_517_1_, archplanpr3_.[PriceOfFoundationChange] as column16_517_1_, archplanpr3_.[PriceOfMirrorReversalSet] as column17_517_1_, archplanpr3_.[PriceOfRightRearReverseSet] as column18_517_1_, archplanpr3_.[PriceOfRightRearReverseVellumSet] as column19_517_1_, archplanpr3_.[PriceOfML] as column20_517_1_, archplanpr3_.[PriceOfMLIfUnavailable] as column21_517_1_, archplanpr3_.[PriceOfConvert2x6Set] as column22_517_1_, archplanpr3_.[PriceOfRoofTruss] as column23_517_1_, archplanpr3_.[PriceOfMetricConversion] as column24_517_1_, archplanpr3_.[PriceOfAdditionalSet] as column25_517_1_, archplanpr3_.[PriceOfStudySetPerSqFoot] as column26_517_1_, archplanpr3_.[PriceOfFiveSetPerSqFoot] as column27_517_1_, archplanpr3_.[PriceOfEightSetPerSqFoot] as column28_517_1_, archplanpr3_.[PriceOfReproduceableSetPerSqFoot] as column29_517_1_, archplanpr3_.[PriceOfPdfPerSqFoot] as column30_517_1_, archplanpr3_.[PriceOfCadPerSqFoot] as column31_517_1_, archplanpr3_.[PriceOfBasementChangePerSqFoot] as column32_517_1_, archplanpr3_.[PriceOfCrawlChangePerSqFoot] as column33_517_1_, archplanpr3_.[PriceOfDaylightChangePerSqFoot] as column34_517_1_, archplanpr3_.[PriceOfFoundationChangePerSqFoot] as column35_517_1_, archplanpr3_.[PriceOfSlabChangePerSqFoot] as column36_517_1_, archplanpr3_.[PriceOfConvert2x6PerSqFoot] as column37_517_1_, archplanpr3_.[DesignerId] as column38_517_1_, archplansq4_.[Id] as column1_481_2_, archplansq4_.[Garage] as column2_481_2_, archplansq4_.[BasementUnfinished] as column3_481_2_, archplansq4_.[Bonus] as column4_481_2_, archplansq4_.[FrontPorch] as column5_481_2_, archplansq4_.[RearPorch] as column6_481_2_, archplansq4_.[ScreenedPorch] as column7_481_2_, archplansq4_.[PorchFront] as column8_481_2_, archplansq4_.[PorchRear] as column9_481_2_, archplansq4_.[PorchCombined] as column10_481_2_, archplansq4_.[Deck] as column11_481_2_, archplansq4_.[DeckAndPorch] as column12_481_2_, archplansq4_.[BalconyVeranda] as column13_481_2_, archplansq4_.[Lanai] as column14_481_2_, archplansq4_.[CoveredPatio] as column15_481_2_, archplansq4_.[Entry] as column16_481_2_, archplansq4_.[Storage] as column17_481_2_, archplansq4_.[Workshop] as column18_481_2_, archplansq4_.[Attic] as column19_481_2_, archplansq4_.[Loft] as column20_481_2_, archplansq4_.[Other] as column21_481_2_, archplansq4_.[OtherLabel] as column22_481_2_, archplansq4_.[TotalSquareFeet] as column23_481_2_, archplansq4_.[Created] as column24_481_2_, archplanop5_.[Id] as column1_521_3_, archplanop5_.[PlanName] as column2_521_3_, archplanop5_.[MaxRidgeHeight] as column3_521_3_, archplanop5_.[LowerLevelCeilingHeight] as column4_521_3_, archplanop5_.[FirstFloorCeilingHeight] as column5_521_3_, archplanop5_.[SecondFloorCeilingHeight] as column6_521_3_, archplanop5_.[Other] as column7_521_3_, archplanop5_.[OtherName] as column8_521_3_, archplanop5_.[PrimaryRoofPitch] as column9_521_3_, archplanop5_.[SecondaryRoofPitch] as column10_521_3_, archplanop5_.[RoofLoadLive] as column11_521_3_, archplanop5_.[RoofLoadDead] as column12_521_3_, archplanop5_.[RoofFramingType] as column13_521_3_, archplanop5_.[MaterialList] as column14_521_3_, archplanop5_.[Reproducible] as column15_521_3_, archplanop5_.[ReversePlan] as column16_521_3_, archplanop5_.[CadAvailable] as column17_521_3_, archplanop5_.[PDF] as column18_521_3_, archplanad6_.[Id] as column1_502_4_, archplanad6_.[Title] as column2_502_4_, archplanad6_.[Text] as column3_502_4_, archplanad6_.[RoomDimensions] as column4_502_4_, archplanad6_.[Description] as column5_502_4_, archplanad6_.[PlanCode] as column6_502_4_, archplanme7_.[Id] as column1_516_5_, archplanme7_.Title as Title516_5_, archplanme7_.MetaTags as MetaTags516_5_, archplanme7_.MetaDescription as MetaDesc4_516_5_, attributes8_.[ArchPlanId] as column2___16_, attributes8_.[Id] as column1_16_, attributes8_.[Id] as column1_475_6_, attributes8_.[ArchPlanId] as column2_475_6_, attributes8_.[TypeId] as column3_475_6_, attributes8_.[ValueId] as column4_475_6_, archplanat9_.[Id] as column1_487_7_, archplanat9_.[Name] as column2_487_7_, archplanat9_.[Code] as column3_487_7_, archplanat9_.[Style] as column4_487_7_, archplanat9_.[IsSearchable] as column5_487_7_, archplanat9_.[Sequence] as column6_487_7_, categories10_.[ArchPlanId] as column1___17_, archplanca11_.[Id] as column2_17_, archplanca11_.[Id] as column1_490_8_, archplanca11_.[Name] as column2_490_8_, archplanca11_.[Code] as column3_490_8_, archplanca11_.[HomePageLocation] as column4_490_8_, archplanca11_.[SamplePlanNumber] as column5_490_8_, archplanca11_.[Seo] as column6_490_8_, archplanca11_.[Status] as column7_490_8_, archplanca11_.[ShortDescription] as column8_490_8_, archplanca11_.[LongDescription] as column9_490_8_, archplanca11_.[IsSupplementalStyle] as column10_490_8_, archplanca11_.[Deleted] as column11_490_8_, archplanca12_.[Id] as column1_489_9_, archplanca12_.Title as Title489_9_, archplanca12_.MetaTags as MetaTags489_9_, archplanca12_.MetaDescription as MetaDesc4_489_9_, numberofbe13_.[ArchPlanId] as column1___18_, archplanbe14_.[Id] as column2_18_, archplanbe14_.[Id] as column1_494_10_, archplanbe14_.[Name] as column2_494_10_, archplanbe14_.[Code] as column3_494_10_, foundation15_.[PlanId] as column1___19_, foundation16_.[Id] as column2_19_, foundation16_.[Id] as column1_495_11_, foundation16_.[Name] as column2_495_11_, foundation16_.[Code] as column3_495_11_, foundation16_.[Index] as column4_495_11_, foundation16_.[AltIndex] as column5_495_11_, altfoundat17_.[PlanId] as column1___20_, foundation18_.[Id] as column2_20_, foundation18_.[Id] as column1_495_12_, foundation18_.[Name] as column2_495_12_, foundation18_.[Code] as column3_495_12_, foundation18_.[Index] as column4_495_12_, foundation18_.[AltIndex] as column5_495_12_, ceilinghei19_.[ArchPlanId] as column5___21_, ceilinghei19_.[Id] as column1_21_, ceilinghei19_.[Id] as column1_522_13_, ceilinghei19_.[Room] as column2_522_13_, ceilinghei19_.[RoomType] as column3_522_13_, ceilinghei19_.[Height] as column4_522_13_, ceilinghei19_.[ArchPlanId] as column5_522_13_ FROM [ArchPlans] this_ left outer join [Designers] designer2_ on this_.[DesignerId]=designer2_.[Id] left outer join [ArchPlanPrices] archplanpr3_ on this_.[PriceId]=archplanpr3_.[Id] left outer join [ArchPlanSquareFootage] archplansq4_ on this_.[Id]=archplansq4_.[Id] left outer join [ArchPlanOptionalInformation] archplanop5_ on this_.[Id]=archplanop5_.[Id] left outer join [ArchPlanAdditionalInformation] archplanad6_ on this_.[Id]=archplanad6_.[Id] left outer join [ArchPlanMetaTags] archplanme7_ on this_.[Id]=archplanme7_.[Id] left outer join [ArchPlanAttributes] attributes8_ on this_.[Id]=attributes8_.[ArchPlanId] left outer join [ArchPlanAttributeTypes] archplanat9_ on attributes8_.[TypeId]=archplanat9_.[Id] left outer join [ArchPlansByCategories] categories10_ on this_.[Id]=categories10_.[ArchPlanId] left outer join [ArchPlanCategories] archplanca11_ on categories10_.[ArchPlanCategoryId]=archplanca11_.[Id] left outer join [ArchPlanCategoryMetaTags] archplanca12_ on archplanca11_.[Id]=archplanca12_.[Id] left outer join [ArchPlansByBedroomNumbers] numberofbe13_ on this_.[Id]=numberofbe13_.[ArchPlanId] left outer join [ArchPlanBedroomNumbers] archplanbe14_ on numberofbe13_.[ArchPlanBedroomNumberId]=archplanbe14_.[Id] left outer join [ArchPlan2Foundation] foundation15_ on this_.[Id]=foundation15_.[PlanId] left outer join [Foundation] foundation16_ on foundation15_.[FoundationId]=foundation16_.[Id] left outer join [ArchPlan2AltFoundation] altfoundat17_ on this_.[Id]=altfoundat17_.[PlanId] left outer join [Foundation] foundation18_ on altfoundat17_.[FoundationId]=foundation18_.[Id] left outer join ArchPlanCeilingHeights ceilinghei19_ on this_.[Id]=ceilinghei19_.[ArchPlanId] WHERE this_.[PlanNumber] = ? and this_.[Deleted] is null]