Listing all records

Displaying records 2901 through 3000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
544890 ER Concord CALIFORNIA 12 Hour Days
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
544908 ER Oceanside CALIFORNIA 12 Hour Nights
544909 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544910 RAD Tech Oceanside CALIFORNIA 8 Hour Days
544911 PT Apple Valley CALIFORNIA 10 Hour Days
544912 PT Apple Valley CALIFORNIA 10 Hour Days
544915 PT Mission Hills CALIFORNIA 8 Hour Days
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
545067 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
545084 RAD Tech San Diego CALIFORNIA 12 Hour Days
545096 ER Burbank CALIFORNIA 12 Hour Nights
546423 PT Hayward CALIFORNIA 8 Hour Days
545196 Social Worker Concord CALIFORNIA 8 Hour Days
545275 First Assist San Luis Obispo CALIFORNIA 8 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
545280 LPN/LVN SANTA MARIA CALIFORNIA 8 Hour Days
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
545313 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
545314 Interventional Radiology SANTA ROSA CALIFORNIA Days
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
545316 SLP Eureka CALIFORNIA 8 Hour Days
545317 PT SANTA ROSA CALIFORNIA 8 Hour Days
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
545453 ER Lynwood CALIFORNIA 12 Hour Nights
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
545514 L&D Arcata CALIFORNIA 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
545606 Interventional Radiology Tech Mission Viejo CALIFORNIA 10 Hour Days
545611 Cath Lab Mission Viejo CALIFORNIA 10 Hour Days
545613 EP Tech Mission Viejo CALIFORNIA 10 Hour Days
545943 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
545950 PT Sunnyvale CALIFORNIA Days
545951 PT Sunnyvale CALIFORNIA Days
545979 CT Tech Santa Barbara CALIFORNIA 12 Hour Day/Night Rotate
545988 Long Term Care King City CALIFORNIA 12 Hour Days
545989 Long Term Care King City CALIFORNIA 12 Hour Nights
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
545997 LPN/LVN King City CALIFORNIA 12 Hour Days
546035 PT Burbank CALIFORNIA 8 Hour Days
546036 PT Burbank CALIFORNIA 8 Hour Days
546281 Home Health Hayward CALIFORNIA 8 Hour Days
546800 ER Walnut Creek CALIFORNIA 12 Hour Nights
546081 Case Manager Santa Monica CALIFORNIA 8 Hour Days
540067 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540068 NICU Walnut Creek CALIFORNIA 12 Hour Days
540069 NICU Walnut Creek CALIFORNIA 12 Hour Days
540070 CT Tech Concord CALIFORNIA 10 Hour Nights
540071 PACU Concord CALIFORNIA 12 Hour Days
540072 ER Walnut Creek CALIFORNIA 12 Hour Nights
540073 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540074 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540075 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540076 ER Concord CALIFORNIA 12 Hour Nights
540077 OR Walnut Creek CALIFORNIA 12 Hour Days
540078 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540079 Cath Lab Concord CALIFORNIA 10 Hour Days
540080 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540081 Case Manager Concord CALIFORNIA 8 Hour Days
540082 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540084 OR Walnut Creek CALIFORNIA 12 Hour Days
540085 Psych Concord CALIFORNIA 8 Hour Evenings
540086 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540087 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540088 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540089 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540090 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540091 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540092 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540093 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540094 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540095 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540096 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540097 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540098 Case Manager Concord CALIFORNIA 8 Hour Evenings
540099 ER Concord CALIFORNIA 12 Hour Nights
540100 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540101 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540102 Med Surg Concord CALIFORNIA 12 Hour Nights
540103 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
540105 ICU Concord CALIFORNIA 12 Hour Nights
540106 ER Concord CALIFORNIA 12 Hour Nights
540107 Telemetry Concord CALIFORNIA 12 Hour Nights
540108 ER Concord CALIFORNIA 12 Hour Nights
540109 OR Walnut Creek CALIFORNIA 12 Hour Days
540110 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540111 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540112 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540113 Telemetry Concord CALIFORNIA 12 Hour Nights
540114 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540115 ER Walnut Creek CALIFORNIA 12 Hour Nights
540116 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540117 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540118 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540119 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540120 ICU Walnut Creek CALIFORNIA 12 Hour Days
540121 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
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.442 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 2900,100 in 1.3496 seconds