WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',
, lat, lng) distance,
hvuah_emeruslocationgroup.slug a' at line 2]SELECT hvuah_emeruslocation.*,
emerus_haversine_distance_sp(,
, lat, lng) distance,
hvuah_emeruslocationgroup.slug as group_slug,
hvuah_emeruslocationgroup.icon as group_icon,
hvuah_emeruslocationgroup.drop_pin as group_drop_pin
FROM hvuah_emeruslocation LEFT OUTER JOIN hvuah_emeruslocationgroup ON hvuah_emeruslocationgroup.id = hvuah_emeruslocation.group_id WHERE hvuah_emeruslocationgroup.slug = 'open' ORDER BY distance LIMIT 1 /* From [strosenh.org/] in [/nas/content/live/strosenhorg/wp-content/plugins/emerus-locations/emerus-location.php:1415] */
Centennial Campus is Opening Soon
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.