WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
, lat, lng) distance,
tebyn_emeruslocationgroup.slug as' at line 2]SELECT tebyn_emeruslocation.*,
emerus_haversine_distance_sp(,
, lat, lng) distance,
tebyn_emeruslocationgroup.slug as group_slug,
tebyn_emeruslocationgroup.icon as group_icon,
tebyn_emeruslocationgroup.drop_pin as group_drop_pin
FROM tebyn_emeruslocation LEFT OUTER JOIN tebyn_emeruslocationgroup ON tebyn_emeruslocationgroup.id = tebyn_emeruslocation.group_id WHERE tebyn_emeruslocationgroup.slug = 'open' ORDER BY distance LIMIT 1
YOUR CLOSEST LOCATION
Our Services
Whether your emergency involves a minor injury or a major, life-threatening event, rest assured, Dignity Health – St. Rose Dominican Neighborhood Hospitals are ready.
At Dignity Health – St. Rose Dominican, you’ll see a physician within minutes, not hours. Our Neighborhood Hospitals offer additional convenient locations in Las Vegas, closer to where you live, work and play.