Listing all records

Displaying records 701 through 800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
546186 Med Surg Tele Cleveland OHIO 12 Hour Nights
546230 RAD Tech Cincinnati OHIO 12 Hour Day/Night Rotate
546236 Dialysis Oregon OHIO 8 Hour Days
546246 Clinic Cleveland OHIO 8 Hour Days
546247 CT Tech Toledo OHIO 8 Hour Evenings
546265 ER Cincinnati OHIO Nights
546378 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
546421 Sterile Processing Technician Westerville OHIO 8 Hour Days
546422 Surgical Tech Columbus OHIO Days
546737 Med Surg Tele Cleveland OHIO 12 Hour Nights
546738 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546813 Clinic Cleveland OHIO 12 Hour Nights
546819 Med Surg Tele Canton OHIO 12 Hour Nights
546898 Telemetry Cleveland OHIO 12 Hour Nights
546902 Telemetry Cleveland OHIO 12 Hour Nights
546903 Med Surg Tele Canton OHIO 12 Hour Nights
546904 Telemetry Cleveland OHIO 12 Hour Nights
546943 Med Surg Tele Cleveland OHIO 12 Hour Nights
547013 Med Surg Tele Cleveland OHIO 12 Hour Days
547014 Med Surg Tele Cleveland OHIO 12 Hour Days
547015 Med Surg Tele Cleveland OHIO 12 Hour Days
547016 Med Surg Tele Cleveland OHIO 12 Hour Days
547043 Med Surg Tele Beachwood OHIO 12 Hour Nights
547104 Med Surg Tele Cleveland OHIO 12 Hour Nights
547105 Step Down Dover OHIO 12 Hour Nights
547106 Med Surg Tele Akron OHIO 12 Hour Nights
547107 Step Down Cleveland OHIO 12 Hour Nights
547108 Clinic Cleveland OHIO 12 Hour Nights
547321 Med Surg Tele Cuyahoga Falls OHIO 12 Hour Nights
547389 CT Tech Cleveland OHIO 8 Hour Nights
547390 CT Tech Cleveland OHIO 8 Hour Evenings
547392 Cath Lab Cleveland OHIO Days
547393 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547500 Med Surg Chillicothe OHIO 12 Hour Nights
547530 Cardiac ICU Chillicothe OHIO 12 Hour Nights
547557 CT Tech Akron OHIO 12 Hour Days
547573 Med Surg Chillicothe OHIO 12 Hour Days
547671 Med Surg Chillicothe OHIO 12 Hour Nights
547708 Surgical Tech CVOR Zanesville OHIO Days
547788 RRT- Respiratory Cleveland OHIO 12 Hour Nights
547797 RAD Tech Columbus OHIO 8 Hour Days
547798 RAD Tech Columbus OHIO 8 Hour Days
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
547808 RAD Tech Cleveland OHIO 10 Hour Day/Night Rotate
547809 RAD Tech Cleveland OHIO 8 Hour Days
547824 Med Surg Tele Canton OHIO 12 Hour Nights
547850 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547871 L&D Cincinnati OHIO Nights
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
544158 PACU Cleveland OHIO 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
544208 Med Surg Grove City OHIO 12 Hour Nights
544209 Med Surg Grove City OHIO 12 Hour Nights
544263 Surgical Tech Westerville OHIO 12 Hour Days
544312 BMT Cleveland OHIO 12 Hour Day/Night Rotate
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
544316 Cath Lab Willoughby OHIO 10 Hour Days
544403 First Assist Lancaster OHIO Days
544572 Step Down Willoughby OHIO 12 Hour Nights
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544626 Echo Toledo OHIO 8 Hour Days
544627 Med Surg Tele Akron OHIO 12 Hour Nights
544628 Psych Cleveland OHIO 12 Hour Nights
547595 First Assist Canton OHIO 12 Hour Days
544788 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
544835 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
544848 Pharmacy Tech Cleveland OHIO 8 Hour Days
544918 Step Down Parma OHIO 12 Hour Nights
545071 RRT- Respiratory Cleveland OHIO 12 Hour Nights
545103 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545104 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545136 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
545165 Telemetry Cleveland OHIO 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.5243 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 700,100 in 1.5272 seconds