Listing all records

Displaying records 2901 through 3000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
531037 Nuclear Medicine Oceanside CALIFORNIA 8 Hour Days
536828 Radiation Therapy Los Angeles CALIFORNIA 8 Hour Days
547861 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547681 Radiation Therapy Flint MICHIGAN 10 Hour Days
544811 Radiation Therapy Lewiston IDAHO 8 Hour Days
547939 Radiation Therapy Twin Falls IDAHO 12 Hour Days
546988 Radiation Therapy NORTHRIDGE CALIFORNIA 8 Hour Days
547862 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547585 RRT- Respiratory Louisville KENTUCKY 12 Hour Days
540516 RRT- Respiratory Chambersburg PENNSYLVANIA 12 Hour Day/Night Rotate
547889 RRT- Respiratory Meridian IDAHO 12 Hour Nights
547866 RRT- Respiratory Exeter NEW HAMPSHIRE 12 Hour Nights
545071 RRT- Respiratory Cleveland OHIO 12 Hour Nights
547788 RRT- Respiratory Cleveland OHIO 12 Hour Nights
545656 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545657 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545701 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545703 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545705 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545708 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545710 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545747 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545766 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545768 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545777 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545778 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545782 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545788 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545791 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545792 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545795 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545796 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545800 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545801 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545806 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545809 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545810 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545811 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545813 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
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
545821 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
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
545828 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545829 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545830 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545833 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545837 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545838 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545844 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545848 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545852 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545854 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545856 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545858 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545861 RRT- Respiratory 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
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
545965 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545968 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545969 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545971 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545973 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545976 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545977 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545978 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
548211 RRT- Respiratory Claremont NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
496231 COTA Oakhurst CALIFORNIA Days
518534 COTA NEWMAN CALIFORNIA Days
526368 COTA Colfax WISCONSIN Days
535268 COTA San Andreas CALIFORNIA Days
535269 COTA San Andreas CALIFORNIA Days
535651 COTA Rock Rapids IOWA Days
538440 COTA Monterey CALIFORNIA Days
541443 COTA Towson MARYLAND Days
543911 COTA Hanford CALIFORNIA Days
544168 COTA Madera CALIFORNIA Days
547064 COTA Crescent City CALIFORNIA 8 Hour Days
547592 Histology Technician Corvallis OREGON 8 Hour Days
540196 Histology Technician Walnut Creek CALIFORNIA 8 Hour Nights
543046 Histology Technician Watertown NEW YORK Days
547777 Histology Technician State College PENNSYLVANIA 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.7004 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.specialty asc limit 2900,100 in 2.1331 seconds