Listing all records

Displaying records 501 through 600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543130 Surgical Tech Fresno CALIFORNIA 10 Hour Days
540061 OR Farmington CONNECTICUT 10 Hour Days
547006 CVOR Charlottesville VIRGINIA 10 Hour Days
543129 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543128 Surgical Tech Fresno CALIFORNIA 10 Hour Days
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
543127 Surgical Tech Fresno CALIFORNIA 10 Hour Days
530228 CVOR Sioux City IOWA 10 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
540005 OR Farmington CONNECTICUT 10 Hour Days
543881 Cath Lab Philadelphia PENNSYLVANIA 10 Hour Days
547969 Surgical Tech Auburn NEW YORK 10 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
547479 CT Tech Arlington VIRGINIA 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
531702 OR Muskegon MICHIGAN 10 Hour Days
547326 CVOR Ann Arbor MICHIGAN 10 Hour Days
544196 Interventional Radiology Tech Arlington VIRGINIA 10 Hour Days
544316 Cath Lab Willoughby OHIO 10 Hour Days
544303 Ultrasound Tech Portland OREGON 10 Hour Days
547408 Ultrasound Tech Cooperstown NEW YORK 10 Hour Days
546367 OR Maywood ILLINOIS 10 Hour Days
540134 Cath Lab Concord CALIFORNIA 10 Hour Days
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
532559 MRI Tech Louisville KENTUCKY 10 Hour Days
532657 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
547606 Surgical Tech Boise IDAHO 10 Hour Days
535037 Cath Lab Rockville MARYLAND 10 Hour Days
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
533260 RAD Tech Des Moines IOWA 10 Hour Days
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
548017 PACU Chico CALIFORNIA 10 Hour Days
544818 OR Maywood ILLINOIS 10 Hour Days
544886 OR Aspen COLORADO 10 Hour Days
544846 OR Espanola NEW MEXICO 10 Hour Days
545104 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545030 OR Gardner MASSACHUSETTS 10 Hour Days
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
534108 Echo Oceanside CALIFORNIA 10 Hour Days
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
545237 Surgical Tech CVOR Reno NEVADA 10 Hour Days
548083 Surgical Tech Seattle WASHINGTON 10 Hour Days Tech/Technologist
547764 CT Tech Phoenix ARIZONA 10 Hour Days
548067 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
545772 RAD Tech Gainesville FLORIDA 10 Hour Days
545606 Interventional Radiology Tech Mission Viejo CALIFORNIA 10 Hour Days
539151 Surgical Tech Fresno CALIFORNIA 10 Hour Days
548105 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
544508 Cath Lab Edgewood KENTUCKY 10 Hour Days
547860 Oncology Charlottesville VIRGINIA 10 Hour Days
547825 Interventional Radiology Vero Beach FLORIDA 10 Hour Days
540632 OR Maywood ILLINOIS 10 Hour Days
545640 EEG Tech Gainesville FLORIDA 10 Hour Days
546342 Cath Lab Lexington KENTUCKY 10 Hour Days
545691 RAD Tech Gainesville FLORIDA 10 Hour Days
548225 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
540206 PACU Concord CALIFORNIA 10 Hour Days
544502 Interventional Radiology Tech Fayetteville NORTH CAROLINA 10 Hour Days
546011 Surgical Tech CVOR Hays KANSAS 10 Hour Days
546213 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
540028 OR Concord CALIFORNIA 10 Hour Days
540616 Cath Lab Inglewood CALIFORNIA 10 Hour Days
540923 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
542997 Cath Lab Concord CALIFORNIA 10 Hour Days
546212 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
541643 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
546743 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
546345 CT Tech Goodyear ARIZONA 10 Hour Days
541491 Interventional Radiology Spokane WASHINGTON 10 Hour Days
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
541447 Cath Lab Everett WASHINGTON 10 Hour Days
541482 CVOR Spokane WASHINGTON 10 Hour Days
541486 CVOR Spokane WASHINGTON 10 Hour Days
541484 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541473 CVOR Spokane WASHINGTON 10 Hour Days
541606 Surgical Tech CVOR Lubbock TEXAS 10 Hour Days
541536 Cath Lab Portland OREGON 10 Hour Days
541642 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
540022 Interventional Radiology Farmington CONNECTICUT 10 Hour Days
542958 PT San Jose CALIFORNIA 10 Hour Days
536731 Surgical Tech Fresno CALIFORNIA 10 Hour Days
542846 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
538172 MRI Tech Germantown MARYLAND 10 Hour Days
547895 OR Coos Bay OREGON 10 Hour Days
542263 CVOR Charlottesville VIRGINIA 10 Hour Days
542321 CT Tech Boise IDAHO 10 Hour Days
546694 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
546762 Interventional Radiology Tech Gainesville FLORIDA 10 Hour Days
546711 OR Muskegon MICHIGAN 10 Hour Days
544347 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
540823 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
543005 CT Tech Oceanside CALIFORNIA 10 Hour Days
537715 OR Farmington CONNECTICUT 10 Hour Days
537716 OR Farmington CONNECTICUT 10 Hour Days
546689 OR Templeton CALIFORNIA 10 Hour Days
547956 Surgical Tech Glens Falls NEW YORK 10 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.3725 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.shift desc limit 500,100 in 1.2854 seconds