Listing all records

Displaying records 1001 through 1100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
540111 Med Surg Tele Concord CALIFORNIA 12 Hour Days
546128 Certified Surgical Tech Florence SOUTH CAROLINA 12 Hour Days
546129 Med Surg Portland OREGON 12 Hour Days
540114 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
546127 Med Surg Oxford NORTH CAROLINA 12 Hour Days
546142 Cardiology Muskegon MICHIGAN 12 Hour Days
546141 Med Surg Des Moines IOWA 12 Hour Days
540120 ICU Walnut Creek CALIFORNIA 12 Hour Days
540122 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
546251 CNA TOWNSHEND VERMONT 12 Hour Days
540125 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540128 ICU Walnut Creek CALIFORNIA 12 Hour Days
540130 Med Surg Tele Concord CALIFORNIA 12 Hour Days
542523 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
546317 CT Tech ODESSA TEXAS 12 Hour Days
546331 ER Centerville IOWA 12 Hour Days
540138 NICU Walnut Creek CALIFORNIA 12 Hour Days
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
540140 L&D Walnut Creek CALIFORNIA 12 Hour Days
540141 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540142 Intermediate Care Concord CALIFORNIA 12 Hour Days
540144 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540145 L&D Walnut Creek CALIFORNIA 12 Hour Days
540147 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540149 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540150 Telemetry Concord CALIFORNIA 12 Hour Days
543296 OR Albuquerque NEW MEXICO 12 Hour Days
540153 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540156 ER Concord CALIFORNIA 12 Hour Days
540160 Med Surg Concord CALIFORNIA 12 Hour Days
540161 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540162 PACU Walnut Creek CALIFORNIA 12 Hour Days
546432 Telemetry Farmington CONNECTICUT 12 Hour Days
540166 NICU Walnut Creek CALIFORNIA 12 Hour Days
546412 Med Surg Springfield VERMONT 12 Hour Days
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
540169 L&D Walnut Creek CALIFORNIA 12 Hour Days
546448 Nuclear Med Technician Santa Monica CALIFORNIA 12 Hour Days
546461 ER Des Moines IOWA 12 Hour Days
546554 Dialysis Brooklyn NEW YORK 12 Hour Days
546462 ER Des Moines IOWA 12 Hour Days
540176 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
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
546568 NICU Brooklyn NEW YORK 12 Hour Days
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
546566 ICU Brooklyn NEW YORK 12 Hour Days
540187 Med Surg Tele Concord CALIFORNIA 12 Hour Days
546574 MICU Brooklyn NEW YORK 12 Hour Days
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
546576 MICU Brooklyn NEW YORK 12 Hour Days
540192 OR Concord CALIFORNIA 12 Hour Days
540195 Med Surg Tele Concord CALIFORNIA 12 Hour Days
546602 CT Tech Minneapolis MINNESOTA 12 Hour Days
540198 ER Concord CALIFORNIA 12 Hour Days
546608 Med Surg Spokane WASHINGTON 12 Hour Days
546624 ER Saratoga Springs NEW YORK 12 Hour Days
546625 ER Saratoga Springs NEW YORK 12 Hour Days
546623 ER Saratoga Springs NEW YORK 12 Hour Days
540205 Med Surg Tele Concord CALIFORNIA 12 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
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
540212 Intermediate Care Concord CALIFORNIA 12 Hour Days
540213 ER Concord CALIFORNIA 12 Hour Days
540217 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
546687 PCU San Luis Obispo CALIFORNIA 12 Hour Days
546684 L&D Detroit MICHIGAN 12 Hour Days
540221 PICU Walnut Creek CALIFORNIA 12 Hour Days
540222 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540223 ER Concord CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
546699 Med Surg Spokane WASHINGTON 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
540230 ICU Walnut Creek CALIFORNIA 12 Hour Days
540231 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540233 PICU Walnut Creek CALIFORNIA 12 Hour Days
540235 ICU Concord CALIFORNIA 12 Hour Days
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
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
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
546801 PICU Walnut Creek CALIFORNIA 12 Hour Days
540244 ICU Concord CALIFORNIA 12 Hour Days
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
540254 NICU Walnut Creek CALIFORNIA 12 Hour Days
540256 ER 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.4775 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 1000,100 in 1.3815 seconds