Listing all records

Displaying records 2701 through 2800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548298 Neuro Intensive Care PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
548360 CVICU Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
543510 Ultrasound Tech Phoenix ARIZONA 12 Hour Day/Night Rotate
546971 Radiology PHOENIX ARIZONA 12 Hour Nights
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
547468 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
547758 PCU Phoenix ARIZONA 12 Hour Nights
547764 CT Tech Phoenix ARIZONA 10 Hour Days
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
547486 MRI Tech Pierce Tacoma WASHINGTON 10 Hour Evenings
540864 CT Tech Pigeon MICHIGAN 12 Hour Nights
527593 PT Pinehurst NORTH CAROLINA 8 Hour Days
546405 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
546609 EP Tech Pinehurst NORTH CAROLINA 10 Hour Days
547046 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
540451 Surgical Tech CVOR Pinehurst NORTH CAROLINA 10 Hour Days
545133 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
547088 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
546877 MLT Pittsfield MASSACHUSETTS 8 Hour Days
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
547511 Certified Surgical Tech Pittsfield MASSACHUSETTS 8 Hour Days
547766 Wound Care Pittsfield MASSACHUSETTS 8 Hour Days
535301 MLT Pittsfield MASSACHUSETTS 10 Hour Nights
535302 MLT Pittsfield MASSACHUSETTS 8 Hour Days
548003 ER Pittsfield MASSACHUSETTS 12 Hour Nights
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
548100 PCU Pittsfield MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548182 CCU Pittsfield MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548296 RNFA Pittsfield MASSACHUSETTS 10 Hour Days RN/Registered Nurse
548406 PCU Pittsfield MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
541755 Med Surg Tele Pittsfield MASSACHUSETTS 12 Hour Nights
526505 PT Plains MONTANA Varied
538302 Home Health Plains MONTANA Varied
547305 PT Plains MONTANA Varied
548008 Respiratory Therapist Plains MONTANA Days
535908 SLP Plano TEXAS Days
546337 Medical Assistant Playa Vista CALIFORNIA 8 Hour Days
548116 ICU Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548159 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
545339 APRN Plymouth WISCONSIN Days
548240 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548241 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548239 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
534628 SLP Pomona CALIFORNIA Days
534629 SLP Pomona CALIFORNIA Days
548153 Home Health Pomona CALIFORNIA 8 Hour Days RN/Registered Nurse
547397 SLP Pomona CALIFORNIA Days
547799 RAD Tech Pontiac MICHIGAN 8 Hour Nights
547800 RAD Tech Pontiac MICHIGAN 8 Hour Nights
547876 RAD Tech Pontiac MICHIGAN 8 Hour Evenings
548249 Med Surg Pontiac MICHIGAN 12 Hour Days RN/Registered Nurse
548250 CST Pontiac MICHIGAN 8 Hour Days CST/Certified Surgical Technician
524703 CT Tech Pontiac MICHIGAN 8 Hour Nights
548052 Med Surg Pontiac MICHIGAN 12 Hour Nights RN/Registered Nurse
540599 Interventional Radiology Tech Pontiac MICHIGAN 8 Hour Days
544060 ICU Pontiac MICHIGAN 12 Hour Nights
544905 Mammo Tech Port Jefferson NEW YORK 8 Hour Days
545069 Mammo Tech Port Jefferson NEW YORK 8 Hour Days
547877 APRN Portage WISCONSIN Days
546736 Outpatient Clinic Portland OREGON 8 Hour Days
547089 Med Surg Portland OREGON 12 Hour Nights
547257 L&D Portland OREGON 12 Hour Nights
547258 ICU Portland OREGON 12 Hour Nights
547259 ICU Portland OREGON 12 Hour Nights
547260 ICU Portland OREGON 12 Hour Nights
547324 Telemetry Portland OREGON 12 Hour Nights
547642 Ambulatory Portland OREGON 8 Hour Days
547845 Med Surg Portland OREGON 12 Hour Nights
547848 CNA Portland OREGON 12 Hour Nights
544303 Ultrasound Tech Portland OREGON 10 Hour Days
544565 Outpatient Clinic Portland OREGON 8 Hour Days
544566 Med Surg Portland OREGON 12 Hour Nights
544876 Med Surg Tele Portland OREGON 12 Hour Nights
544877 Med Surg Tele Portland OREGON 12 Hour Nights
545092 ER Portland OREGON 12 Hour Nights
545098 Long Term Care Portland OREGON 12 Hour Days
546129 Med Surg Portland OREGON 12 Hour Days
546165 ER Portland OREGON 12 Hour Nights
547984 Home Health Portland OREGON 8 Hour Days
547985 Home Health Portland OREGON 8 Hour Days
548025 ICU Portland OREGON 12 Hour Nights
541536 Cath Lab Portland OREGON 10 Hour Days
541543 Case Manager Portland OREGON 8 Hour Days
541613 Ultrasound Tech Portland OREGON 8 Hour Days
542103 Medical Assistant Portland OREGON 12 Hour Nights
542104 Medical Assistant Portland OREGON 12 Hour Nights
544031 Telemetry Portland OREGON 12 Hour Nights
542713 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
543147 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
547396 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
540745 Telemetry Prescott ARIZONA 12 Hour Day/Night Rotate
540746 Med Surg Prescott ARIZONA 12 Hour Day/Night Rotate
540748 Med Surg Tele Prescott ARIZONA 12 Hour Days
540749 Med Surg Tele Prescott ARIZONA 12 Hour Day/Night Rotate
540770 Telemetry Prescott ARIZONA 12 Hour Days
544493 Ultrasound Tech Prescott ARIZONA 10 Hour Evenings
545622 Cardiovascular Prescott ARIZONA 12 Hour Day/Night Rotate
545624 Surgical Tech CVOR Prescott ARIZONA 8 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.4816 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 2700,100 in 1.6581 seconds