Unknown column 'BasementHasCrawlspaceYN' in 'field list'SELECT `AcceptingBackupOffersYN`, `AdditionalInformation` AS desc2, `ArchitecturalStyle` AS style, `AssociationFeeFrequencyPrimary`, `AssociationFeeFrequencySecondary`, `AssociationFeeFrequencyTertiary`, `AssociationFeeIncludes`, `AssociationFeePrimary` AS total_hoa_fees, `AssociationFeeSecondary`, `AssociationFeeTertiary`, `AssociationNamePrimary`, `AssociationPhonePrimary`, `AuctionPrice`, `AvailableAmps`, `BasementCeilingHeight`, `BasementFinishedYN`, `BasementFloorType`, `BasementHasCrawlspaceYN`, `BasementPercentFinished` AS percent_bsmt_finished, `BasementSize` AS basement, `BasementType`, `BathsFull` AS FullBaths, `BathsHalf` AS HalfBaths, `BathsQuarter` AS RoughInBaths, `BathsThreeQuarter` AS ThreeQuarterBaths, `BathsTotal` AS baths_total, `BedsTotal` AS bedrooms_total, `BuilderName1`, `BuilderName2`, `BuildingAreaSource`, `BuildingName`, `City` AS city, `CloseDate`, `ClosePrice`, `CoListAgent_MUI`, `CoListAgentDirectWorkPhone`, `CoListAgentEmail`, `CoListAgentFullName`, `CoListAgentMLSID`, `CoListOffice_MUI`, `CoListOfficeMLSID`, `CoListOfficeName`, `CoListOfficePhone`, `CondoFloorLocation`, `CondoFloorLocationType`, `CondoUnitOnEndYN`, CONCAT_WS(' ', `ConstructionDetails`, `ConstructionMaterials`, `ConstructionMethods`) AS construction, `ContingentApprovalConditions`, `ContractAddlTerms`, `Cooling`, `Country`, `CountyOrParish` AS tax_county_code, `Directions`, `DistanceToBus`, `DistanceToLightRail`, `DistanceToOtherTransit`, `DistanceToPublicTransport`, `ElementarySchool` AS elementary, `ExteriorFeatures`, `FacesDirection`, `FireplaceFeatures`, `FireplaceLocations`, `Flooring`, `GarageSpacesCount`, `GasType`, `GreenCertification`, `GreenEnergyStarQualifiedYearCertified`, `GreenFeatures`, `GreenHasEnergyGreenFeaturesAddendumYN`, `GreenHERSScore`, `GreenHERSYearCertified`, `GreenLEEDCertifiedLevel`, `GreenLEEDYearCertified`, `GreenNGBSICC700CertifiedLevel`, `GreenNGBSICC700YearCertified`, `GreenOtherCertifications`, `GreenSolarKilowatts`, `GreenSolarPVYearCertified`, `GreenSolarThermalType`, `GreenSolarThermalYearCertified`, `HasHOAYN`, `HasMultipleHOAsYN`, `Heating` AS heat, `HeatingFuel`, `HighSchool` AS sr_high, `HorseFacilityCount`, `HorsePropertyYN`, `HorsePropertyFeatures`, `InteriorFeatures`, `IsIncorporatedYN`, `KitchenAppliances`, `Latitude`, `LaundryAvailability`, `ListAgent_MUI`, `ListAgentDirectWorkPhone`, `ListAgentEmail`, `ListAgentFullName`, `ListAgentMLSID`, `ListingFinancing`, `ListOffice_MUI`, `ListOfficeMLSID`, `ListOfficeName` AS office_name, `ListOfficePhone`, `ListPrice` AS price, `LivestockYN`, `Longitude`, `LotSizeAcres` AS lot_size, `LotSizeDimensions`, `LotSizeSqFt`, `Matrix_Unique_ID`, `MatrixModifiedDT`, `MiddleOrJuniorSchool` AS jr_high_middle, `MLSNumber` AS listing_num, `Model`, `Neighborhood` AS sub_area, `NumberOfFireplaces`, `OtherHVAC`, `OutBuildingCount`, `OutBuildingsYN`, `OutdoorArenaSQFT`, `PaddocksSQFT`, `ParcelNumber`, `ParkingCount`, `ParkingFeatures`, `ParkingTotalSearchable` AS spaces, `PhotoCount`, `PhotoModificationTimestamp`, `PostalCode` AS zip_code, `PostalCodePlus4`, `PPA` , `PrimaryAccessLocation`, `PropertySubType`, `PropertyType`, `PublicRemarks` AS public_remarks, `Restrictions`, `RestrictionsOther`, `Roof`, `RoughInYN`, `SchoolDistrict` AS school_district, `SellerType`, `Sewer`, `SiteFeatures`, `SiteType`, `SqFtAbove`, `SqFtBasement`, `SqFtDateMeasured`, `SqFtFinished` AS finish_sqft_tot, `SqFtLower`, `SqFtMain`, `SqFtOther`, `SqFtTotal` AS total_square_ft, `SqFtUpper`, `StateOrProvince`, `Status` AS status, `StatusChangeTimestamp`, `StatusConditions`, `StreetBuildingNumber`, `StreetDirPrefix` AS ad_direction, `StreetName` AS street_name, `StreetNumber` AS address_num, `StreetNumberSearchable`, `StreetSuffix` AS st_type, `StructuralStyle`, `StyleCharacteristics`, `TaxAmount` AS taxes, `TaxYear`, `TransactionType`, `UnderContractDate`, `UnitAccess`, `UnitCount`, `UnitNumber` AS unit_number, `UnitNumberOfFloors`, `View`, `VirtualTourURLUnbranded` AS tour_url, `VirtualTourURLUnbranded2`, `VirtualTourURLUnbranded3`, `WaterMineralRights`, `WaterSource`, `WaterTapFee`, `WaterTapPaidYN`, `WellDepth`, `WellType`, `WellUsage`, `YearBuilt` AS year, `Zoning` FROM `geodigsV1`.`Metrolist_Residential` WHERE `MLSNumber` = 4828635