Listing all records

Displaying records 3201 through 3300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543337 OR Farmington CONNECTICUT 10 Hour Days
543338 OR Farmington CONNECTICUT 10 Hour Days
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
546032 PT San Jose CALIFORNIA 10 Hour Days
543881 Cath Lab Philadelphia PENNSYLVANIA 10 Hour Days
543944 RAD Tech Walnut Creek CALIFORNIA 10 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
543991 OR Omaha NEBRASKA 10 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
544196 Interventional Radiology Tech Arlington VIRGINIA 10 Hour Days
544251 OR Farmington CONNECTICUT 10 Hour Days
544293 OR Maywood ILLINOIS 10 Hour Days
544294 OR Maywood ILLINOIS 10 Hour Days
544303 Ultrasound Tech Portland OREGON 10 Hour Days
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
544316 Cath Lab Willoughby OHIO 10 Hour Days
544347 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544444 PT Santa Clara CALIFORNIA 10 Hour Days
548210 CNA South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
544502 Interventional Radiology Tech Fayetteville NORTH CAROLINA 10 Hour Days
544508 Cath Lab Edgewood KENTUCKY 10 Hour Days
544509 Cath Lab Edgewood KENTUCKY 10 Hour Days
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
548222 Certified Surgical Tech Sun City ARIZONA 10 Hour Days CST/Certified Surgical Technician
544812 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544818 OR Maywood ILLINOIS 10 Hour Days
544846 OR Espanola NEW MEXICO 10 Hour Days
544886 OR Aspen COLORADO 10 Hour Days
544911 PT Apple Valley CALIFORNIA 10 Hour Days
544912 PT Apple Valley CALIFORNIA 10 Hour Days
545030 OR Gardner MASSACHUSETTS 10 Hour Days
545103 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545104 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
545237 Surgical Tech CVOR Reno NEVADA 10 Hour Days
546704 CT Tech Des Moines IOWA 10 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
545303 PACU Farmington CONNECTICUT 10 Hour Days
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
546643 Cath Lab Cleveland OHIO 10 Hour Days
545553 Outpatient Clinic Greencastle INDIANA 10 Hour Days
545772 RAD Tech Gainesville FLORIDA 10 Hour Days
546011 Surgical Tech CVOR Hays KANSAS 10 Hour Days
546168 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
546212 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
546213 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
546289 CT Tech Alexandria VIRGINIA 10 Hour Days
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
546345 CT Tech Goodyear ARIZONA 10 Hour Days
546367 OR Maywood ILLINOIS 10 Hour Days
548303 OR New York NEW YORK 10 Hour Days RN/Registered Nurse
546473 Cath Lab Woonsocket RHODE ISLAND 10 Hour Days
546604 RAD Tech Lewiston MAINE 10 Hour Days
546609 EP Tech Pinehurst NORTH CAROLINA 10 Hour Days
546667 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
546682 RAD Tech Lexington KENTUCKY 10 Hour Days
546689 OR Templeton CALIFORNIA 10 Hour Days
546690 Surgical Tech Templeton CALIFORNIA 10 Hour Days
546694 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
546711 OR Muskegon MICHIGAN 10 Hour Days
546743 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
546757 OR Petoskey MICHIGAN 10 Hour Days
546762 Interventional Radiology Tech Gainesville FLORIDA 10 Hour Days
548105 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
546825 Surgical Tech CVOR Parkersburg WEST VIRGINIA 10 Hour Days
546856 Certified Surgical Tech Berlin MARYLAND 10 Hour Days
546942 Perfusionist Boston MASSACHUSETTS 10 Hour Days
547006 CVOR Charlottesville VIRGINIA 10 Hour Days
547045 Cath Lab New Bern NORTH CAROLINA 10 Hour Days
547094 Surgical Tech CVOR Lewiston MAINE 10 Hour Days
547295 Oncology Coos Bay OREGON 10 Hour Days
547326 CVOR Ann Arbor MICHIGAN 10 Hour Days
547369 Interventional Radiology Tech Clearwater FLORIDA 10 Hour Days
547408 Ultrasound Tech Cooperstown NEW YORK 10 Hour Days
547440 Electrophysiology Tech Birmingham ALABAMA 10 Hour Days
547442 Electrophysiology Tech San Antonio TEXAS 10 Hour Days
547479 CT Tech Arlington VIRGINIA 10 Hour Days
548155 OR Coos Bay OREGON 10 Hour Days RN/Registered Nurse
547923 OR Muskegon MICHIGAN 10 Hour Days
547606 Surgical Tech Boise IDAHO 10 Hour Days
547637 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
547681 Radiation Therapy Flint MICHIGAN 10 Hour Days
547700 CVOR Sun City ARIZONA 10 Hour Days
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
547764 CT Tech Phoenix ARIZONA 10 Hour Days
547795 OR Tuba City ARIZONA 10 Hour Days
547825 Interventional Radiology Vero Beach FLORIDA 10 Hour Days
547844 CT Tech Des Moines IOWA 10 Hour Days
547860 Oncology Charlottesville VIRGINIA 10 Hour Days
547888 Cath Lab Danville KENTUCKY 10 Hour Days
547891 Therapy Rehab Twin Falls IDAHO 10 Hour Days
547892 SLP Twin Falls IDAHO 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.5971 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 asc limit 3200,100 in 1.4222 seconds