Listing all records

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

ID Job Specialty City State Shift Title
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540187 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540189 Peri-Operative Concord CALIFORNIA 8 Hour Days
540192 OR Concord CALIFORNIA 12 Hour Days
540194 Case Manager Concord CALIFORNIA 8 Hour Days
540195 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540197 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540198 ER Concord CALIFORNIA 12 Hour Days
540201 ER Concord CALIFORNIA 12 Hour Nights
540202 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540205 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540206 PACU Concord CALIFORNIA 10 Hour Days
540207 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540208 ICU Concord 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
540218 ER Concord CALIFORNIA 12 Hour Nights
540220 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540222 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540223 ER Concord CALIFORNIA 12 Hour Days
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
540231 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540232 Psych Concord CALIFORNIA 8 Hour Nights
540234 ICU Concord CALIFORNIA 12 Hour Nights
540235 ICU Concord 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
540253 Case Manager Concord CALIFORNIA 8 Hour Days
540256 ER Concord CALIFORNIA 12 Hour Days
540258 ICU Concord CALIFORNIA 12 Hour Nights
540261 Telemetry Concord CALIFORNIA 12 Hour Nights
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
540271 Med Surg Concord CALIFORNIA 12 Hour Days
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
540281 ICU Concord CALIFORNIA 12 Hour Days
540286 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540289 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540293 ICU Concord CALIFORNIA 12 Hour Nights
540297 ER Concord CALIFORNIA 12 Hour Days
540301 PACU Concord CALIFORNIA 10 Hour Days
540302 Med Surg Concord CALIFORNIA 12 Hour Days
540306 Med Surg Concord CALIFORNIA 12 Hour Nights
540308 Case Manager Concord CALIFORNIA 8 Hour Evenings
540313 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540318 Med Surg Concord CALIFORNIA 12 Hour Days
540319 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540322 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540323 Telemetry Concord CALIFORNIA 12 Hour Nights
540324 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540327 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540330 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540331 ER Concord CALIFORNIA 12 Hour Nights
540333 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540335 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540337 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540338 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540341 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540342 Telemetry Concord CALIFORNIA 12 Hour Days
540344 PACU Concord CALIFORNIA 12 Hour Days
540347 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540348 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540349 Telemetry Concord CALIFORNIA 12 Hour Nights
540350 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540743 PCU Concord CALIFORNIA 12 Hour Days
540744 PCU Concord CALIFORNIA 12 Hour Days
540852 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540895 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540910 Social Worker Concord CALIFORNIA 8 Hour Days
541039 Psych Concord CALIFORNIA 8 Hour Nights
541844 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
541257 OR Concord CALIFORNIA 10 Hour Evenings
541258 ICU Concord CALIFORNIA 12 Hour Days
541312 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
543152 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
542156 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
542758 Med Surg Tele Concord CALIFORNIA 12 Hour Days
542997 Cath Lab Concord CALIFORNIA 10 Hour Days
542944 ER Concord CALIFORNIA 12 Hour Nights
543153 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
543549 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543550 Med Surg Tele Concord CALIFORNIA 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.7396 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 desc limit 2900,100 in 1.6525 seconds