Listing all records

Displaying records 3601 through 3700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
494609 PCU Casa Grande ARIZONA 12 Hour Nights
548272 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
548273 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
548244 Surgical Tech GILBERT ARIZONA 12 Hour Nights Tech/Technologist
548245 Surgical Tech Gilbert ARIZONA 12 Hour Nights RN/Registered Nurse
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
527971 RN Tuba City ARIZONA 12 Hour Day/Night Rotate
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
530245 Telemetry CHANDLER ARIZONA 12 Hour Nights
531418 PCU Phoenix ARIZONA 12 Hour Nights
534331 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
535783 PCU Tucson ARIZONA 12 Hour Nights
536164 Med Surg Glendale ARIZONA 12 Hour Days
539674 Med Surg Mesa ARIZONA 12 Hour Nights
539903 MLT Tuba City ARIZONA 12 Hour Day/Night Rotate
546216 PCU Sun City ARIZONA 12 Hour Nights
546217 PCU Sun City ARIZONA 12 Hour Nights
547118 Interventional Radiology Tech CHANDLER ARIZONA 8 Hour Days
546345 CT Tech Goodyear ARIZONA 10 Hour Days
546346 PT Nogales ARIZONA 8 Hour Days
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
546799 Ambulatory Fort Defiance ARIZONA 8 Hour Days
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
546886 PT Globe ARIZONA Days
546971 Radiology PHOENIX ARIZONA 12 Hour Nights
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
547402 Cath Lab Tech Fort Smith ARIZONA 8 Hour Day/Night Rotate
547468 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
547561 Pediatrics Fort Defiance ARIZONA 12 Hour Day/Night Rotate
547699 OR Sun City ARIZONA 12 Hour Days
547700 CVOR Sun City ARIZONA 10 Hour Days
547725 Med Surg Mesa ARIZONA 12 Hour Days
547727 PCU Sun City ARIZONA 12 Hour Days
547728 PCU Mesa ARIZONA 12 Hour Nights
547729 PCU Mesa ARIZONA 12 Hour Days
547758 PCU Phoenix ARIZONA 12 Hour Nights
547759 Med Surg Sun City West ARIZONA 12 Hour Days
547761 CT Tech Glendale ARIZONA 8 Hour Days
547762 PCU Glendale ARIZONA 12 Hour Nights
547763 CT Tech Glendale ARIZONA 10 Hour Nights
547764 CT Tech Phoenix ARIZONA 10 Hour Days
547765 Med Surg Sun City West ARIZONA 12 Hour Nights
547781 CT Tech Goodyear ARIZONA 10 Hour Nights
547795 OR Tuba City ARIZONA 10 Hour Days
547906 ICU Sun City ARIZONA 12 Hour Nights
540745 Telemetry Prescott ARIZONA 12 Hour Day/Night Rotate
540746 Med Surg Prescott ARIZONA 12 Hour Day/Night Rotate
540748 Med Surg Tele Prescott ARIZONA 12 Hour Days
540749 Med Surg Tele Prescott ARIZONA 12 Hour Day/Night Rotate
540770 Telemetry Prescott ARIZONA 12 Hour Days
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
541829 RAD Tech CHANDLER ARIZONA 12 Hour Day/Night Rotate
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
542617 PCU Sun City West ARIZONA 12 Hour Nights
542618 PCU Sun City West ARIZONA 12 Hour Days
542986 RAD Tech Tuba City ARIZONA 12 Hour Day/Night Rotate
543510 Ultrasound Tech Phoenix ARIZONA 12 Hour Day/Night Rotate
548166 Med Surg Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
548087 PCU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548088 ER Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548089 NICU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548098 Med Surg Tele Chandler ARIZONA 12 Hour Day/Night Rotate RN/Registered Nurse
548133 Cath Lab Mesa ARIZONA 12 Hour Days RN/Registered Nurse
548198 ER Casa Grande ARIZONA 12 Hour Nights RN/Registered Nurse
548200 Respiratory Therapist Mesa ARIZONA 12 Hour Days Respiratory Therapist
548222 Certified Surgical Tech Sun City ARIZONA 10 Hour Days CST/Certified Surgical Technician
548298 Neuro Intensive Care PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
548332 Clinic Chandler ARIZONA 8 Hour Days LPN/Licensed Practical Nurse
548360 CVICU Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
548370 ER Chandler ARIZONA 12 Hour Nights RN/Registered Nurse
548381 Med Surg Tele Prescott ARIZONA 12 Hour Nights RN/Registered Nurse
546276 Pediatrics Sitka ALASKA Varied
546884 Respiratory Therapist Sitka ALASKA 10 Hour Varied
547009 Wound Care Anchorage ALASKA 8 Hour Days
547289 ER CORDOVA ALASKA 12 Hour Nights
547775 Clinic Sitka ALASKA Varied
544192 PT Wrangell ALASKA Varied
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
545120 Case Manager Anchorage ALASKA 8 Hour Days
545251 Clinic Sitka ALASKA Varied
545392 CT Tech Anchorage ALASKA 12 Hour Days
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
503607 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
515962 Pediatrics Nome ALASKA 12 Hour Day/Night Rotate
521294 Ultrasound Tech Bethel ALASKA Days
521297 ER Bethel ALASKA 12 Hour Day/Night Rotate
522368 Clinic Bethel ALASKA Days
522373 LPN/LVN Bethel ALASKA Days
524120 PICU Anchorage ALASKA 12 Hour Nights RN/Registered Nurse
528504 SLP Juneau ALASKA Days
529510 CT Tech Bethel ALASKA 12 Hour Day/Night Rotate
532051 Long Term Care Nome ALASKA 12 Hour Day/Night Rotate
542501 Long Term Care Sitka ALASKA 8 Hour Evenings
543574 Case Manager Anchorage ALASKA 8 Hour Days
543808 Case Manager Anchorage ALASKA 8 Hour Days
544016 Social Worker Sitka ALASKA Varied
546683 PCU Birmingham ALABAMA 12 Hour Nights
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.7482 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 3600,100 in 1.5738 seconds