Listing all records

Displaying records 2601 through 2700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547675 OR Waterloo IOWA 12 Hour Days
545498 Respiratory Therapist Des Moines IOWA 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
545500 Med Surg Tele Des Moines IOWA 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 12 Hour Days
545526 Med Surg Memphis TENNESSEE 12 Hour Days
547656 Rehab Omaha NEBRASKA 12 Hour Days
547973 Med Surg Oneonta NEW YORK 12 Hour Days
547574 Med Surg Lewiston MAINE 12 Hour Days
547403 Med Surg Tele Kansas City MISSOURI 12 Hour Days
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
545925 Med Surg Gainesville FLORIDA 12 Hour Days
545926 Med Surg Gainesville FLORIDA 12 Hour Days
545928 Med Surg Gainesville FLORIDA 12 Hour Days
545929 Med Surg Gainesville FLORIDA 12 Hour Days
545930 Med Surg Gainesville FLORIDA 12 Hour Days
545933 Med Surg Gainesville FLORIDA 12 Hour Days
545938 Med Surg Gainesville FLORIDA 12 Hour Days
545940 Med Surg Gainesville FLORIDA 12 Hour Days
545941 Med Surg Gainesville FLORIDA 12 Hour Days
545944 ICU Issaquah WASHINGTON 12 Hour Days
545945 Med Surg Gainesville FLORIDA 12 Hour Days
545946 Med Surg Gainesville FLORIDA 12 Hour Days
545961 Med Surg Gainesville FLORIDA 12 Hour Days
545962 ICU Gainesville FLORIDA 12 Hour Days
545964 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
545965 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545969 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545971 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545974 Med Surg Gainesville FLORIDA 12 Hour Days
545976 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545977 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545978 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545988 Long Term Care King City CALIFORNIA 12 Hour Days
545997 LPN/LVN King City CALIFORNIA 12 Hour Days
546005 PCU Mesa ARIZONA 12 Hour Days
546057 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
546084 Med Surg Tele Spokane WASHINGTON 12 Hour Days
546096 ICU Hilo HAWAII 12 Hour Days
546127 Med Surg Oxford NORTH CAROLINA 12 Hour Days
546128 Certified Surgical Tech Florence SOUTH CAROLINA 12 Hour Days
546129 Med Surg Portland OREGON 12 Hour Days
546141 Med Surg Des Moines IOWA 12 Hour Days
546142 Cardiology Muskegon MICHIGAN 12 Hour Days
547013 Med Surg Tele Cleveland OHIO 12 Hour Days
546198 Med Surg Bristol TENNESSEE 12 Hour Days
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
546251 CNA TOWNSHEND VERMONT 12 Hour Days
546259 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546260 Oncology Oklahoma City OKLAHOMA 12 Hour Days
547626 Certified Surgical Tech Santa Monica CALIFORNIA 12 Hour Days
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547015 Med Surg Tele Cleveland OHIO 12 Hour Days
546317 CT Tech ODESSA TEXAS 12 Hour Days
546331 ER Centerville IOWA 12 Hour Days
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
547014 Med Surg Tele Cleveland OHIO 12 Hour Days
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
546412 Med Surg Springfield VERMONT 12 Hour Days
546431 Med Surg Gainesville FLORIDA 12 Hour Days
546432 Telemetry Farmington CONNECTICUT 12 Hour Days
546461 ER Des Moines IOWA 12 Hour Days
546448 Nuclear Med Technician Santa Monica CALIFORNIA 12 Hour Days
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
546462 ER Des Moines IOWA 12 Hour Days
547126 ER Des Moines IOWA 12 Hour Days
546470 ICU East Norriton PENNSYLVANIA 12 Hour Days
546472 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Days
546554 Dialysis Brooklyn NEW YORK 12 Hour Days
546561 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546566 ICU Brooklyn NEW YORK 12 Hour Days
546567 ICU Brooklyn NEW YORK 12 Hour Days
546568 NICU Brooklyn NEW YORK 12 Hour Days
546573 MICU Brooklyn NEW YORK 12 Hour Days
546574 MICU Brooklyn NEW YORK 12 Hour Days
546576 MICU Brooklyn NEW YORK 12 Hour Days
546590 Med Surg Brooklyn NEW YORK 12 Hour Days
546591 MICU Brooklyn NEW YORK 12 Hour Days
546602 CT Tech Minneapolis MINNESOTA 12 Hour Days
546608 Med Surg Spokane WASHINGTON 12 Hour Days
546622 ER Saratoga Springs NEW YORK 12 Hour Days
546623 ER Saratoga Springs NEW YORK 12 Hour Days
546624 ER Saratoga Springs NEW YORK 12 Hour Days
546625 ER Saratoga Springs NEW YORK 12 Hour Days
546629 PCU Bristol TENNESSEE 12 Hour Days
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
546679 OR Waterloo IOWA 12 Hour Days
546684 L&D Detroit MICHIGAN 12 Hour Days
546687 PCU San Luis Obispo CALIFORNIA 12 Hour Days
546692 Med Surg Oceanside CALIFORNIA 12 Hour Days
546697 Surgical Tech Reno NEVADA 12 Hour Days
546699 Med Surg Spokane WASHINGTON 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.4044 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 2600,100 in 1.5802 seconds