Listing all records

Displaying records 601 through 700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547536 RAD Tech Tulsa OKLAHOMA 12 Hour Days
547537 Med Surg Tele Tulsa OKLAHOMA 12 Hour Days
547562 Med Surg Tele Tulsa OKLAHOMA 12 Hour Nights
547908 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
547702 RAD Tech Oklahoma City OKLAHOMA 12 Hour Nights
547909 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
540725 Step Down Oklahoma City OKLAHOMA 12 Hour Nights
543955 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543957 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543958 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543959 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
544091 Med Surg Norman OKLAHOMA 12 Hour Nights
545244 Echo Technologist Tulsa OKLAHOMA 12 Hour Day/Night Rotate
460916 PT Lawton OKLAHOMA 8 Hour Days
512505 MRI Tech Lawton OKLAHOMA 8 Hour Days
520665 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521322 ICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521323 Step Down Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521324 CVICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521325 Oncology Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521326 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521327 Step Down Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521337 Med Surg Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521340 Med Surg Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521341 Oncology Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521981 Step Down Oklahoma City OKLAHOMA 12 Hour Days
521994 Step Down Oklahoma City OKLAHOMA 12 Hour Days
533274 PT Lawton OKLAHOMA Days
533275 PT Lawton OKLAHOMA Days
534888 Home Health Lawton OKLAHOMA 8 Hour Days
535919 Ultrasound Tech Lawton OKLAHOMA 8 Hour Days
548269 PCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
548265 ICU Columbus OHIO 12 Hour Nights RN/Registered Nurse
502855 Paramedic Cleveland OHIO Varied
517854 CT Tech Akron OHIO 10 Hour Days
525081 MRI Tech Grove City OHIO 12 Hour Days
525606 RAD Tech Columbus OHIO 8 Hour Evenings Radiology Techs/Technologists
526054 RAD Tech Cleveland OHIO 8 Hour Days Radiology Techs/Technologists
527092 PT Boardman OHIO Days
529165 Surgical Tech CVOR Cincinnati OHIO 10 Hour Days
531899 CT Tech Marysville OHIO 12 Hour Nights
532256 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
534249 Oncology Cleveland OHIO 12 Hour Days
534250 Oncology Cleveland OHIO 12 Hour Nights
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
535178 Interventional Radiology Tech Columbus OHIO 8 Hour Days
535179 CT Tech Columbus OHIO 12 Hour Days
535536 CNA Cincinnati OHIO Days
536801 Med Surg Tele Cleveland OHIO 12 Hour Nights
536850 Cath Lab Cleveland OHIO 8 Hour Days
536873 Telemetry Cleveland OHIO 12 Hour Nights
537981 ICU Cleveland OHIO 12 Hour Days
538278 Telemetry Cleveland OHIO 12 Hour Nights
538304 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
538382 CT Tech Cleveland OHIO 8 Hour Evenings
539629 CT Tech Cleveland OHIO 8 Hour Nights
538402 CT Tech Bellefontaine OHIO 12 Hour Nights
538717 Surgical Tech Columbus OHIO Days
538720 RN Columbus OHIO 12 Hour Days
538741 ICU Cleveland OHIO 12 Hour Day/Night Rotate
538951 Med Surg Tele Cleveland OHIO 12 Hour Nights
538956 Med Surg Tele Cleveland OHIO 12 Hour Nights
539009 Med Surg Tele Cleveland OHIO 12 Hour Nights
539277 Med Surg Tele Cleveland OHIO 12 Hour Nights
539278 Med Surg Tele Cleveland OHIO 12 Hour Nights
539708 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
539856 Med Surg Tele Cleveland OHIO 12 Hour Nights
539857 Med Surg Tele Cleveland OHIO 12 Hour Nights
540624 Surgical Tech Columbus OHIO 12 Hour Days
540637 PT Akron OHIO 8 Hour Days
540799 Med Surg Tele Euclid OHIO 12 Hour Nights
540821 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
540931 Med Surg Tele Cleveland OHIO 12 Hour Nights
540956 Interventional Therapy Grove City OHIO 8 Hour Days
540993 Med Surg Tele Chillicothe OHIO 12 Hour Nights
541323 Med Surg Tele Warrensville Heights OHIO 12 Hour Nights
541381 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
541384 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
542345 MLT Westerville OHIO 8 Hour Nights
542525 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
542526 ICU Cleveland OHIO 12 Hour Day/Night Rotate
542578 Outpatient Clinic Chillicothe OHIO 10 Hour Varied
542601 Ambulatory Cleveland OHIO 8 Hour Days
542657 PT Middletown OHIO Days
542908 ICU Cleveland OHIO 12 Hour Day/Night Rotate
542910 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
543336 CT Tech Westerville OHIO 10 Hour Days
543044 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
543045 Sterile Processing Tech Cleveland OHIO 8 Hour Evenings
543115 L&D Westerville OHIO 12 Hour Nights
543116 RN Columbus OHIO 8 Hour Days
543117 RN Columbus OHIO 10 Hour Days
543118 RN Columbus OHIO 12 Hour Nights
543119 Surgical Tech Columbus OHIO 12 Hour Days
543214 Telemetry Cleveland OHIO 12 Hour Nights
543215 Telemetry Cleveland OHIO 12 Hour Nights
543259 Step Down Cleveland OHIO 12 Hour Nights
543260 Step Down Cleveland OHIO 12 Hour Nights
543387 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
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.3196 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 600,100 in 1.537 seconds