Listing all records

Displaying records 2301 through 2400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
545887 CT Tech Hereford TEXAS 8 Hour Days
545888 Therapy Rehab JEROME IDAHO 8 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
545909 ICU Gainesville FLORIDA 12 Hour Nights
545910 ICU Gainesville FLORIDA 12 Hour Nights
545911 ICU Gainesville FLORIDA 12 Hour Nights
545912 ICU Gainesville FLORIDA 12 Hour Nights
545913 ICU Gainesville FLORIDA 12 Hour Nights
545914 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545915 RAD Tech Richland WASHINGTON 12 Hour Day/Night Rotate
545918 Med Surg Gainesville FLORIDA 12 Hour Days
545919 Med Surg Gainesville FLORIDA 12 Hour Days
545920 Med Surg Gainesville FLORIDA 12 Hour Days
545921 Med Surg Gainesville FLORIDA 12 Hour Days
545922 Med Surg Gainesville FLORIDA 12 Hour Nights
545923 Med Surg Gainesville FLORIDA 12 Hour Nights
545924 Med Surg Gainesville FLORIDA 12 Hour Days
545925 Med Surg Gainesville FLORIDA 12 Hour Days
545926 Med Surg Gainesville FLORIDA 12 Hour Days
545927 Med Surg Gainesville FLORIDA 12 Hour Nights
545928 Med Surg Gainesville FLORIDA 12 Hour Days
545929 Med Surg Gainesville FLORIDA 12 Hour Days
545930 Med Surg Gainesville FLORIDA 12 Hour Days
545931 Med Surg Gainesville FLORIDA 12 Hour Nights
545932 Med Surg Gainesville FLORIDA 12 Hour Nights
545933 Med Surg Gainesville FLORIDA 12 Hour Days
545934 ICU Gainesville FLORIDA 12 Hour Nights
545935 Med Surg Gainesville FLORIDA 12 Hour Nights
545936 Med Surg Gainesville FLORIDA 12 Hour Nights
545937 Med Surg Gainesville FLORIDA 12 Hour Nights
545938 Med Surg Gainesville FLORIDA 12 Hour Days
545939 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545940 Med Surg Gainesville FLORIDA 12 Hour Days
545941 Med Surg Gainesville FLORIDA 12 Hour Days
545942 Med Surg Gainesville FLORIDA 12 Hour Nights
545943 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
545944 ICU Issaquah WASHINGTON 12 Hour Days
545945 Med Surg Gainesville FLORIDA 12 Hour Days
545946 Med Surg Gainesville FLORIDA 12 Hour Days
545950 PT Sunnyvale CALIFORNIA Days
545951 PT Sunnyvale CALIFORNIA Days
545954 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545955 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545960 Cath Lab Berwyn ILLINOIS 8 Hour Days
545961 Med Surg Gainesville FLORIDA 12 Hour Days
545962 ICU Gainesville FLORIDA 12 Hour Days
545963 Med Surg Gainesville FLORIDA 12 Hour Nights
545964 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
545965 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545966 Pediatrics Gainesville FLORIDA 12 Hour Nights
545967 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
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.6063 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 2300,100 in 1.5071 seconds