Listing all records

Displaying records 2901 through 3000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
545191 Surgical Tech New Albany OHIO 12 Hour Days
545227 Telemetry Cleveland OHIO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545229 Telemetry Cleveland OHIO 12 Hour Nights
545230 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
545232 Step Down Cleveland OHIO 12 Hour Nights
545233 Step Down Cleveland OHIO 12 Hour Nights
545239 ER Columbus OHIO Nights
545240 ER Grove City OHIO 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
545370 Step Down Cincinnati OHIO Nights
545371 Step Down Cincinnati OHIO Days
545372 Step Down Cincinnati OHIO Nights
546643 Cath Lab Cleveland OHIO 10 Hour Days
545421 RN Columbus OHIO 12 Hour Nights
545541 RAD Tech Columbus OHIO 8 Hour Nights
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
545579 ER Willoughby OHIO 12 Hour Nights
545582 Step Down Cleveland OHIO 12 Hour Nights
546020 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546021 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546047 MLT Columbus OHIO Nights
546077 ER Paulding OHIO 12 Hour Nights
546169 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546170 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546172 Med Surg Tele Gallipolis OHIO 12 Hour Nights
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
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
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.721 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 2900,100 in 1.5838 seconds