SELECT * FROM ((SELECT `resMLSNum`, `resListPrice`, `resType`, `resResType`, `resArea`, `resAddress`, `resCity`, `resState`, `resZip`, `resStatus`, `resCounty`, `resAgent`, `resListingOffice`, `resAboveGrade`, `resBelowGrade`, `resHomeDim_L1`, `resHomeDim_W1`, `resHomeDim_L2`, `resHomeDim_W2`, `resYearBuilt`, `resLotSize_L1`, `resLotSize_W1`, `resLotSize_L2`, `resLotSize_W2`, `resWaterService`, `resWaterService2`, `resWaterService3`, `resWaterService4`, `resSewerService`, `resSewerService2`, `resSewerService3`, `resSewerService4`, `resZoning`, `resZoning2`, `resZoning3`, `resLegalDesc`, `resRestCovenant`, `resSchoolDist`, `resTaxAmount`, `resTaxYear`, `resRemarks`, `resRemarks2`, `resDirections`, `resStyle`, `resBedroomQty`, `resFullBathQty`, `resHalfBathQty`, `resGarageSize`, `resGarageType`, `resAcres`, `resLRLevel`, `resLR_DimL`, `resLR_DimW`, `resLRFlooring`, `resDRLevel`, `resDR_DimL`, `resDR_DimW`, `resDRFlooring`, `resKTLevel`, `resKT_DimL`, `resKT_DimW`, `resKTFlooring`, `resDALevel`, `resDA_DimL`, `resDA_DimW`, `resDAFlooring`, `resBD1Level`, `resBD1_DimL`, `resBD1_DimW`, `resBD1Flooring`, `resBD2Level`, `resBD2_DimL`, `resBD2_DimW`, `resBD2Flooring`, `resBD3Level`, `resBD3_DimL`, `resBD3_DimW`, `resBD3Flooring`, `resBD4Level`, `resBD4_DimL`, `resBD4_DimW`, `resBD4Flooring`, `resBTH1Level`, `resBTH1_DimL`, `resBTH1_DimW`, `resBTH1Flooring`, `resBTH2Level`, `resBTH2_DimL`, `resBTH2_DimW`, `resBTH2Flooring`, `resFRLevel`, `resFR_DimL`, `resFR_DimW`, `resFRFlooring`, `resOtherLevel`, `resOther_DimL`, `resOther_DimW`, `resOtherFlooring`, `resLaundryLevel`, `resLaundry_DimL`, `resLaundry_DimW`, `resLaundryFlooring`, `resOfficeLevel`, `resOffice_DimL`, `resOffice_DimW`, `resOfficeFlooring`, `resIncludes`, `resIncludes2`, `resIncludes3`, `resIncludes4`, `resIncludes5`, `resIncludes6`, `resIncludes7`, `resIncludes8`, `resIncludes9`, `resIncludes10`, `resIncludes11`, `resIncludes12`, `resExcludes`, `resExcludes2`, `resExcludes3`, `resExcludes4`, `resExcludes5`, `resExcludes6`, `resExcludes7`, `resExcludes8`, `resExcludes9`, `resExcludes10`, `resExcludes11`, `resExcludes12`, `resHasWaterfront`, `resWaterfrontDesc`, `resWaterfrontDesc2`, `resWaterfrontDesc3`, `resWaterfrontDesc4`, `resWaterfrontType`, `resWaterFrontage`, `resWaterSeasons`, `resOwnsFrontage`, `resSharedFrontage`, `resLakeSize`, `resLakeName`, `resLakeDepth`, `resDeededAccess`, `resEasements`, `resBasement`, `resBasement2`, `resBasement3`, `resCooling`, `resCooling2`, `resCooling3`, `resDriveway`, `resDriveway2`, `resDriveway3`, `resElectric`, `resElectric2`, `resElectric3`, `resExterior`, `resExterior2`, `resExterior3`, `resExterior4`, `resFireplace`, `resFireplace2`, `resFireplace3`, `resFoundation`, `resFoundation2`, `resFoundation3`, `resFuelSource`, `resFuelSource2`, `resFuelSource3`, `resFuelSource4`, `resHeating`, `resHeating2`, `resHeating3`, `resNewConst`, `resNewConst2`, `resNewConst3`, `resNewConst4`, `resOccupancy`, `resOccupancy2`, `resOccupancy3`, `resOccupancy4`, `resOutBuildings`, `resOutBuildings2`, `resOutBuildings3`, `resOutBuildings4`, `resPatioDeck`, `resPatioDeck2`, `resPatioDeck3`, `resPatioDeck4`, `resWaterHeater`, `resWaterHeater2`, `resWaterHeater3`, `resWaterHeater4`, `resVirtualTourURL`, `resLastUpdate`, `idx_y/n`, `brokerCode`, `newField`, `condoY/N`, `manufacturedY/N`, `netAddressDispY/N`, `isForeclosed`, `isShortSale`, `closingDate`, `closingPrice`, `extra1`, `resTotalFootage`, `resPublicComments`, `resAssociation`, `daysOnMarket`, resAcres acreage, IF(`netAddressDispY/N` = 'Y',resAddress,'') address1, resAgent agentName, resArea area, CONCAT(resBTH1_DimL,'x',resBTH1_DimW, ' Level: ', resBTH1Level) bathroom1, CONCAT(resBTH2_DimL,'x',resBTH2_DimW, ' Level: ', resBTH2Level) bathroom2, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM (resFullBathQty + resHalfBathQty/2))) bathroomCount, CONCAT(resBD1_DimL,'x',resBD1_DimW, ' Level: ', resBD1Level) bedroom1, resBD1Flooring bedroom1_floor, resBD1Level bedroom1_level, CONCAT(resBD1_DimL,' x ',resBD1_DimW) bedroom1_size, CONCAT(resBD2_DimL,'x',resBD2_DimW, ' Level: ', resBD2Level) bedroom2, resBD2Flooring bedroom2_floor, resBD2Level bedroom2_level, CONCAT(resBD2_DimL,' x ',resBD2_DimW) bedroom2_size, CONCAT(resBD3_DimL,'x',resBD3_DimW, ' Level: ', resBD3Level) bedroom3, resBD3Flooring bedroom3_floor, resBD3Level bedroom3_level, CONCAT(resBD3_DimL,' x ',resBD3_DimW) bedroom3_size, CONCAT(resBD4_DimL,'x',resBD4_DimW, ' Level: ', resBD4Level) bedroom4, resBD4Flooring bedroom4_floor, resBD4Level bedroom4_level, CONCAT(resBD4_DimL,' x ',resBD4_DimW) bedroom4_size, '' bedroom5, resBedroomQty bedroomCount, resCity city, resCounty county, CONCAT(resDA_DimL,'x',resDA_DimW, ' Level: ', resDALevel) diningArea, resDAFlooring diningArea_floor, resDALevel diningArea_level, CONCAT(resDA_DimL,' x ',resDA_DimW) diningArea_size, CONCAT(resDR_DimL,'x',resDR_DimW, ' Level: ', resDRLevel) diningRoom, resDRFlooring diningRoom_floor, resDRLevel diningRoom_level, CONCAT(resDR_DimL,' x ',resDR_DimW) diningRoom_size, CONCAT(resFR_DimL,'x',resFR_DimW, ' Level: ', resFRLevel) familyRoom, resFRFlooring familyRoom_floor, resFRLevel familyRoom_level, CONCAT(resFR_DimL,' x ',resFR_DimW) familyRoom_size, CONCAT(resGarageSize, ' Car ', resGarageType) garageSize, resGarageType garageType, resHasWaterfront hasWaterfront, resType houseType, resIncludes includes, `condoY/N` isCondo, `manufacturedY/N` isManu, CONCAT(resKT_DimL,'x',resKT_DimW, ' Level: ', resKTLevel) kitchen, resKTFlooring kitchen_floor, resKTLevel kitchen_level, CONCAT(resKT_DimL,' x ',resKT_DimW) kitchen_size, resLakeName lakeRiver, STR_TO_DATE(resLastUpdate,'%Y-%m-%d') lastUpdate, resLaundryFlooring laundaryRoom_floor, resLaundryLevel laundaryRoom_level, CONCAT(resLaundry_DimL,' x ',resLaundry_DimW) laundaryRoom_size, CONCAT(resLaundry_DimL,'x',resLaundry_DimW, ' Level: ', resLaundryLevel) laundryRoom, resListingOffice listingOffice, (closingDate="" AND closingPrice=0) listProperty, CONCAT(resLR_DimL,'x',resLR_DimW, ' Level: ', resLRLevel) livingRoom, resLRFlooring livingRoom_floor, resLRLevel livingRoom_level, CONCAT(resLR_DimL,' x ',resLR_DimW) livingRoom_size, CONCAT(resLotSize_L1,'x',resLotSize_W1) lotSize, resMLSNum mlsNum, `netAddressDispY/N` netAddress, resNewConst newConstruction, CONCAT(resOffice_DimL,'x',resOffice_DimW, ' Level: ', resOfficeLevel) office, resOfficeFlooring office_floor, resOfficeLevel office_level, CONCAT(resOffice_DimL,' x ',resOffice_DimW) office_size, STR_TO_DATE(openHouseDate,'%m/%d/%Y') openHouse_date, openHouseTime openHouse_time, CONCAT(resOther_DimL,'x',resOther_DimW,' Level: ', resOtherLevel) otherRoom, resOtherFlooring otherRoom_floor, resOtherLevel otherRoom_level, CONCAT(resOther_DimL,' x ',resOther_DimW) otherRoom_size, resListPrice price, resstyle propertyStyle, resResType propType, resPublicComments publicComments, isForeclosed resIsForeclosed, isShortSale resIsShortSale, resSchoolDist schoolDist, CONCAT('Above: ', resAboveGrade, ' Below: ', resBelowGrade) squareFootage, resState state, resStatus status, resStyle style, CONCAT(resRemarks,resRemarks2) summary, resTaxYear taxYear, resVirtualTourURL virtualTour, resLakeName waterfront, resYearBuilt yearBuilt, resTaxAmount yearlyTax, resZip zip, 'Single-Family' propertyType, 'Eau_Claire' mlsSystem FROM (tblListingResidential LEFT JOIN openHouses ON resMLSNum=mlsNum) WHERE STR_TO_DATE(openHouseDate,'%m/%d/%Y') != '' AND STR_TO_DATE(openHouseDate,'%m/%d/%Y') > '2013-05-18' AND resListingOffice LIKE 'C21%' ) ) MasterList WHERE listProperty=1 ORDER BY price DESC

SELECT * FROM ((SELECT `resMLSNum`, `resListPrice`, `resType`, `resResType`, `resArea`, `resAddress`, `resCity`, `resState`, `resZip`, `resStatus`, `resCounty`, `resAgent`, `resListingOffice`, `resAboveGrade`, `resBelowGrade`, `resHomeDim_L1`, `resHomeDim_W1`, `resHomeDim_L2`, `resHomeDim_W2`, `resYearBuilt`, `resLotSize_L1`, `resLotSize_W1`, `resLotSize_L2`, `resLotSize_W2`, `resWaterService`, `resWaterService2`, `resWaterService3`, `resWaterService4`, `resSewerService`, `resSewerService2`, `resSewerService3`, `resSewerService4`, `resZoning`, `resZoning2`, `resZoning3`, `resLegalDesc`, `resRestCovenant`, `resSchoolDist`, `resTaxAmount`, `resTaxYear`, `resRemarks`, `resRemarks2`, `resDirections`, `resStyle`, `resBedroomQty`, `resFullBathQty`, `resHalfBathQty`, `resGarageSize`, `resGarageType`, `resAcres`, `resLRLevel`, `resLR_DimL`, `resLR_DimW`, `resLRFlooring`, `resDRLevel`, `resDR_DimL`, `resDR_DimW`, `resDRFlooring`, `resKTLevel`, `resKT_DimL`, `resKT_DimW`, `resKTFlooring`, `resDALevel`, `resDA_DimL`, `resDA_DimW`, `resDAFlooring`, `resBD1Level`, `resBD1_DimL`, `resBD1_DimW`, `resBD1Flooring`, `resBD2Level`, `resBD2_DimL`, `resBD2_DimW`, `resBD2Flooring`, `resBD3Level`, `resBD3_DimL`, `resBD3_DimW`, `resBD3Flooring`, `resBD4Level`, `resBD4_DimL`, `resBD4_DimW`, `resBD4Flooring`, `resBTH1Level`, `resBTH1_DimL`, `resBTH1_DimW`, `resBTH1Flooring`, `resBTH2Level`, `resBTH2_DimL`, `resBTH2_DimW`, `resBTH2Flooring`, `resFRLevel`, `resFR_DimL`, `resFR_DimW`, `resFRFlooring`, `resOtherLevel`, `resOther_DimL`, `resOther_DimW`, `resOtherFlooring`, `resLaundryLevel`, `resLaundry_DimL`, `resLaundry_DimW`, `resLaundryFlooring`, `resOfficeLevel`, `resOffice_DimL`, `resOffice_DimW`, `resOfficeFlooring`, `resIncludes`, `resIncludes2`, `resIncludes3`, `resIncludes4`, `resIncludes5`, `resIncludes6`, `resIncludes7`, `resIncludes8`, `resIncludes9`, `resIncludes10`, `resIncludes11`, `resIncludes12`, `resExcludes`, `resExcludes2`, `resExcludes3`, `resExcludes4`, `resExcludes5`, `resExcludes6`, `resExcludes7`, `resExcludes8`, `resExcludes9`, `resExcludes10`, `resExcludes11`, `resExcludes12`, `resHasWaterfront`, `resWaterfrontDesc`, `resWaterfrontDesc2`, `resWaterfrontDesc3`, `resWaterfrontDesc4`, `resWaterfrontType`, `resWaterFrontage`, `resWaterSeasons`, `resOwnsFrontage`, `resSharedFrontage`, `resLakeSize`, `resLakeName`, `resLakeDepth`, `resDeededAccess`, `resEasements`, `resBasement`, `resBasement2`, `resBasement3`, `resCooling`, `resCooling2`, `resCooling3`, `resDriveway`, `resDriveway2`, `resDriveway3`, `resElectric`, `resElectric2`, `resElectric3`, `resExterior`, `resExterior2`, `resExterior3`, `resExterior4`, `resFireplace`, `resFireplace2`, `resFireplace3`, `resFoundation`, `resFoundation2`, `resFoundation3`, `resFuelSource`, `resFuelSource2`, `resFuelSource3`, `resFuelSource4`, `resHeating`, `resHeating2`, `resHeating3`, `resNewConst`, `resNewConst2`, `resNewConst3`, `resNewConst4`, `resOccupancy`, `resOccupancy2`, `resOccupancy3`, `resOccupancy4`, `resOutBuildings`, `resOutBuildings2`, `resOutBuildings3`, `resOutBuildings4`, `resPatioDeck`, `resPatioDeck2`, `resPatioDeck3`, `resPatioDeck4`, `resWaterHeater`, `resWaterHeater2`, `resWaterHeater3`, `resWaterHeater4`, `resVirtualTourURL`, `resLastUpdate`, `idx_y/n`, `brokerCode`, `newField`, `condoY/N`, `manufacturedY/N`, `netAddressDispY/N`, `isForeclosed`, `isShortSale`, `closingDate`, `closingPrice`, `extra1`, `resTotalFootage`, `resPublicComments`, `resAssociation`, `daysOnMarket`, resAcres acreage, IF(`netAddressDispY/N` = 'Y',resAddress,'') address1, resAgent agentName, resArea area, CONCAT(resBTH1_DimL,'x',resBTH1_DimW, ' Level: ', resBTH1Level) bathroom1, CONCAT(resBTH2_DimL,'x',resBTH2_DimW, ' Level: ', resBTH2Level) bathroom2, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM (resFullBathQty + resHalfBathQty/2))) bathroomCount, CONCAT(resBD1_DimL,'x',resBD1_DimW, ' Level: ', resBD1Level) bedroom1, resBD1Flooring bedroom1_floor, resBD1Level bedroom1_level, CONCAT(resBD1_DimL,' x ',resBD1_DimW) bedroom1_size, CONCAT(resBD2_DimL,'x',resBD2_DimW, ' Level: ', resBD2Level) bedroom2, resBD2Flooring bedroom2_floor, resBD2Level bedroom2_level, CONCAT(resBD2_DimL,' x ',resBD2_DimW) bedroom2_size, CONCAT(resBD3_DimL,'x',resBD3_DimW, ' Level: ', resBD3Level) bedroom3, resBD3Flooring bedroom3_floor, resBD3Level bedroom3_level, CONCAT(resBD3_DimL,' x ',resBD3_DimW) bedroom3_size, CONCAT(resBD4_DimL,'x',resBD4_DimW, ' Level: ', resBD4Level) bedroom4, resBD4Flooring bedroom4_floor, resBD4Level bedroom4_level, CONCAT(resBD4_DimL,' x ',resBD4_DimW) bedroom4_size, '' bedroom5, resBedroomQty bedroomCount, resCity city, resCounty county, CONCAT(resDA_DimL,'x',resDA_DimW, ' Level: ', resDALevel) diningArea, resDAFlooring diningArea_floor, resDALevel diningArea_level, CONCAT(resDA_DimL,' x ',resDA_DimW) diningArea_size, CONCAT(resDR_DimL,'x',resDR_DimW, ' Level: ', resDRLevel) diningRoom, resDRFlooring diningRoom_floor, resDRLevel diningRoom_level, CONCAT(resDR_DimL,' x ',resDR_DimW) diningRoom_size, CONCAT(resFR_DimL,'x',resFR_DimW, ' Level: ', resFRLevel) familyRoom, resFRFlooring familyRoom_floor, resFRLevel familyRoom_level, CONCAT(resFR_DimL,' x ',resFR_DimW) familyRoom_size, CONCAT(resGarageSize, ' Car ', resGarageType) garageSize, resGarageType garageType, resHasWaterfront hasWaterfront, resType houseType, resIncludes includes, `condoY/N` isCondo, `manufacturedY/N` isManu, CONCAT(resKT_DimL,'x',resKT_DimW, ' Level: ', resKTLevel) kitchen, resKTFlooring kitchen_floor, resKTLevel kitchen_level, CONCAT(resKT_DimL,' x ',resKT_DimW) kitchen_size, resLakeName lakeRiver, STR_TO_DATE(resLastUpdate,'%Y-%m-%d') lastUpdate, resLaundryFlooring laundaryRoom_floor, resLaundryLevel laundaryRoom_level, CONCAT(resLaundry_DimL,' x ',resLaundry_DimW) laundaryRoom_size, CONCAT(resLaundry_DimL,'x',resLaundry_DimW, ' Level: ', resLaundryLevel) laundryRoom, resListingOffice listingOffice, (closingDate="" AND closingPrice=0) listProperty, CONCAT(resLR_DimL,'x',resLR_DimW, ' Level: ', resLRLevel) livingRoom, resLRFlooring livingRoom_floor, resLRLevel livingRoom_level, CONCAT(resLR_DimL,' x ',resLR_DimW) livingRoom_size, CONCAT(resLotSize_L1,'x',resLotSize_W1) lotSize, resMLSNum mlsNum, `netAddressDispY/N` netAddress, resNewConst newConstruction, CONCAT(resOffice_DimL,'x',resOffice_DimW, ' Level: ', resOfficeLevel) office, resOfficeFlooring office_floor, resOfficeLevel office_level, CONCAT(resOffice_DimL,' x ',resOffice_DimW) office_size, STR_TO_DATE(openHouseDate,'%m/%d/%Y') openHouse_date, openHouseTime openHouse_time, CONCAT(resOther_DimL,'x',resOther_DimW,' Level: ', resOtherLevel) otherRoom, resOtherFlooring otherRoom_floor, resOtherLevel otherRoom_level, CONCAT(resOther_DimL,' x ',resOther_DimW) otherRoom_size, resListPrice price, resstyle propertyStyle, resResType propType, resPublicComments publicComments, isForeclosed resIsForeclosed, isShortSale resIsShortSale, resSchoolDist schoolDist, CONCAT('Above: ', resAboveGrade, ' Below: ', resBelowGrade) squareFootage, resState state, resStatus status, resStyle style, CONCAT(resRemarks,resRemarks2) summary, resTaxYear taxYear, resVirtualTourURL virtualTour, resLakeName waterfront, resYearBuilt yearBuilt, resTaxAmount yearlyTax, resZip zip, 'Single-Family' propertyType, 'Eau_Claire' mlsSystem FROM (tblListingResidential LEFT JOIN openHouses ON resMLSNum=mlsNum) WHERE STR_TO_DATE(openHouseDate,'%m/%d/%Y') != '' AND STR_TO_DATE(openHouseDate,'%m/%d/%Y') > '2013-05-18' AND resListingOffice LIKE 'C21%' ) ) MasterList WHERE listProperty=1 ORDER BY price DESC