Find Pet Sitters Near Port Lavaca, TX

WITH NearbyZips AS ( SELECT DISTINCT ZipCode,ACOS(SIN(RADIANS(28.61)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(28.61)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-96.62) - RADIANS(`Longitude`))) * 3959 AS distance FROM loc_data WHERE `Latitude` BETWEEN 28.61 - 1 AND 28.61 + 1 AND `Longitude` BETWEEN -96.62 - 1 AND -96.62 + 1 AND ACOS(SIN(RADIANS(28.61)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(28.61)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-96.62) - 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_trans` = '1' AND `imageUrl` != 'https://www.care.com/img/placeholder_logo_135x135.gif'array(18) { ["total"]=> string(1) "0" ["yearsOfExperience"]=> NULL ["numberOfReviews"]=> NULL ["hourlyRateFrom"]=> NULL ["spk_english"]=> NULL ["spk_spanish"]=> NULL ["srv_dog"]=> NULL ["srv_cat"]=> NULL ["srv_bird"]=> NULL ["srv_fish"]=> NULL ["srv_mammal"]=> NULL ["srv_exotic"]=> NULL ["srv_sit"]=> NULL ["srv_trans"]=> NULL ["srv_walk"]=> NULL ["srv_board"]=> NULL ["qual_car"]=> NULL ["qual_non_smoker"]=> NULL }