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
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 1024 OFFSET 1
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 group_slug,' 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 ORDER BY distance
YOUR CLOSEST LOCATION
Blue Diamond Campus
4855 Blue Diamond Rd.
Las Vegas, Nevada 89139
702-216-7305
Neighborhood Hospitals
North Las Vegas Campus
1550 W. Craig Rd.
North Las Vegas, Nevada 89032
702-777-3615
Sahara Campus
4980 W. Sahara Ave.
Las Vegas, Nevada 89146
702-216-7365
West Flamingo Campus
9880 W. Flamingo Rd.
Las Vegas, Nevada 89147
702-216-7335
ST. ROSE CAMPUSES
Rose de Lima Campus
102 E. Lake Mead Pkwy.
Henderson, Nevada 89015
San Martín Campus
8280 W. Warm Springs Rd.
Las Vegas, Nevada 89113
Siena Campus
3001 St. Rose Pkwy.
Henderson, Nevada 89052