Listing all records

Displaying records 601 through 700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546688 L&D San Antonio TEXAS 12 Hour Nights
540299 L&D Walnut Creek CALIFORNIA 12 Hour Days
545425 L&D Mishawaka INDIANA 12 Hour Days
540145 L&D Walnut Creek CALIFORNIA 12 Hour Days
540304 L&D Walnut Creek CALIFORNIA 12 Hour Days
540037 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540036 L&D Walnut Creek CALIFORNIA 12 Hour Nights
544344 L&D Ketchum IDAHO 12 Hour Nights
540307 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540523 L&D Lamar COLORADO 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
546714 L&D Springfield MASSACHUSETTS 8 Hour Nights
543439 L&D Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
540103 L&D Walnut Creek CALIFORNIA 12 Hour Nights
543695 L&D WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
547257 L&D Portland OREGON 12 Hour Nights
546163 L&D Seattle WASHINGTON 12 Hour Nights
545380 L&D Lewistown MONTANA Nights
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
547383 L&D Seattle WASHINGTON 12 Hour Nights
547382 L&D Seattle WASHINGTON 12 Hour Days
547226 L&D Brooklyn NEW YORK 12 Hour Days
537792 L&D Ogdensburg NEW YORK 12 Hour Nights
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
547531 L&D Arcata CALIFORNIA 12 Hour Nights
540140 L&D Walnut Creek CALIFORNIA 12 Hour Days
548187 L&D Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
540030 L&D Walnut Creek CALIFORNIA 12 Hour Days
546759 L&D Auburn NEW YORK 12 Hour Nights
539754 L&D Wailuku HAWAII 8 Hour Nights
547929 L&D San Antonio TEXAS 12 Hour Nights
541700 L&D Eureka CALIFORNIA 12 Hour Nights
541037 L&D Walnut Creek CALIFORNIA 12 Hour Days
547954 L&D Cincinnati OHIO Days
548129 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
545632 Med Surg Gainesville FLORIDA 12 Hour Days
545658 Med Surg Gainesville FLORIDA 12 Hour Days
545638 Med Surg Gainesville FLORIDA 12 Hour Days
540073 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545634 Med Surg Gainesville FLORIDA 12 Hour Days
545757 Med Surg Gainesville FLORIDA 12 Hour Days
545652 Med Surg Gainesville FLORIDA 12 Hour Nights
545936 Med Surg Gainesville FLORIDA 12 Hour Nights
542029 Med Surg Bronx NEW YORK 10 Hour Days
540170 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
543593 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
545646 Med Surg Gainesville FLORIDA 12 Hour Days
545635 Med Surg Gainesville FLORIDA 12 Hour Nights
541949 Med Surg Boise IDAHO 12 Hour Nights
542491 Med Surg Brooklyn NEW YORK 12 Hour Nights
545787 Med Surg Gainesville FLORIDA 12 Hour Days
545789 Med Surg Gainesville FLORIDA 12 Hour Nights
545660 Med Surg Gainesville FLORIDA 12 Hour Days
544209 Med Surg Grove City OHIO 12 Hour Nights
545841 Med Surg Gainesville FLORIDA 12 Hour Days
545935 Med Surg Gainesville FLORIDA 12 Hour Nights
541734 Med Surg Brooklyn NEW YORK 12 Hour Evenings
544153 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
545756 Med Surg Gainesville FLORIDA 12 Hour Days
525646 Med Surg Boise IDAHO 12 Hour Nights
545642 Med Surg Gainesville FLORIDA 12 Hour Nights
540742 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
539450 Med Surg New York NEW YORK 8 Hour Evenings
545661 Med Surg Gainesville FLORIDA 12 Hour Days
540090 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
542773 Med Surg Kingsport TENNESSEE 12 Hour Nights
545670 Med Surg Gainesville FLORIDA 12 Hour Days
545899 Med Surg Gainesville FLORIDA 12 Hour Days
545659 Med Surg Gainesville FLORIDA 12 Hour Days
544354 Med Surg Meridian IDAHO 12 Hour Nights
545754 Med Surg Gainesville FLORIDA 12 Hour Days
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
540582 Med Surg Des Moines IOWA 12 Hour Nights
545903 Med Surg Gainesville FLORIDA 12 Hour Nights
545933 Med Surg Gainesville FLORIDA 12 Hour Days
545633 Med Surg Gainesville FLORIDA 12 Hour Nights
545667 Med Surg Gainesville FLORIDA 12 Hour Days
545767 Med Surg Gainesville FLORIDA 12 Hour Nights
545779 Med Surg Gainesville FLORIDA 12 Hour Days
545784 Med Surg Gainesville FLORIDA 12 Hour Nights
545785 Med Surg Gainesville FLORIDA 12 Hour Nights
545653 Med Surg Gainesville FLORIDA 12 Hour Nights
545647 Med Surg Gainesville FLORIDA 12 Hour Days
534941 Med Surg Cape Girardeau MISSOURI Nights
534942 Med Surg Cape Girardeau MISSOURI Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
545655 Med Surg Gainesville FLORIDA 12 Hour Nights
545758 Med Surg Gainesville FLORIDA 12 Hour Nights
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
543186 Med Surg Oneonta NEW YORK 12 Hour Days
540122 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545775 Med Surg Gainesville FLORIDA 12 Hour Days
545673 Med Surg Gainesville FLORIDA 12 Hour Nights
540044 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
545904 Med Surg Gainesville FLORIDA 12 Hour Nights
541076 Med Surg Des Moines IOWA 12 Hour Nights
540753 Med Surg Boise IDAHO 12 Hour Nights
546182 Med Surg Peoria ILLINOIS 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.635 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 asc limit 600,100 in 1.5521 seconds