Listing all records

Displaying records 2201 through 2300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
538714 Respiratory Therapist Mason City IOWA 12 Hour Nights
539712 Home Health Mason City IOWA 8 Hour Days
545252 GI Lab Mason City IOWA 8 Hour Days
544889 MLT Mason City IOWA 8 Hour Days
540626 OR Mason City IOWA 8 Hour Days
540627 OR Mason City IOWA 8 Hour Days
540628 OR Mason City IOWA 8 Hour Days
542642 Cath Lab Mason City IOWA 8 Hour Days
543126 Cath Lab Mason City IOWA 8 Hour Days
548163 OR Mason City IOWA 8 Hour Days RN/Registered Nurse
545621 ER Massena NEW YORK 12 Hour Nights
531618 Med Surg Massena NEW YORK 12 Hour Nights
517904 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
517913 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
546020 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546021 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
540821 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
541384 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
540632 OR Maywood ILLINOIS 10 Hour Days
524930 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524932 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524933 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524972 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524989 Telemetry Maywood ILLINOIS 12 Hour Nights
532473 ICU Maywood ILLINOIS 12 Hour Nights
535604 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536228 RAD Tech Maywood ILLINOIS 8 Hour Nights
536231 CT Tech Maywood ILLINOIS 8 Hour Evenings
536440 Infusion Oncology Maywood ILLINOIS 8 Hour Days
536499 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536500 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536501 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536502 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536503 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536504 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536505 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536506 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536507 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536508 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536932 RAD Tech Maywood ILLINOIS 8 Hour Days
546367 OR Maywood ILLINOIS 10 Hour Days
544293 OR Maywood ILLINOIS 10 Hour Days
544294 OR Maywood ILLINOIS 10 Hour Days
544818 OR Maywood ILLINOIS 10 Hour Days
547886 CT Tech McCall IDAHO 12 Hour Nights
547887 CT Tech McCall IDAHO Days
532545 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
536227 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
547246 Postpartum Memphis TENNESSEE 12 Hour Nights
547977 ICU Memphis TENNESSEE 12 Hour Nights
548310 ER Memphis TENNESSEE 12 Hour Nights RN/Registered Nurse
545292 CVICU Memphis TENNESSEE 12 Hour Nights
545526 Med Surg Memphis TENNESSEE 12 Hour Days
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
546868 ER MERCED CALIFORNIA 12 Hour Days
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
541028 SLP MERCED CALIFORNIA 8 Hour Days
484788 PTA Merced CALIFORNIA Days
548161 Surgical Tech MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548114 Telemetry MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548391 ICU Merced CALIFORNIA 12 Hour Nights RN/Registered Nurse
544354 Med Surg Meridian IDAHO 12 Hour Nights
547318 ICU Meridian IDAHO 12 Hour Nights
547889 RRT- Respiratory Meridian IDAHO 12 Hour Nights
547725 Med Surg Mesa ARIZONA 12 Hour Days
547728 PCU Mesa ARIZONA 12 Hour Nights
547729 PCU Mesa ARIZONA 12 Hour Days
547904 ICU Mesa ARIZONA 12 Hour Nights
546005 PCU Mesa ARIZONA 12 Hour Days
548133 Cath Lab Mesa ARIZONA 12 Hour Days RN/Registered Nurse
548200 Respiratory Therapist Mesa ARIZONA 12 Hour Days Respiratory Therapist
539674 Med Surg Mesa ARIZONA 12 Hour Nights
547957 OR Mesquite TEXAS 8 Hour Days
542657 PT Middletown OHIO Days
548041 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548148 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
544678 Oncology Midland TEXAS Nights
543591 SLP Milan MISSOURI Days
547810 Oncology Milford MASSACHUSETTS 12 Hour Nights
546602 CT Tech Minneapolis MINNESOTA 12 Hour Days
547947 Echo Minneapolis MINNESOTA 8 Hour Days
524675 CVOR Mishawaka INDIANA 12 Hour Days
539715 Respiratory Therapist Mishawaka INDIANA 12 Hour Days
544964 Nuclear Med Technician Mishawaka INDIANA 8 Hour Days
544265 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544266 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
545190 Pharmacy Tech Mishawaka INDIANA 8 Hour Nights
545425 L&D Mishawaka INDIANA 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
545427 NICU Mishawaka INDIANA 12 Hour Nights
544915 PT Mission Hills CALIFORNIA 8 Hour Days
546321 PT Mission Hills CALIFORNIA 8 Hour Days
547329 NICU Mission Hills CALIFORNIA 12 Hour Nights
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
547940 Nuclear Med Technician Mission Viejo CALIFORNIA 8 Hour Days
539477 Telemetry - Per Diem Mission Viejo CALIFORNIA 12 Hour Days RN/Registered Nurse
545606 Interventional Radiology Tech Mission Viejo CALIFORNIA 10 Hour Days
545611 Cath Lab Mission Viejo CALIFORNIA 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.5999 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 z.city asc limit 2200,100 in 1.257 seconds