Find House Cleaners Near Wheeling, WV
WITH NearbyZips AS (
SELECT DISTINCT ZipCode,ACOS(SIN(RADIANS(40.07)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(40.07)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-80.69) - RADIANS(`Longitude`))) * 3959 AS distance
FROM loc_data
WHERE `Latitude` BETWEEN 40.07 - 1 AND 40.07 + 1
AND `Longitude` BETWEEN -80.69 - 1 AND -80.69 + 1
AND ACOS(SIN(RADIANS(40.07)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(40.07)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-80.69) - RADIANS(`Longitude`))) * 3959 < 20
)SELECT COUNT(*) AS total, SUM(yearsOfExperience) AS yearsOfExperience, SUM(numberOfReviews) AS numberOfReviews, SUM(hourlyRateFrom) AS hourlyRateFrom, SUM(spk_english) AS spk_english, SUM(spk_spanish) AS spk_spanish, SUM(srv_equip) AS srv_equip, SUM(srv_supplies) AS srv_supplies, SUM(qual_pets) AS qual_pets, SUM(qual_car) AS qual_car, SUM(qual_non_smoker) AS qual_non_smoker
FROM `caredotcom_housekeeping`
INNER JOIN NearbyZips AS dt ON `caredotcom_housekeeping`.`zip` = `dt`.`ZipCode`
AND `numberOfReviews` >= 1 AND `imageUrl` != 'https://www.care.com/img/placeholder_logo_135x135.gif'array(11) {
["total"]=>
string(1) "3"
["yearsOfExperience"]=>
string(2) "18"
["numberOfReviews"]=>
string(1) "7"
["hourlyRateFrom"]=>
string(2) "65"
["spk_english"]=>
string(1) "3"
["spk_spanish"]=>
string(1) "0"
["srv_equip"]=>
string(1) "0"
["srv_supplies"]=>
string(1) "1"
["qual_pets"]=>
string(1) "3"
["qual_car"]=>
string(1) "1"
["qual_non_smoker"]=>
string(1) "3"
}