SELECT * FROM ((SELECT `comMLSNum`, `comListPrice`, `comComType`, `comComType2`, `comComType3`, `comComType4`, `comArea`, `comAddress`, `comCity`, `comState`, `comZip`, `comStatus`, `comCounty`, `comAgent`, `comListingOffice`, `comTaxId`, `comAboveGrade`, `comBelowGrade`, `comBuilding_DimL1`, `comBuilding_DimW1`, `comBuilding_DimL2`, `comBuilding_DimW2`, `comYearBuilt`, `comLot_DimL1`, `comLot_DimW1`, `comLot_DimL2`, `comLot_DimW2`, `comZoning`, `comZoning1`, `comZoning2`, `comLegalDesc`, `comSchoolDist`, `comTaxAmount`, `comTaxYear`, `comRemarks`, `comRemarks2`, `comDirections`, `comParking`, `comSideWallHeight`, `comOccupantTerms`, `comWaterService`, `comSewerService`, `comSprinkler`, `comOtherBuildings`, `comServiceAmps`, `comRestCovenant`, `com3PhasePower`, `comLoadingDock1`, `comDoor1Length`, `comDoor1Width`, `comLoadingDock2`, `comDoor2Length`, `comDoor2Width`, `comLoadingDock3`, `comDoor3Length`, `comDoor3Width`, `comLoadingDock4`, `comDoor4Length`, `comDoor4Width`, `comLoadingDock5`, `comDoor5Length`, `comDoor5Width`, `comLoadingDock6`, `comDoor6Length`, `comDoor6Width`, `comHasWaterfront`, `comWaterfrontType`, `comWaterFrontage`, `comWaterSeasons`, `comOwnsFrontage`, `comSharedFrontage`, `comLakeSize`, `comLakeName`, `comLakeDepth`, `comDeededAccess`, `comEasements`, `comBasement`, `comBasement2`, `comBasement3`, `comCooling`, `comCooling2`, `comCooling3`, `comCooling4`, `comExteriorConst`, `comExteriorConst2`, `comExteriorConst3`, `comExteriorConst4`, `comExteriorFeatures`, `comExteriorFeatures2`, `comExteriorFeatures3`, `comExteriorFeatures4`, `comFoundation`, `comFoundation2`, `comFoundation3`, `comFuelSource`, `comFuelSource2`, `comFuelSource3`, `comFuelSource4`, `comHeating`, `comHeating2`, `comHeating3`, `comHeating4`, `comInteriorFeatures`, `comInteriorFeatures2`, `comInteriorFeatures3`, `comInteriorFeatures4`, `comInteriorFeatures5`, `comInteriorFeatures6`, `comInteriorFeatures7`, `comInteriorFeatures8`, `comOccupancy`, `comOccupancy2`, `comOccupancy3`, `comRoads`, `comRoads2`, `comRoads3`, `comVirtualTourURL`, `comLastModified`, `comIDX_y/n`, `comListBrokerCode`, `newField`, `isForeclosed`, `isShortSale`, `closingDate`, `closingPrice`, comAddress address1, comAgent agentName, comArea area, comCity city, isForeclosed comIsForeclosed, isShortSale comIsShortSale, CONCAT("|",comComType,"|",comComType2,"|",comComType3,"|",comComType4,"|") comType, comCounty county, comHasWaterfront hasWaterfront, comType houseType, STR_TO_DATE(comLastModified,'%m/%d/%Y') lastUpdate, comListingOffice listingOffice, CONCAT(comLot_DimL1,'x',comLot_DimW1) lotSize, comMLSNum mlsNum, comListPrice price, comComType propType, comSchoolDist schoolDist, CONCAT('Above: ', comAboveGrade, ' Below: ', comBelowGrade) squareFootage, comState state, comRemarks summary, comTaxYear taxYear, comVirtualTourURL virtualTour, comLakeName waterfront, comYearBuilt yearBuilt, comTaxAmount yearlyTax, comZip zip, comZoning zoning, 'Commercial' propertyType, 'Eau_Claire' mlsSystem FROM tblListingCommercial WHERE 1) ) MasterList ORDER BY price DESC