Listing all records

Displaying records 1601 through 1700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540102 Med Surg Concord CALIFORNIA 12 Hour Nights
540103 L&D Walnut Creek CALIFORNIA 12 Hour Nights
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
540110 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540112 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540113 Telemetry Concord CALIFORNIA 12 Hour Nights
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
540121 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540123 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540124 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540126 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540127 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540129 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540133 ER Concord CALIFORNIA 12 Hour Nights
540135 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540136 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540137 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540146 ER Concord CALIFORNIA 12 Hour Nights
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
545840 Intermediate Care Gainesville FLORIDA 12 Hour Nights
540154 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540155 ER Walnut Creek CALIFORNIA 12 Hour Nights
540157 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
540164 Med Surg Concord CALIFORNIA 12 Hour Nights
540165 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540167 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540168 Pediatrics Walnut Creek CALIFORNIA 12 Hour Nights
540170 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540171 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540172 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540173 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540174 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540175 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540191 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540197 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540199 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540200 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540201 ER Concord CALIFORNIA 12 Hour Nights
540202 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540203 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545673 Med Surg Gainesville FLORIDA 12 Hour Nights
540210 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540211 ICU Concord CALIFORNIA 12 Hour Nights
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540218 ER Concord CALIFORNIA 12 Hour Nights
540219 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540220 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
545674 Intermediate Care Gainesville FLORIDA 12 Hour Nights
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540234 ICU Concord CALIFORNIA 12 Hour Nights
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
540242 ICU Concord CALIFORNIA 12 Hour Nights
540243 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540250 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540251 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540252 NICU Walnut Creek CALIFORNIA 12 Hour Nights
545227 Telemetry Cleveland OHIO 12 Hour Nights
545644 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
544530 Med Surg Waterloo IOWA 12 Hour Nights
544116 Telemetry Cleveland OHIO 12 Hour Nights
545847 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545711 ICU Gainesville FLORIDA 12 Hour Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
545653 Med Surg Gainesville FLORIDA 12 Hour Nights
545826 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545825 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544149 Long Term Care Moscow IDAHO 12 Hour Nights
544153 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
544158 PACU Cleveland OHIO 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
545828 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545827 Med Surg Gainesville FLORIDA 12 Hour Nights
544952 Med Surg Boise IDAHO 12 Hour Nights
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544208 Med Surg Grove City OHIO 12 Hour Nights
544209 Med Surg Grove City OHIO 12 Hour Nights
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
544215 Med Surg Tele Pueblo COLORADO 12 Hour Nights
544217 Med Surg Pella IOWA 12 Hour Nights
544222 ICU Passaic NEW JERSEY 12 Hour Nights
545830 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544225 Med Surg Dover NEW JERSEY 12 Hour Nights
545833 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545832 ICU Gainesville FLORIDA 12 Hour Nights
544230 ER Denville NEW JERSEY 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.7094 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 asc limit 1600,100 in 1.5022 seconds