Listing all records

Displaying records 3001 through 3100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
545122 Med Surg Lancaster OHIO 12 Hour Nights
543483 Med Surg Chillicothe OHIO 12 Hour Nights
543519 MRI Tech Beachwood OHIO 8 Hour Nights
543593 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
544043 Med Surg Tele Beachwood OHIO 12 Hour Days
544116 Telemetry Cleveland OHIO 12 Hour Nights
547954 L&D Cincinnati OHIO Days
547994 Med Surg Tele Warrensville Heights OHIO 12 Hour Days
547995 Med Surg Tele Warrensville Heights OHIO 12 Hour Days
548024 Telemetry Cleveland OHIO 12 Hour Nights
548032 CT Tech Columbus OHIO 10 Hour Nights
548066 ICU Bellefontaine OHIO 12 Hour Nights RN/Registered Nurse
548105 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
548302 CCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
548363 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
548372 Med Surg Tele Parma OHIO 12 Hour Nights RN/Registered Nurse
548373 Med Surg Tele Westlake OHIO 12 Hour Nights RN/Registered Nurse
548374 Med Surg Tele Concord OHIO 12 Hour Nights RN/Registered Nurse
548376 Med Surg Tele Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548380 Med Surg Tele Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548395 Telemetry Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548398 ICU Columbus OHIO 12 Hour Days RN/Registered Nurse
548408 OR Cleveland OHIO 12 Hour Days RN/Registered Nurse
548194 OR Norman OKLAHOMA 12 Hour Days RN/Registered Nurse
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
545244 Echo Technologist Tulsa OKLAHOMA 12 Hour Day/Night Rotate
546259 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546260 Oncology Oklahoma City OKLAHOMA 12 Hour Days
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.3122 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 asc limit 3000,100 in 1.4708 seconds