Listing all records

Displaying records 2301 through 2400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540187 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
540192 OR Concord CALIFORNIA 12 Hour Days
540195 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540198 ER Concord CALIFORNIA 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
540212 Intermediate Care Concord CALIFORNIA 12 Hour Days
540213 ER Concord CALIFORNIA 12 Hour Days
540217 Med Surg Walnut Creek CALIFORNIA 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
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
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
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
546697 Surgical Tech Reno NEVADA 12 Hour Days
544204 Med Surg Sioux City IOWA 12 Hour Days
544218 CVOR Newark NEW JERSEY 12 Hour Days
544219 Oncology Newark NEW JERSEY 12 Hour Days
544221 OR Newark NEW JERSEY 12 Hour Days
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
544231 ER Denville NEW JERSEY 12 Hour Days
544234 Surgical Tech Denville NEW JERSEY 12 Hour Days
544240 RAD Tech Reno NEVADA 12 Hour Days
544241 RAD Tech Reno NEVADA 12 Hour Days
544263 Surgical Tech Westerville OHIO 12 Hour Days
544267 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544268 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544311 Cath Lab Charleston WEST VIRGINIA 12 Hour Days
544345 Surgical Tech Ketchum IDAHO 12 Hour Days
544768 OR ODESSA TEXAS 12 Hour Days
544397 Med Surg Peoria ILLINOIS 12 Hour Days RN/Registered Nurse
547290 ER Norton VIRGINIA 12 Hour Days
544437 ER IOWA CITY IOWA 12 Hour Days
544526 Step Down Wailuku HAWAII 12 Hour Days
544527 Med Surg Tele Wailuku HAWAII 12 Hour Days
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
544644 OR Silver Spring MARYLAND 12 Hour Days
544645 OR Silver Spring MARYLAND 12 Hour Days
544646 OR Silver Spring MARYLAND 12 Hour Days
544647 OR Silver Spring MARYLAND 12 Hour Days
547595 First Assist Canton OHIO 12 Hour Days
544706 NICU Des Moines IOWA 12 Hour Days
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
544742 Med Surg Spokane WASHINGTON 12 Hour Days
544743 Med Surg Spokane WASHINGTON 12 Hour Days
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
547071 PICU Walnut Creek CALIFORNIA 12 Hour Days
544890 ER Concord CALIFORNIA 12 Hour Days
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
547070 PICU Walnut Creek CALIFORNIA 12 Hour Days
544944 PCU Johnson City TENNESSEE 12 Hour Days
544955 Telemetry Twin Falls IDAHO 12 Hour Days
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
545084 RAD Tech San Diego CALIFORNIA 12 Hour Days
545098 Long Term Care Portland OREGON 12 Hour Days
546844 Telemetry Farmington CONNECTICUT 12 Hour Days
545169 Acute Care Bronx NEW YORK 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
545173 Med Surg Brooklyn NEW YORK 12 Hour Days
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
545191 Surgical Tech New Albany OHIO 12 Hour Days
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
545279 Cardiovascular Dubuque IOWA 12 Hour Days
545284 OR El Paso TEXAS 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
546868 ER MERCED CALIFORNIA 12 Hour Days
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
545392 CT Tech Anchorage ALASKA 12 Hour Days
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
545424 Med Surg Waterbury CONNECTICUT 12 Hour Days
545425 L&D Mishawaka INDIANA 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
545498 Respiratory Therapist Des Moines IOWA 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
545500 Med Surg Tele Des Moines IOWA 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 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.6039 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 desc limit 2300,100 in 1.5052 seconds