Listing all records

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

ID Job Specialty City State Shift Title
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
543703 RAD Tech Commerce Twp MICHIGAN 8 Hour Nights
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
545311 ICU Colville WASHINGTON 12 Hour Nights
541647 Med Surg Colville WASHINGTON 12 Hour Nights
540624 Surgical Tech Columbus OHIO 12 Hour Days
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
545239 ER Columbus OHIO Nights
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
546047 MLT Columbus OHIO Nights
548265 ICU Columbus OHIO 12 Hour Nights RN/Registered Nurse
525606 RAD Tech Columbus OHIO 8 Hour Evenings Radiology Techs/Technologists
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
535178 Interventional Radiology Tech Columbus OHIO 8 Hour Days
535179 CT Tech Columbus OHIO 12 Hour Days
538717 Surgical Tech Columbus OHIO Days
538720 RN Columbus OHIO 12 Hour Days
546422 Surgical Tech Columbus OHIO Days
547797 RAD Tech Columbus OHIO 8 Hour Days
547798 RAD Tech Columbus OHIO 8 Hour Days
548032 CT Tech Columbus OHIO 10 Hour Nights
548398 ICU Columbus OHIO 12 Hour Days RN/Registered Nurse
548091 OR Columbia SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
521068 Echo Columbia SOUTH CAROLINA 8 Hour Days
538580 Echo Technologist Columbia MISSOURI Days
542718 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
545539 Interventional Radiology Tech Columbia SOUTH CAROLINA 8 Hour Days
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
547652 Echo Columbia SOUTH CAROLINA 8 Hour Days
547865 Certified Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547872 Med Surg Columbia MISSOURI 12 Hour Nights
547873 Endoscopy Columbia MISSOURI 8 Hour Varied
526368 COTA Colfax WISCONSIN Days
548086 Ultrasound Tech Cobleskill NEW YORK 8 Hour Days Tech/Technologist
548106 ER Cobleskill NEW YORK 12 Hour Nights RN/Registered Nurse
542497 PT Clovis NEW MEXICO 8 Hour Days
546110 PTA Clovis NEW MEXICO 8 Hour Days
535387 Rehab Clive IOWA 12 Hour Nights
539711 CT Tech Clinton IOWA 12 Hour Days
502855 Paramedic Cleveland OHIO Varied
526054 RAD Tech Cleveland OHIO 8 Hour Days Radiology Techs/Technologists
534249 Oncology Cleveland OHIO 12 Hour Days
534250 Oncology Cleveland OHIO 12 Hour Nights
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
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
538382 CT Tech Cleveland OHIO 8 Hour Evenings
539629 CT Tech Cleveland OHIO 8 Hour Nights
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
539856 Med Surg Tele Cleveland OHIO 12 Hour Nights
539857 Med Surg Tele Cleveland OHIO 12 Hour Nights
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
544158 PACU Cleveland OHIO 12 Hour Nights
544312 BMT Cleveland OHIO 12 Hour Day/Night Rotate
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544628 Psych Cleveland OHIO 12 Hour Nights
544788 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
544848 Pharmacy Tech Cleveland OHIO 8 Hour Days
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
545165 Telemetry Cleveland OHIO 12 Hour Nights
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
546643 Cath Lab Cleveland OHIO 10 Hour Days
545582 Step Down Cleveland 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
546186 Med Surg Tele Cleveland OHIO 12 Hour Nights
546246 Clinic Cleveland OHIO 8 Hour Days
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
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
546898 Telemetry Cleveland OHIO 12 Hour Nights
546902 Telemetry Cleveland OHIO 12 Hour Nights
546904 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.5995 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 z.city desc limit 3000,100 in 1.2856 seconds