Listing all records

Displaying records 901 through 1000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540207 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540208 ICU Concord CALIFORNIA 12 Hour Days
540209 NICU Walnut Creek CALIFORNIA 12 Hour Days
540210 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540211 ICU Concord CALIFORNIA 12 Hour Nights
540212 Intermediate Care Concord CALIFORNIA 12 Hour Days
540213 ER Concord CALIFORNIA 12 Hour Days
540214 Case Manager Concord CALIFORNIA 8 Hour Evenings
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540217 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540218 ER Concord CALIFORNIA 12 Hour Nights
540219 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540220 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540221 PICU Walnut Creek CALIFORNIA 12 Hour Days
540222 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540223 ER Concord CALIFORNIA 12 Hour Days
540224 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540226 Telemetry Concord CALIFORNIA 12 Hour Days
540227 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540228 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540229 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540230 ICU Walnut Creek CALIFORNIA 12 Hour Days
540231 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540232 Psych Concord CALIFORNIA 8 Hour Nights
540233 PICU Walnut Creek CALIFORNIA 12 Hour Days
540234 ICU Concord CALIFORNIA 12 Hour Nights
540235 ICU Concord CALIFORNIA 12 Hour Days
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
540238 ICU Walnut Creek CALIFORNIA 12 Hour Days
540239 OR Walnut Creek CALIFORNIA 12 Hour Days
540240 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540241 ICU Concord CALIFORNIA 12 Hour Days
540242 ICU Concord CALIFORNIA 12 Hour Nights
540243 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540244 ICU Concord CALIFORNIA 12 Hour Days
540245 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540246 ICU Walnut Creek CALIFORNIA 12 Hour Days
540247 L&D Walnut Creek CALIFORNIA 12 Hour Days
540248 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540249 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
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
540253 Case Manager Concord CALIFORNIA 8 Hour Days
540254 NICU Walnut Creek CALIFORNIA 12 Hour Days
540255 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Days
540256 ER Concord CALIFORNIA 12 Hour Days
540257 NICU Walnut Creek CALIFORNIA 12 Hour Days
540258 ICU Concord CALIFORNIA 12 Hour Nights
540259 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Days
540260 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540261 Telemetry Concord CALIFORNIA 12 Hour Nights
540262 PICU Walnut Creek CALIFORNIA 12 Hour Days
540263 CT Tech Concord CALIFORNIA 10 Hour Nights
540264 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540265 Med Surg Concord CALIFORNIA 12 Hour Days
540266 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540267 Med Surg Concord CALIFORNIA 12 Hour Nights
540268 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540269 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540270 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540271 Med Surg Concord CALIFORNIA 12 Hour Days
540272 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Nights
540273 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540274 ICU Concord CALIFORNIA 12 Hour Days
540275 ICU Concord CALIFORNIA 12 Hour Days
540276 ICU Concord CALIFORNIA 12 Hour Nights
540277 ER Concord CALIFORNIA 12 Hour Nights
540278 CT Tech Concord CALIFORNIA 10 Hour Nights
540279 Med Surg Concord CALIFORNIA 12 Hour Nights
540280 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540281 ICU Concord CALIFORNIA 12 Hour Days
540282 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540283 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540284 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540285 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540286 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540287 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540288 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540289 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540290 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540291 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540292 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Days
540293 ICU Concord CALIFORNIA 12 Hour Nights
540294 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540295 ER Walnut Creek CALIFORNIA 12 Hour Days
540296 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540297 ER Concord CALIFORNIA 12 Hour Days
540298 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540299 L&D Walnut Creek CALIFORNIA 12 Hour Days
540300 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540301 PACU Concord CALIFORNIA 10 Hour Days
540302 Med Surg Concord CALIFORNIA 12 Hour Days
540303 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540304 L&D Walnut Creek CALIFORNIA 12 Hour Days
540305 OR Walnut Creek CALIFORNIA 12 Hour Nights
540306 Med Surg Concord 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.4993 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.id asc limit 900,100 in 1.1907 seconds