Find Pet Sitters Near Brenham, TX
WITH NearbyZips AS (
SELECT DISTINCT ZipCode,ACOS(SIN(RADIANS(30.15)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(30.15)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-96.39) - RADIANS(`Longitude`))) * 3959 AS distance
FROM loc_data
WHERE `Latitude` BETWEEN 30.15 - 1 AND 30.15 + 1
AND `Longitude` BETWEEN -96.39 - 1 AND -96.39 + 1
AND ACOS(SIN(RADIANS(30.15)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(30.15)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-96.39) - 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_dog) AS srv_dog, SUM(srv_cat) AS srv_cat, SUM(srv_bird) AS srv_bird, SUM(srv_fish) AS srv_fish, SUM(srv_mammal) AS srv_mammal, SUM(srv_exotic) AS srv_exotic, SUM(srv_sit) AS srv_sit, SUM(srv_trans) AS srv_trans, SUM(srv_walk) AS srv_walk, SUM(srv_board) AS srv_board, SUM(qual_car) AS qual_car, SUM(qual_non_smoker) AS qual_non_smoker
FROM `caredotcom_petcare`
INNER JOIN NearbyZips AS dt ON `caredotcom_petcare`.`zip` = `dt`.`ZipCode`
AND `srv_bird` = '1' AND `imageUrl` != 'https://www.care.com/img/placeholder_logo_135x135.gif'array(18) {
["total"]=>
string(1) "5"
["yearsOfExperience"]=>
string(2) "18"
["numberOfReviews"]=>
string(1) "0"
["hourlyRateFrom"]=>
string(3) "100"
["spk_english"]=>
string(1) "5"
["spk_spanish"]=>
string(1) "0"
["srv_dog"]=>
string(1) "5"
["srv_cat"]=>
string(1) "5"
["srv_bird"]=>
string(1) "5"
["srv_fish"]=>
string(1) "5"
["srv_mammal"]=>
string(1) "3"
["srv_exotic"]=>
string(1) "0"
["srv_sit"]=>
string(1) "5"
["srv_trans"]=>
string(1) "5"
["srv_walk"]=>
string(1) "5"
["srv_board"]=>
string(1) "0"
["qual_car"]=>
string(1) "2"
["qual_non_smoker"]=>
string(1) "5"
}