USA
UK
Canada
Australia
China
Japan
International
Register
Login
Accessibility
Applicants
Login
Register
Jobs
Physician and Provider Careers
Workforce Solutions
HealthETalks
Benefits & Perks
FAQ
Staffing Solutions
Submit a staffing request
School Staffing
About us
Physician and Provider Solutions
International
Referral Program
Crisis
Contact
Applicants
Login
Register
Jobs
Physician and Provider Careers
Workforce Solutions
HealthETalks
Benefits & Perks
FAQ
Staffing Solutions
Submit a staffing request
School Staffing
About us
Physician and Provider Solutions
International
Referral Program
Crisis
Contact
Login
Register your cv
Category
Administration
Allied Health
Clinical
Acute Care General
Case Management
Critical Care
Emergency Room
Home Health
Mental Health
Neonatal
Nursing Home and Rehab Hospitals
Operating Room
Outpatient Clinics
Paralegal
Pediatrics
Women's Services
Education
Locums
Management
Non Clinical
Pharmacy
Social Work
Location
USA
Alabama
Transaction (Process ID 205) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SELECT *, dbo.fn_getLangItem(l_locations.k_id, 1,2) as tx_langItem FROM l_locations WHERE l_countryID = 19828 AND l_locations.k_id IN (SELECT l_locationID FROM x_vacLocations xvac INNER JOIN d_vacancies vac ON xvac.l_vacID = vac.k_id INNER JOIN d_clients cli ON vac.l_clientID = cli.k_id WHERE cli.yn_activated = 1 AND vac.yn_activated = 1 AND xvac.l_locationID = l_locations.k_id) AND b_siteID = 1 ORDER BY b_order ASC,tx_location
