Unknown column 'BathsFull' in 'field list'SELECT `AcceptingBackupOffersYN`, `AdditionalInformation` AS desc2, `AnnualExpenseActual`, `AnnualExpenseProj`, `AnnualIncomeActual`, `AnnualIncomeProj`, `AnnualNetIncomeActual`, `AnnualNetIncomeProj`, `ArchitecturalStyle` AS style, `AssociationFeeAnnual`, `AssociationFeeFrequencyPrimary`, `AssociationFeeFrequencySecondary`, `AssociationFeeFrequencyTertiary`, `AssociationFeePrimary`, `AssociationFeeSecondary`, `AssociationFeeTertiary`, `AssociationNamePrimary`, `AssociationPhonePrimary`, `AuctionPrice`, `AvailableAmps`, `BasementFinishedYN`, `BasementSize` , `BasementType`, `BathsFull` AS FullBaths, `BathsHalf` AS HalfBaths, `BathsQuarter` AS RoughInBaths, `BathsThreeQuarter` AS ThreeQuarterBaths, `BathsTotal` AS baths_total, `BedsTotal` AS bedrooms_total, `BuildingAreaSource`, `BuildingName`, `BuildingType`, `CapitalizationRate`, `CapitalizationRateCalculation`, `CarportAttachedSqft`, `CarportDetachedSqft`, `City` AS city, `CloseDate`, `ClosePrice`, `CoListAgent_MUI`, `CoListAgentDirectWorkPhone`, `CoListAgentEmail`, `CoListAgentFullName`, `CoListAgentMLSID`, `CoListOffice_MUI`, `CoListOfficeMLSID`, `CoListOfficeName`, `CoListOfficePhone`, 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`, `Features`, `Flooring`, `GarageAttachedDimensions`, `GarageSpacesCount`, `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`, `InteriorFeatures`, `IsIncorporatedYN`, `KitchenAppliances`, `Latitude`, `LaundryAvailability`, `ListAgent_MUI`, `ListAgentDirectWorkPhone`, `ListAgentEmail`, `ListAgentFullName`, `ListAgentMLSID`, `ListingFinancing`, `ListOffice_MUI`, `ListOfficeMLSID`, `ListOfficeName` AS office_name, `ListOfficePhone`, `ListPrice` AS price, `Longitude`, `LotDepth`, `LotSizeAcres`, `LotSizeDimensions`, `LotSizeSqFt`, `LotWidth`, `Matrix_Unique_ID`, `MatrixModifiedDT`, `MiddleOrJuniorSchool` AS jr_high_middle, `MLSNumber` AS listing_num, `Neighborhood` AS sub_area, `NumberOfUnitsFurnished`, `NumberOfUnitsTotal`, `NumberOfUnitsVacant`, `OtherHVAC`, `OutBuildingCount`, `OutdoorArenaSQFT`, `PaddocksSQFT`, `ParcelNumber`, `ParkingCount`, `ParkingFeatures`, `ParkingTotalSearchable` AS spaces, `PerUnitFeatures`, `PhotoCount`, `PhotoModificationTimestamp`, `PostalCode` as zip_code, `PostalCodePlus4`, `PPA`, `PrimaryAccessLocation`, `PropertySubType`, `PropertyType`, `PublicRemarks` AS public_remarks, `Restrictions`, `RestrictionsOther`, `Roof`, `RoughInYN`, `SchoolDistrict` AS school_district, `SellerType`, `SiteFeatures`, `SiteType`, `SqFtAbove`, `SqFtBasement`, `SqFtFinished` AS finish_sqft_tot, `SqftTotal` AS total_square_ft, `StateOrProvince`, `Status` AS status, `StatusChangeTimestamp`, `StatusConditions`, `StorageUnitsNumberOf`, `StreetDirPrefix` AS ad_direction, `StreetName` AS street_name, `StreetNumber` AS address_num, `StreetNumberSearchable`, `StreetSuffix`, `StructuralStyle`, `StyleCharacteristics`, `TaxAmount` AS taxes, `TaxYear`, `TransactionType`, `UnderContractDate`, `UnitAccess`, `UnitAccessLocation`, `UnitCount`, `UnitNumber` AS unit_number, `View`, `VirtualTourURLUnbranded` AS tour_url, `VirtualTourURLUnbranded2`, `VirtualTourURLUnbranded3`, `WaterAnnualExpense`, `WaterMineralRights`, `YearBuilt` AS year, `Zoning` FROM `geodigsV1`.`Metrolist_Income` WHERE `MLSNumber` = 9071731;