Listing all records

Displaying records 2201 through 2300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
545707 Med Surg Gainesville FLORIDA 12 Hour Days
545708 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545709 ICU Gainesville FLORIDA 12 Hour Nights
545710 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545711 ICU Gainesville FLORIDA 12 Hour Nights
545712 Med Surg Gainesville FLORIDA 12 Hour Nights
545713 Med Surg Gainesville FLORIDA 12 Hour Days
545714 ICU Gainesville FLORIDA 12 Hour Nights
545715 Med Surg Gainesville FLORIDA 12 Hour Days
545716 ICU Gainesville FLORIDA 12 Hour Nights
545717 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545718 MLT Gainesville FLORIDA 8 Hour Nights
545719 Med Surg Gainesville FLORIDA 12 Hour Days
545720 ICU Gainesville FLORIDA 12 Hour Nights
545721 Med Surg Gainesville FLORIDA 12 Hour Days
545722 Med Surg Gainesville FLORIDA 12 Hour Days
545723 Med Surg Gainesville FLORIDA 12 Hour Nights
545724 Med Surg Gainesville FLORIDA 12 Hour Nights
545725 Med Surg Gainesville FLORIDA 12 Hour Days
545726 Med Surg Gainesville FLORIDA 12 Hour Nights
545727 Med Surg Gainesville FLORIDA 12 Hour Nights
545728 Med Surg Gainesville FLORIDA 12 Hour Nights
545729 Med Surg Gainesville FLORIDA 12 Hour Nights
545730 ICU Gainesville FLORIDA 12 Hour Nights
545731 ICU Gainesville FLORIDA 12 Hour Nights
545732 ICU Gainesville FLORIDA 12 Hour Nights
545733 Med Surg Gainesville FLORIDA 12 Hour Nights
545734 Med Surg Gainesville FLORIDA 12 Hour Days
545735 Med Surg Gainesville FLORIDA 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.8487 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 2200,100 in 1.6056 seconds