Listing all records

Displaying records 3001 through 3100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546141 Med Surg Des Moines IOWA 12 Hour Days
548371 Med Surg Coos Bay OREGON 12 Hour Nights RN/Registered Nurse
546196 Med Surg Bristol TENNESSEE 12 Hour Nights
546198 Med Surg Bristol TENNESSEE 12 Hour Days
548096 Med Surg Espanola NEW MEXICO 12 Hour Nights RN/Registered Nurse
546405 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
546412 Med Surg Springfield VERMONT 12 Hour Days
546431 Med Surg Gainesville FLORIDA 12 Hour Days
546455 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
546464 Med Surg Bristol TENNESSEE 12 Hour Nights
546466 Med Surg Greeneville TENNESSEE 12 Hour Nights
546476 Med Surg Gainesville FLORIDA 12 Hour Nights
548110 Med Surg Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
546569 Med Surg Brooklyn NEW YORK 12 Hour Nights
546572 Med Surg Brooklyn NEW YORK 12 Hour Nights
546590 Med Surg Brooklyn NEW YORK 12 Hour Days
546597 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
546608 Med Surg Spokane WASHINGTON 12 Hour Days
548121 Med Surg Kula HAWAII 12 Hour Nights RN/Registered Nurse
546692 Med Surg Oceanside CALIFORNIA 12 Hour Days
546699 Med Surg Spokane WASHINGTON 12 Hour Days
546705 Med Surg Albany NEW YORK 12 Hour Nights
546706 Med Surg Albany NEW YORK 12 Hour Nights
546707 Med Surg Albany NEW YORK 12 Hour Nights
547953 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
546722 Med Surg Olympia WASHINGTON 12 Hour Nights
546750 Med Surg Charlottesville VIRGINIA 12 Hour Nights
546768 Med Surg IOWA CITY IOWA 12 Hour Nights
546785 Med Surg IOWA CITY IOWA 12 Hour Day/Night Rotate
546812 Med Surg Harrison ARKANSAS 12 Hour Nights
546833 Med Surg Ogdensburg NEW YORK 12 Hour Nights
546845 Med Surg Peoria ILLINOIS 12 Hour Nights
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
548156 Med Surg Weirton WEST VIRGINIA 12 Hour Days RN/Registered Nurse
547907 Med Surg New York NEW YORK Nights
546915 Med Surg Hilo HAWAII 12 Hour Nights
548160 Med Surg Prince Frederick MARYLAND 12 Hour Nights RN/Registered Nurse
548159 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
546993 Med Surg Troy NEW YORK 12 Hour Nights
546994 Med Surg Troy NEW YORK 12 Hour Nights
547000 Med Surg Dubuque IOWA 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
547065 Med Surg Grand Forks NORTH DAKOTA Days
547046 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
547127 Med Surg Coos Bay OREGON 12 Hour Nights
547086 Med Surg Pendleton OREGON 12 Hour Nights
547087 Med Surg Pendleton OREGON 12 Hour Nights
547089 Med Surg Portland OREGON 12 Hour Nights
547122 Med Surg Des Moines IOWA 12 Hour Nights
547123 Med Surg Des Moines IOWA 12 Hour Nights
547185 Med Surg Brooklyn NEW YORK 12 Hour Days
547186 Med Surg Brooklyn NEW YORK 12 Hour Days
547187 Med Surg Brooklyn NEW YORK 8 Hour Nights
547188 Med Surg Brooklyn NEW YORK 12 Hour Days
547274 Med Surg Glens Falls NEW YORK 12 Hour Nights
548188 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
547316 Med Surg Boise IDAHO 12 Hour Nights
547385 Med Surg Missoula MONTANA 12 Hour Nights
547386 Med Surg Seattle WASHINGTON 12 Hour Nights
547422 Med Surg Bronx NEW YORK Days
547444 Med Surg Bloomington INDIANA 12 Hour Nights
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547765 Med Surg Sun City West ARIZONA 12 Hour Nights
547469 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
547471 Med Surg Prince Frederick MARYLAND 12 Hour Nights
547494 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547500 Med Surg Chillicothe OHIO 12 Hour Nights
547512 Med Surg Coos Bay OREGON 12 Hour Nights
547526 Med Surg Parkersburg WEST VIRGINIA 12 Hour Nights
547573 Med Surg Chillicothe OHIO 12 Hour Days
547574 Med Surg Lewiston MAINE 12 Hour Days
547982 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
540021 L&D Walnut Creek CALIFORNIA 12 Hour Days
540023 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540030 L&D Walnut Creek CALIFORNIA 12 Hour Days
540036 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540037 L&D Walnut Creek CALIFORNIA 12 Hour Nights
547871 L&D Cincinnati OHIO Nights
540103 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540140 L&D Walnut Creek CALIFORNIA 12 Hour Days
540145 L&D Walnut Creek CALIFORNIA 12 Hour Days
540169 L&D Walnut Creek CALIFORNIA 12 Hour Days
540172 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
540199 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540247 L&D Walnut Creek CALIFORNIA 12 Hour Days
543439 L&D Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
543695 L&D WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
544344 L&D Ketchum IDAHO 12 Hour Nights
545380 L&D Lewistown MONTANA Nights
545425 L&D Mishawaka INDIANA 12 Hour Days
545514 L&D Arcata CALIFORNIA 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
548187 L&D Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
547381 L&D Seattle WASHINGTON 12 Hour Days
547431 L&D Pueblo COLORADO 12 Hour Nights
547531 L&D Arcata 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.5714 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.specialty desc limit 3000,100 in 1.5743 seconds