Listing all records

Displaying records 3501 through 3600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546645 PT San Ramon CALIFORNIA Days
546646 PT San Ramon CALIFORNIA Days
546667 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
546686 PCU San Luis Obispo CALIFORNIA 12 Hour Nights
546687 PCU San Luis Obispo CALIFORNIA 12 Hour Days
546689 OR Templeton CALIFORNIA 10 Hour Days
546690 Surgical Tech Templeton CALIFORNIA 10 Hour Days
546692 Med Surg Oceanside CALIFORNIA 12 Hour Days
548153 Home Health Pomona CALIFORNIA 8 Hour Days RN/Registered Nurse
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
546694 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
546695 ER Oceanside CALIFORNIA 12 Hour Nights
546735 Telemetry Santa Monica CALIFORNIA 12 Hour Nights
546753 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
546783 PT Salinas CALIFORNIA 8 Hour Days PT/Physical Therapist
546801 PICU Walnut Creek CALIFORNIA 12 Hour Days
546802 NICU Walnut Creek CALIFORNIA 12 Hour Nights
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
546868 ER MERCED CALIFORNIA 12 Hour Days
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
546931 SLP Visalia CALIFORNIA 8 Hour Days
546951 Surgical Tech Long Beach CALIFORNIA 12 Hour Nights
546976 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546977 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546986 LPN/LVN SAN ANDREAS CALIFORNIA 8 Hour Days
546988 Radiation Therapy NORTHRIDGE CALIFORNIA 8 Hour Days
547056 PT Sacramento CALIFORNIA 8 Hour Days
547057 OT Sacramento CALIFORNIA 8 Hour Days
547064 COTA Crescent City CALIFORNIA 8 Hour Days
547070 PICU Walnut Creek CALIFORNIA 12 Hour Days
547071 PICU Walnut Creek CALIFORNIA 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
547082 Social Worker San Francisco CALIFORNIA 8 Hour Days
547083 Social Worker San Francisco CALIFORNIA 8 Hour Days
547119 RAD Tech REDWOOD CITY CALIFORNIA 8 Hour Days
547136 Pediatrics Quincy CALIFORNIA Nights
547329 NICU Mission Hills CALIFORNIA 12 Hour Nights
547331 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
547384 Registered Dietician Los Angeles CALIFORNIA 8 Hour Days
547397 SLP Pomona CALIFORNIA Days
547485 PT Union City CALIFORNIA 8 Hour Days
547531 L&D Arcata CALIFORNIA 12 Hour Nights
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
547570 Med Surg Per Diem/Local Contract Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547586 PICU Santa Clara CALIFORNIA 12 Hour Nights
547607 OT Crescent City CALIFORNIA 8 Hour Days
547608 OT Crescent City CALIFORNIA 8 Hour Days
547610 PICU Santa Clara CALIFORNIA 12 Hour Days
547611 PICU Santa Clara CALIFORNIA 12 Hour Nights
547612 PICU Santa Clara CALIFORNIA 12 Hour Nights
547613 PICU Santa Clara CALIFORNIA 12 Hour Nights
547614 PICU Santa Clara CALIFORNIA 12 Hour Nights
547616 PICU Santa Clara CALIFORNIA 12 Hour Days
547618 PICU Santa Clara CALIFORNIA 12 Hour Days
547620 PICU Santa Clara CALIFORNIA 12 Hour Days
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
547635 SLP San Diego CALIFORNIA 8 Hour Days
547636 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
547647 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
547664 ICU Oceanside CALIFORNIA 12 Hour Nights
547665 Oncology Oceanside CALIFORNIA 12 Hour Nights
547685 Electrophysiology Tech Monterey CALIFORNIA 8 Hour Days
547709 Pediatrics Alturas CALIFORNIA 12 Hour Day/Night Rotate
547720 OR Concord CALIFORNIA 8 Hour Days
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
547773 Rehab PARAMOUNT CALIFORNIA 12 Hour Days
547774 Rehab PARAMOUNT CALIFORNIA 12 Hour Nights
547782 PT Indio CALIFORNIA 8 Hour Days
547796 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
547806 PT Mammoth Lakes CALIFORNIA Days
547847 PCU Tarzana CALIFORNIA 12 Hour Nights
547883 PTA Daly City CALIFORNIA Days
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days RN/Registered Nurse
546811 CT Tech Harrison ARKANSAS 10 Hour Evenings
546812 Med Surg Harrison ARKANSAS 12 Hour Nights
546949 RAD Tech Hot Springs ARKANSAS 8 Hour Days
541058 OR Sherwood ARKANSAS 10 Hour Days
542007 Med Surg Hot Springs ARKANSAS 12 Hour Nights
542008 CVICU Little Rock ARKANSAS 12 Hour Days
519153 CVICU Little Rock ARKANSAS 12 Hour Nights
535216 Mammo Tech Juneau ARKANSAS Days
538454 CVICU Little Rock ARKANSAS 12 Hour Nights
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
546681 PACU Hot Springs ARKANSAS 8 Hour Days
544124 Cath Lab Fort Smith ARIZONA 8 Hour Day/Night Rotate
544493 Ultrasound Tech Prescott ARIZONA 10 Hour Evenings
544535 Psych Fort Defiance ARIZONA 12 Hour Varied
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
544796 Clinic Fort Defiance ARIZONA 8 Hour Days
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
547904 ICU Mesa ARIZONA 12 Hour Nights
545622 Cardiovascular Prescott ARIZONA 12 Hour Day/Night Rotate
545624 Surgical Tech CVOR Prescott ARIZONA 8 Hour Days
545625 Telemetry Prescott Valley ARIZONA 12 Hour Nights
545626 Telemetry Prescott Valley ARIZONA 12 Hour Day/Night Rotate
546005 PCU Mesa ARIZONA 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.5929 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 y.name desc limit 3500,100 in 1.4307 seconds