Listing all records

Displaying records 3101 through 3200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540523 L&D Lamar COLORADO 12 Hour Nights
540619 L&D Lynwood CALIFORNIA 12 Hour Days
541037 L&D Walnut Creek CALIFORNIA 12 Hour Days
541700 L&D Eureka CALIFORNIA 12 Hour Nights
547929 L&D San Antonio TEXAS 12 Hour Nights
547946 L&D Perryville MISSOURI 12 Hour Nights
543115 L&D Westerville OHIO 12 Hour Nights
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
548141 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548151 L&D Silverdale WASHINGTON 12 Hour Days RN/Registered Nurse
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
547871 L&D Cincinnati OHIO Nights
546163 L&D Seattle WASHINGTON 12 Hour Nights
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
546684 L&D Detroit MICHIGAN 12 Hour Days
546688 L&D San Antonio TEXAS 12 Hour Nights
546713 L&D Springfield MASSACHUSETTS 8 Hour Nights
546714 L&D Springfield MASSACHUSETTS 8 Hour Nights
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
547226 L&D Brooklyn NEW YORK 12 Hour Days
547257 L&D Portland OREGON 12 Hour Nights
547954 L&D Cincinnati OHIO Days
547381 L&D Seattle WASHINGTON 12 Hour Days
547382 L&D Seattle WASHINGTON 12 Hour Days
547383 L&D Seattle WASHINGTON 12 Hour Nights
547431 L&D Pueblo COLORADO 12 Hour Nights
547531 L&D Arcata CALIFORNIA 12 Hour Nights
547624 L&D Laramie WYOMING Nights
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
547717 L&D Bronx NEW YORK 12 Hour Days
548103 L&D New York NEW YORK 12 Hour Days RN/Registered Nurse
548248 ER Keene NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
547975 ER Goldendale WASHINGTON 12 Hour Nights
548118 ER Wailuku HAWAII 12 Hour Days RN/Registered Nurse
548106 ER Cobleskill NEW YORK 12 Hour Nights RN/Registered Nurse
540072 ER Walnut Creek CALIFORNIA 12 Hour Nights
540076 ER Concord CALIFORNIA 12 Hour Nights
548132 ER Peterborough NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
540099 ER Concord CALIFORNIA 12 Hour Nights
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
540106 ER Concord CALIFORNIA 12 Hour Nights
540108 ER Concord CALIFORNIA 12 Hour Nights
540115 ER Walnut Creek CALIFORNIA 12 Hour Nights
540133 ER Concord CALIFORNIA 12 Hour Nights
540146 ER Concord CALIFORNIA 12 Hour Nights
540152 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
540155 ER Walnut Creek CALIFORNIA 12 Hour Nights
540156 ER Concord CALIFORNIA 12 Hour Days
540198 ER Concord CALIFORNIA 12 Hour Days
548003 ER Pittsfield MASSACHUSETTS 12 Hour Nights
540201 ER Concord CALIFORNIA 12 Hour Nights
540213 ER Concord CALIFORNIA 12 Hour Days
540218 ER Concord CALIFORNIA 12 Hour Nights
540223 ER Concord CALIFORNIA 12 Hour Days
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
540256 ER Concord CALIFORNIA 12 Hour Days
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
543824 ER Lansing MICHIGAN 12 Hour Nights
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
543974 ER Newark NEW JERSEY 12 Hour Nights
548130 ER New York NEW YORK 12 Hour Nights RN/Registered Nurse
544230 ER Denville NEW JERSEY 12 Hour Nights
544231 ER Denville NEW JERSEY 12 Hour Days
544232 ER Denville NEW JERSEY 12 Hour Day/Night Rotate
548138 ER Truth or Consequences NEW MEXICO 12 Hour Days RN/Registered Nurse
548167 ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
544437 ER IOWA CITY IOWA 12 Hour Days
544474 ER Hilo HAWAII 12 Hour Nights
544531 ER Des Moines IOWA 12 Hour Nights
544552 ER Newark NEW JERSEY 12 Hour Nights
544632 ER Machias MAINE 12 Hour Nights
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
544705 ER Des Moines IOWA 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
544819 ER Schenectady NEW YORK 12 Hour Nights
544852 ER San Angelo TEXAS Varied
544890 ER Concord CALIFORNIA 12 Hour Days
544908 ER Oceanside CALIFORNIA 12 Hour Nights
545058 ER Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
545079 ER Pueblo COLORADO 12 Hour Day/Night Rotate
545080 ER Pueblo COLORADO 12 Hour Nights
545092 ER Portland OREGON 12 Hour Nights
545096 ER Burbank CALIFORNIA 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
545238 ER Des Moines IOWA 12 Hour Nights
545239 ER Columbus OHIO Nights
545240 ER Grove City OHIO 12 Hour Nights
545422 ER Springfield MASSACHUSETTS 8 Hour Nights
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
545453 ER Lynwood CALIFORNIA 12 Hour Nights
547711 ER New York NEW YORK 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.6196 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 3100,100 in 1.7017 seconds