Listing all records

Displaying records 301 through 400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
544809 Cath Lab Lewiston MAINE Days
542847 SLP Oakland NEW JERSEY Days
532598 PTA Hanford CALIFORNIA Days
543293 PT Hudson FLORIDA Days
547883 PTA Daly City CALIFORNIA Days
532920 Oncology San Angelo TEXAS Days
535269 COTA San Andreas CALIFORNIA Days
546630 Med Surg Tele Laconia NEW HAMPSHIRE Nights
492265 Long Term Care Scottsbluff NEBRASKA Nights
547668 ICU Laconia NEW HAMPSHIRE Nights
547753 Med Surg Brooklyn NEW YORK Nights
547276 Sterile Processing Tech Muskegon MICHIGAN Nights
515845 MLT Louisville KENTUCKY Nights
547832 PICU Syracuse NEW YORK Nights
547871 L&D Cincinnati OHIO Nights
544648 OR Silver Spring MARYLAND Nights
544678 Oncology Midland TEXAS Nights
545305 Cath Lab Honolulu HAWAII Nights
543312 RAD Tech Denville NEW JERSEY Nights
546392 Sterile Processing Tech Muskegon MICHIGAN Nights
545380 L&D Lewistown MONTANA Nights
534941 Med Surg Cape Girardeau MISSOURI Nights
546047 MLT Columbus OHIO Nights
539068 ER Avalon CALIFORNIA Nights
537185 CT Tech Syracuse NEW YORK Nights
541785 CNA The Dalles OREGON Nights
534942 Med Surg Cape Girardeau MISSOURI Nights
547907 Med Surg New York NEW YORK Nights
547136 Pediatrics Quincy CALIFORNIA Nights
547062 Sterile Processing Tech Muskegon MICHIGAN Nights
547061 Sterile Processing Tech Muskegon MICHIGAN Nights
547624 L&D Laramie WYOMING Nights
547667 ICU Laconia NEW HAMPSHIRE Nights
547718 Rehab New York NEW YORK Nights
547420 Radiology New York NEW YORK Nights
545126 Med Surg Espanola NEW MEXICO Nights
547752 Med Surg Brooklyn NEW YORK Nights
547970 Pediatric ER Bronx NEW YORK Nights
544649 OR Silver Spring MARYLAND Nights
524992 Med Surg Boise IDAHO Nights
543297 OR Albuquerque NEW MEXICO Nights
545372 Step Down Cincinnati OHIO Nights
547794 Pediatrics Valley City NORTH DAKOTA Nights
543370 Surgical Tech Silver Spring MARYLAND Nights
543527 Step Down Lansing MICHIGAN Nights
539898 Cardiovascular York PENNSYLVANIA Nights
535638 Rehab Cape Girardeau MISSOURI Nights
546265 ER Cincinnati OHIO Nights
546063 Med Surg Roosevelt UTAH Nights
545370 Step Down Cincinnati OHIO Nights
546393 OR Johnson City TENNESSEE Nights
530378 Med Surg Boise IDAHO Nights
530379 Med Surg Boise IDAHO Nights
541271 PCU Bismarck NORTH DAKOTA Nights
531433 Long Term Care Marion VIRGINIA Nights
546637 Sterile Processing Tech Muskegon MICHIGAN Nights
546805 OR Peoria ILLINOIS Nights
547579 MLT Watertown NEW YORK Nights
547707 ICU North Platte NEBRASKA Nights
544376 Sterile Processing Technician Langhorne PENNSYLVANIA Nights
545239 ER Columbus OHIO Nights
542114 Med Surg Tele Syracuse NEW YORK Nights
542299 ER Laconia NEW HAMPSHIRE Nights
547776 ER Morton WASHINGTON Nights
547763 CT Tech Glendale ARIZONA 10 Hour Nights
548018 MLT Aberdeen WASHINGTON 10 Hour Nights
545650 RAD Tech Gainesville FLORIDA 10 Hour Nights
540139 MLT Walnut Creek CALIFORNIA 10 Hour Nights
540070 CT Tech Concord CALIFORNIA 10 Hour Nights
547870 Med Surg Tele Rome NEW YORK 10 Hour Nights
546966 CT Tech Silverdale WASHINGTON 10 Hour Nights
548169 Interventional Radiology Tech Indianaplis INDIANA 10 Hour Nights Radiology Techs/Technologists
546552 Dialysis Brooklyn NEW YORK 10 Hour Nights
544929 CT Tech Titusville FLORIDA 10 Hour Nights
547277 CT Tech Sioux City IOWA 10 Hour Nights
548036 MLT New Bern NORTH CAROLINA 10 Hour Nights
545257 CT Tech Roseburg OREGON 10 Hour Nights
548032 CT Tech Columbus OHIO 10 Hour Nights
526794 CT Tech Silver Spring MARYLAND 10 Hour Nights
544375 Ultrasound Tech Silver Spring MARYLAND 10 Hour Nights
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
527625 Sterile Processing Technician Oceanside CALIFORNIA 10 Hour Nights
545651 RAD Tech Gainesville FLORIDA 10 Hour Nights
547244 CT Tech Birmingham ALABAMA 10 Hour Nights
545736 MRI Tech Gainesville FLORIDA 10 Hour Nights
540263 CT Tech Concord CALIFORNIA 10 Hour Nights
540278 CT Tech Concord CALIFORNIA 10 Hour Nights
530562 CT Tech Camp Hill PENNSYLVANIA 10 Hour Nights
540972 MLT Des Moines IOWA 10 Hour Nights
544343 CT Tech Boise IDAHO 10 Hour Nights
535301 MLT Pittsfield MASSACHUSETTS 10 Hour Nights
547781 CT Tech Goodyear ARIZONA 10 Hour Nights
544543 CT Tech Riverhead NEW YORK 10 Hour Nights
543129 Surgical Tech Fresno CALIFORNIA 10 Hour Days
548272 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
506863 Surgical Tech Durham NORTH CAROLINA 10 Hour Days
543130 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543128 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543337 OR Farmington CONNECTICUT 10 Hour Days
526713 CT Tech Silver Spring MARYLAND 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.6518 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 300,100 in 2.0939 seconds