Listing all records

Displaying records 401 through 500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540175 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540176 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540177 Psych Concord CALIFORNIA 8 Hour Evenings
540178 Med Surg Concord CALIFORNIA 8 Hour Evenings
540179 Case Manager Concord CALIFORNIA 12 Hour Days
540180 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540181 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540182 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540183 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540187 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540189 Peri-Operative Concord CALIFORNIA 8 Hour Days
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
540191 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540192 OR Concord CALIFORNIA 12 Hour Days
540194 Case Manager Concord CALIFORNIA 8 Hour Days
540195 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540196 Histology Technician Walnut Creek CALIFORNIA 8 Hour Nights
540197 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540198 ER Concord CALIFORNIA 12 Hour Days
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
540204 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
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
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
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.5135 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 asc limit 400,100 in 1.2381 seconds