Listing all records

Displaying records 1401 through 1500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
545736 MRI Tech Gainesville FLORIDA 10 Hour Nights
545737 ICU Gainesville FLORIDA 12 Hour Nights
545738 ICU Gainesville FLORIDA 12 Hour Nights
545739 MRI Tech Gainesville FLORIDA 8 Hour Evenings
545740 Med Surg Gainesville FLORIDA 12 Hour Nights
545741 Med Surg Gainesville FLORIDA 12 Hour Days
545742 Med Surg Gainesville FLORIDA 12 Hour Nights
545743 Med Surg Gainesville FLORIDA 12 Hour Days
545744 MRI Tech Gainesville FLORIDA 8 Hour Evenings
545745 Med Surg Gainesville FLORIDA 12 Hour Days
545746 Med Surg Gainesville FLORIDA 12 Hour Days
545747 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545748 Med Surg Gainesville FLORIDA 12 Hour Days
545749 Med Surg Gainesville FLORIDA 12 Hour Days
545750 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545751 Med Surg Gainesville FLORIDA 12 Hour Days
545752 Med Surg Gainesville FLORIDA 12 Hour Nights
545753 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545754 Med Surg Gainesville FLORIDA 12 Hour Days
545755 Case Manager Gainesville FLORIDA 8 Hour Days
545756 Med Surg Gainesville FLORIDA 12 Hour Days
545757 Med Surg Gainesville FLORIDA 12 Hour Days
545758 Med Surg Gainesville FLORIDA 12 Hour Nights
545759 ICU Gainesville FLORIDA 12 Hour Nights
545760 ICU Gainesville FLORIDA 12 Hour Nights
545761 MLT Gainesville FLORIDA 8 Hour Nights
545762 Histology Technician Gainesville FLORIDA 8 Hour Days
545763 Surgical Tech Gainesville FLORIDA 12 Hour Days
545764 ICU Gainesville FLORIDA 12 Hour Nights
545765 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545766 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545767 Med Surg Gainesville FLORIDA 12 Hour Nights
545768 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545769 MLT Gainesville FLORIDA 8 Hour Evenings
545770 MRI Tech Gainesville FLORIDA 8 Hour Days
545771 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545772 RAD Tech Gainesville FLORIDA 10 Hour Days
545773 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545774 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
545775 Med Surg Gainesville FLORIDA 12 Hour Days
545776 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545777 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545778 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545779 Med Surg Gainesville FLORIDA 12 Hour Days
545780 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
545781 ICU Gainesville FLORIDA 12 Hour Nights
545782 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545783 RAD Tech Gainesville FLORIDA 10 Hour Evenings
545784 Med Surg Gainesville FLORIDA 12 Hour Nights
545785 Med Surg Gainesville FLORIDA 12 Hour Nights
545786 ICU Gainesville FLORIDA 12 Hour Days
545787 Med Surg Gainesville FLORIDA 12 Hour Days
545788 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545789 Med Surg Gainesville FLORIDA 12 Hour Nights
545790 MRI Tech Gainesville FLORIDA 8 Hour Evenings
545791 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545792 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545793 ICU Gainesville FLORIDA 12 Hour Nights
545794 Intermediate Care Gainesville FLORIDA 12 Hour Days
545795 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545796 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545797 Med Surg Gainesville FLORIDA 12 Hour Days
545798 Med Surg Gainesville FLORIDA 12 Hour Days
545799 Med Surg Gainesville FLORIDA 12 Hour Days
545800 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545801 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545802 Med Surg Gainesville FLORIDA 12 Hour Nights
545803 Med Surg Gainesville FLORIDA 12 Hour Nights
545804 Med Surg Gainesville FLORIDA 12 Hour Days
545805 Med Surg Gainesville FLORIDA 12 Hour Nights
545806 RRT- Respiratory 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.4764 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 1400,100 in 1.4182 seconds