Listing all records

Displaying records 1301 through 1400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546332 Sterile Processing Technician Fresno CALIFORNIA 8 Hour Days
543124 Cath Lab Fresno CALIFORNIA 12 Hour Days
543127 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543128 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543129 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543130 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
548340 ER Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548344 CVOR Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548346 Postpartum Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548379 Postpartum Fresno CALIFORNIA 12 Hour Nights RN/Registered Nurse
546431 Med Surg Gainesville FLORIDA 12 Hour Days
546476 Med Surg Gainesville FLORIDA 12 Hour Nights
546762 Interventional Radiology Tech Gainesville FLORIDA 10 Hour Days
545617 Med Surg Gainesville FLORIDA 12 Hour Days
545618 MLT Gainesville FLORIDA 8 Hour Nights
545619 Med Surg Gainesville FLORIDA 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
545628 Med Surg Gainesville FLORIDA 12 Hour Days
545629 ICU Gainesville FLORIDA 12 Hour Nights
545630 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545631 ICU Gainesville FLORIDA 12 Hour Nights
545632 Med Surg Gainesville FLORIDA 12 Hour Days
545633 Med Surg Gainesville FLORIDA 12 Hour Nights
545634 Med Surg Gainesville FLORIDA 12 Hour Days
545635 Med Surg Gainesville FLORIDA 12 Hour Nights
545636 ICU Gainesville FLORIDA 12 Hour Nights
545637 ICU Gainesville FLORIDA 12 Hour Nights
545638 Med Surg Gainesville FLORIDA 12 Hour Days
545639 ICU Gainesville FLORIDA 12 Hour Nights
545640 EEG Tech Gainesville FLORIDA 10 Hour Days
545641 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545642 Med Surg Gainesville FLORIDA 12 Hour Nights
545643 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545644 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545646 Med Surg Gainesville FLORIDA 12 Hour Days
545647 Med Surg Gainesville FLORIDA 12 Hour Days
545648 RAD Tech Gainesville FLORIDA 12 Hour Nights
545649 RAD Tech Gainesville FLORIDA 12 Hour Nights
545650 RAD Tech Gainesville FLORIDA 10 Hour Nights
545651 RAD Tech Gainesville FLORIDA 10 Hour Nights
545652 Med Surg Gainesville FLORIDA 12 Hour Nights
545653 Med Surg Gainesville FLORIDA 12 Hour Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
545655 Med Surg Gainesville FLORIDA 12 Hour Nights
545656 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545657 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545658 Med Surg Gainesville FLORIDA 12 Hour Days
545659 Med Surg Gainesville FLORIDA 12 Hour Days
545660 Med Surg Gainesville FLORIDA 12 Hour Days
545661 Med Surg Gainesville FLORIDA 12 Hour Days
545662 MLT Gainesville FLORIDA 12 Hour Nights
545663 MLT Gainesville FLORIDA 12 Hour Nights
545664 MLT Gainesville FLORIDA 8 Hour Days
545665 Surgical Tech Gainesville FLORIDA 12 Hour Days
545666 Surgical Tech CVOR Gainesville FLORIDA 12 Hour Days
545667 Med Surg Gainesville FLORIDA 12 Hour Days
545668 MLT Gainesville FLORIDA 8 Hour Days
545669 Case Manager Gainesville FLORIDA 10 Hour Days
545670 Med Surg Gainesville FLORIDA 12 Hour Days
545671 Cardiology Gainesville FLORIDA 12 Hour Nights
545672 RAD Tech Gainesville FLORIDA 12 Hour Days
545673 Med Surg Gainesville FLORIDA 12 Hour Nights
545674 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545675 ICU Gainesville FLORIDA 12 Hour Nights
545676 Med Surg Gainesville FLORIDA 12 Hour Nights
545677 Med Surg Gainesville FLORIDA 12 Hour Nights
545678 ICU Gainesville FLORIDA 12 Hour Days
545679 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545680 Med Surg Gainesville FLORIDA 12 Hour Days
545681 Med Surg Gainesville FLORIDA 12 Hour Nights
545682 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545683 Med Surg Gainesville FLORIDA 12 Hour Nights
545684 PACU Gainesville FLORIDA 12 Hour Days
545685 Med Surg Gainesville FLORIDA 12 Hour Days
545686 Med Surg Gainesville FLORIDA 12 Hour Nights
545687 ICU Gainesville FLORIDA 12 Hour Nights
545688 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545689 ICU Gainesville FLORIDA 12 Hour Nights
545690 Med Surg Gainesville FLORIDA 12 Hour Days
545691 RAD Tech Gainesville FLORIDA 10 Hour Days
545692 PICU Gainesville FLORIDA 12 Hour Nights
545693 ICU Gainesville FLORIDA 12 Hour Nights
545694 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545695 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545696 Ultrasound Tech Gainesville FLORIDA 8 Hour Days
545697 Med Surg Gainesville FLORIDA 12 Hour Days
545698 Med Surg Gainesville FLORIDA 12 Hour Days
545699 Med Surg Gainesville FLORIDA 12 Hour Nights
545700 Ultrasound Tech Gainesville FLORIDA 10 Hour Days
545701 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545702 Med Surg Gainesville FLORIDA 12 Hour Days
545703 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545704 Med Surg Gainesville FLORIDA 12 Hour Days
545705 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545706 Med Surg Gainesville FLORIDA 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.7521 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 asc limit 1300,100 in 1.9481 seconds