Find Babysitters Near Plainview, TX

WITH NearbyZips AS ( SELECT DISTINCT ZipCode,ACOS(SIN(RADIANS(34.19)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(34.19)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-101.72) - RADIANS(`Longitude`))) * 3959 AS distance FROM loc_data WHERE `Latitude` BETWEEN 34.19 - 1 AND 34.19 + 1 AND `Longitude` BETWEEN -101.72 - 1 AND -101.72 + 1 AND ACOS(SIN(RADIANS(34.19)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(34.19)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-101.72) - 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_sick) AS srv_sick, SUM(srv_housekeeping) AS srv_housekeeping, SUM(srv_travel) AS srv_travel, SUM(srv_carpool) AS srv_carpool, SUM(srv_errands) AS srv_errands, SUM(srv_shopping) AS srv_shopping, SUM(srv_laundry) AS srv_laundry, SUM(qual_car) AS qual_car, SUM(qual_pets) AS qual_pets, SUM(qual_non_smoker) AS qual_non_smoker, SUM(qual_twins) AS qual_twins, SUM(qual_first_aid) AS qual_first_aid, SUM(qual_cpr) AS qual_cpr FROM `caredotcom_childcare` INNER JOIN NearbyZips AS dt ON `caredotcom_childcare`.`zip` = `dt`.`ZipCode` AND (`availabilityFrequency` = 'PART-TIME') AND `spk_english` = '1' AND `imageUrl` != 'https://www.care.com/img/placeholder_logo_135x135.gif'array(19) { ["total"]=> string(1) "4" ["yearsOfExperience"]=> string(2) "19" ["numberOfReviews"]=> string(1) "1" ["hourlyRateFrom"]=> string(2) "67" ["spk_english"]=> string(1) "4" ["spk_spanish"]=> string(1) "1" ["srv_sick"]=> string(1) "3" ["srv_housekeeping"]=> string(1) "4" ["srv_travel"]=> string(1) "1" ["srv_carpool"]=> string(1) "4" ["srv_errands"]=> string(1) "1" ["srv_shopping"]=> string(1) "3" ["srv_laundry"]=> string(1) "3" ["qual_car"]=> string(1) "1" ["qual_pets"]=> string(1) "4" ["qual_non_smoker"]=> string(1) "4" ["qual_twins"]=> string(1) "1" ["qual_first_aid"]=> string(1) "2" ["qual_cpr"]=> string(1) "3" }