Listing all records

Displaying records 701 through 800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545243 Scrub Tech The Dalles OREGON 12 Hour Day/Night Rotate
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
543978 Scrub Tech Lamar COLORADO 8 Hour Day/Night Rotate
548158 Scrub Tech Abilene TEXAS 8 Hour Days CST/Certified Surgical Technician
547426 Scrub Tech Kingsport TENNESSEE 8 Hour Days
543785 Scrub Tech Redding CALIFORNIA 12 Hour Day/Night Rotate
539384 Scrub Tech Newark NEW JERSEY 12 Hour Days
543046 Histology Technician Watertown NEW YORK Days
545762 Histology Technician Gainesville FLORIDA 8 Hour Days
547592 Histology Technician Corvallis OREGON 8 Hour Days
540196 Histology Technician Walnut Creek CALIFORNIA 8 Hour Nights
547777 Histology Technician State College PENNSYLVANIA Days
496231 COTA Oakhurst CALIFORNIA Days
518534 COTA NEWMAN CALIFORNIA Days
544168 COTA Madera CALIFORNIA Days
541443 COTA Towson MARYLAND Days
543911 COTA Hanford CALIFORNIA Days
526368 COTA Colfax WISCONSIN Days
547064 COTA Crescent City CALIFORNIA 8 Hour Days
535268 COTA San Andreas CALIFORNIA Days
535269 COTA San Andreas CALIFORNIA Days
535651 COTA Rock Rapids IOWA Days
538440 COTA Monterey CALIFORNIA Days
547889 RRT- Respiratory Meridian IDAHO 12 Hour Nights
545880 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545708 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545811 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545806 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545882 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545777 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545656 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545766 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545791 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545703 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545792 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545881 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545971 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545973 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545833 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545710 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545977 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545976 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545705 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
547866 RRT- Respiratory Exeter NEW HAMPSHIRE 12 Hour Nights
547585 RRT- Respiratory Louisville KENTUCKY 12 Hour Days
545796 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545837 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545071 RRT- Respiratory Cleveland OHIO 12 Hour Nights
545818 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545815 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545821 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545877 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545830 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545872 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545828 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545879 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545816 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
548211 RRT- Respiratory Claremont NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
545800 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
547788 RRT- Respiratory Cleveland OHIO 12 Hour Nights
545829 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545788 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545817 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545768 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545701 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545747 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545856 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545848 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545844 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545838 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545810 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545824 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
540516 RRT- Respiratory Chambersburg PENNSYLVANIA 12 Hour Day/Night Rotate
545795 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545778 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545782 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545869 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545809 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545813 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545861 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545823 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545825 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545826 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545969 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545868 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545875 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545884 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545871 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545878 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545852 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545854 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545870 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545883 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545858 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545801 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545876 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545965 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545657 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545978 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.4497 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 desc limit 700,100 in 1.3331 seconds