Listing all records

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

ID Job Specialty City State Shift Title
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
545807 Med Surg Gainesville FLORIDA 12 Hour Days
545808 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545809 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545810 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545811 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545812 ICU Gainesville FLORIDA 12 Hour Nights
545813 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545814 Med Surg Gainesville FLORIDA 12 Hour Days
545815 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545816 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545817 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545818 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545819 Med Surg Gainesville FLORIDA 12 Hour Nights
545820 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545821 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545822 Med Surg Gainesville FLORIDA 12 Hour Days
545823 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545824 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545825 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545826 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545827 Med Surg Gainesville FLORIDA 12 Hour Nights
545828 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545829 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545830 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545831 ICU Gainesville FLORIDA 12 Hour Days
545832 ICU Gainesville FLORIDA 12 Hour Nights
545833 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545834 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545835 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545836 ICU Gainesville FLORIDA 12 Hour Nights
545837 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545838 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545839 ICU Gainesville FLORIDA 12 Hour Nights
545840 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545841 Med Surg Gainesville FLORIDA 12 Hour Days
545842 ICU Gainesville FLORIDA 12 Hour Nights
545843 ICU Gainesville FLORIDA 12 Hour Days
545844 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545845 Med Surg Gainesville FLORIDA 12 Hour Nights
545846 Med Surg Gainesville FLORIDA 12 Hour Nights
545847 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545848 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545849 Med Surg Gainesville FLORIDA 12 Hour Nights
545850 Med Surg Gainesville FLORIDA 12 Hour Days
545851 ICU Gainesville FLORIDA 12 Hour Nights
545852 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545853 Med Surg Gainesville FLORIDA 12 Hour Days
545854 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545855 Med Surg Gainesville FLORIDA 12 Hour Days
545856 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.42 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 a.title asc limit 2200,100 in 1.4077 seconds