Listing all records

Displaying records 1501 through 1600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
545857 Med Surg Gainesville FLORIDA 12 Hour Nights
545858 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545859 Med Surg Gainesville FLORIDA 12 Hour Days
545860 Med Surg Gainesville FLORIDA 12 Hour Nights
545861 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545862 Med Surg Gainesville FLORIDA 12 Hour Nights
545863 Med Surg Gainesville FLORIDA 12 Hour Days
545864 ICU Gainesville FLORIDA 12 Hour Nights
545865 Med Surg Gainesville FLORIDA 12 Hour Days
545866 Med Surg Gainesville FLORIDA 12 Hour Days
545867 Cardiology Gainesville FLORIDA 12 Hour Nights
545868 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545869 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545870 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545871 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545872 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545873 Med Surg Gainesville FLORIDA 12 Hour Days
545874 MRI Tech Gainesville FLORIDA 8 Hour Days
545875 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545876 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545877 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545878 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545879 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545880 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545881 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545882 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545883 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545884 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545885 Med Surg Gainesville FLORIDA 12 Hour Nights
545886 ICU Gainesville FLORIDA 12 Hour Days
545889 Surgical Tech Gainesville FLORIDA 12 Hour Days
545890 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
545891 Med Surg Gainesville FLORIDA 12 Hour Nights
545892 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545893 Med Surg Gainesville FLORIDA 12 Hour Days
545894 ICU Gainesville FLORIDA 12 Hour Nights
545895 ICU Gainesville FLORIDA 12 Hour Nights
545896 ICU Gainesville FLORIDA 12 Hour Days
545897 Med Surg Gainesville FLORIDA 12 Hour Nights
545898 Med Surg Gainesville FLORIDA 12 Hour Days
545899 Med Surg Gainesville FLORIDA 12 Hour Days
545900 MLT Gainesville FLORIDA 12 Hour Nights
545901 MLT Gainesville FLORIDA 8 Hour Days
545902 ICU Gainesville FLORIDA 12 Hour Days
545903 Med Surg Gainesville FLORIDA 12 Hour Nights
545904 Med Surg Gainesville FLORIDA 12 Hour Nights
545905 Med Surg Gainesville FLORIDA 12 Hour Nights
545906 Med Surg Gainesville FLORIDA 12 Hour Days
545907 Med Surg Gainesville FLORIDA 12 Hour Days
545908 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.9288 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 1500,100 in 1.6238 seconds