Listing all records

Displaying records 3301 through 3400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543129 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543130 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543285 SLP South San Francisco CALIFORNIA 8 Hour Days
543308 NICU Walnut Creek CALIFORNIA 12 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
543406 PT Palm Springs CALIFORNIA 8 Hour Days
543407 PT Palm Springs CALIFORNIA 8 Hour Days
543549 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543550 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543575 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
543633 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
543644 ER Walnut Creek CALIFORNIA 12 Hour Nights
543645 ER Walnut Creek CALIFORNIA 12 Hour Nights
543646 ER Walnut Creek CALIFORNIA 12 Hour Nights
543647 ER Walnut Creek CALIFORNIA 12 Hour Nights
543648 ER Walnut Creek CALIFORNIA 12 Hour Nights
543649 ER Walnut Creek CALIFORNIA 12 Hour Nights
543650 ER Walnut Creek CALIFORNIA 12 Hour Nights
543651 ER Walnut Creek CALIFORNIA 12 Hour Nights
543709 Laboratory Orange CALIFORNIA 8 Hour Days
546032 PT San Jose CALIFORNIA 10 Hour Days
543751 OR Victorville CALIFORNIA 8 Hour Days
543752 PACU Victorville CALIFORNIA 8 Hour Days
543753 CLS Victorville CALIFORNIA 8 Hour Days
543755 NICU Lynwood CALIFORNIA 12 Hour Nights
543757 CT Tech Lynwood CALIFORNIA 12 Hour Days
543758 CT Tech Lynwood CALIFORNIA 12 Hour Days
543759 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543769 CLS Lynwood CALIFORNIA 12 Hour Days
543770 CLS Lynwood CALIFORNIA 12 Hour Days
543773 RAD Tech San Diego CALIFORNIA 12 Hour Days
543774 RAD Tech San Diego CALIFORNIA 12 Hour Days
543777 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543778 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543781 OR Redding CALIFORNIA 8 Hour Days
543783 RAD Tech Redding CALIFORNIA 8 Hour Days
543785 Scrub Tech Redding CALIFORNIA 12 Hour Day/Night Rotate
543790 RAD Tech Oceanside CALIFORNIA 8 Hour Days
543831 Cath Lab Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
543834 Mammo Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
543885 OR National City CALIFORNIA 8 Hour Days
543886 RAD Tech National City CALIFORNIA 12 Hour Nights
543887 CT Tech National City CALIFORNIA 12 Hour Nights
543888 RAD Tech National City CALIFORNIA 12 Hour Days
543889 Cath Lab National City CALIFORNIA 8 Hour Days
543890 Psych National City CALIFORNIA 12 Hour Nights
543891 Psych National City CALIFORNIA 12 Hour Days
543904 PT Crescent City CALIFORNIA 8 Hour Days
543911 COTA Hanford CALIFORNIA Days
543944 RAD Tech Walnut Creek CALIFORNIA 10 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544012 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544049 Med Surg Palm Springs CALIFORNIA 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544051 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
547932 Telemetry - Per Diem Oceanside CALIFORNIA 12 Hour Nights
547940 Nuclear Med Technician Mission Viejo CALIFORNIA 8 Hour Days
547958 Cath Lab San Diego CALIFORNIA 8 Hour Days
547978 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547979 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547990 Cardiology Torrance CALIFORNIA 12 Hour Days
547991 Cardiology Torrance CALIFORNIA 12 Hour Days
547992 Case Manager Torrance CALIFORNIA 8 Hour Days
547993 LTAC Torrance CALIFORNIA 8 Hour Evenings
548161 Surgical Tech MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548164 LTAC Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
548010 CT Tech Fort Bragg CALIFORNIA 12 Hour Day/Night Rotate
548011 SLP Crescent City CALIFORNIA 8 Hour Days
548012 PT Crescent City CALIFORNIA 8 Hour Days
548015 CNA San Francisco CALIFORNIA 8 Hour Days
548016 CNA San Francisco CALIFORNIA 8 Hour Days
548017 PACU Chico CALIFORNIA 10 Hour Days
548026 PT Escondido CALIFORNIA 8 Hour Days
548027 PTA Escondido CALIFORNIA 8 Hour Days
548038 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights
548043 OR Bakersfield CALIFORNIA 8 Hour Days RN/Registered Nurse
548044 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
548046 OR BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548048 LPN/LVN Rancho Cordova CALIFORNIA 12 Hour Nights LVN
548051 CNA - Per Diem Los Angeles CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
548056 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548059 Surgical Tech SAN FRANCISCO CALIFORNIA 8 Hour Days Tech/Technologist
548061 PACU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
548076 Case Manager Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
548078 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548079 PICU Roseville CALIFORNIA 12 Hour Nights RN/Registered Nurse
548082 PCU Torrance CALIFORNIA 12 Hour Days RN/Registered Nurse
548084 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548085 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
Slow: select count(*) from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 in 1.8175 seconds
Slow: select a.id,a.id,b.name as specialty,c.name as shift,d.name as title,z.city,y.name as state from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 order by y.name desc limit 3300,100 in 1.5959 seconds