Listing all records

Displaying records 1201 through 1300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545657 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545656 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545659 Med Surg Gainesville FLORIDA 12 Hour Days
545667 Med Surg Gainesville FLORIDA 12 Hour Days
540529 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
545665 Surgical Tech Gainesville FLORIDA 12 Hour Days
545672 RAD Tech Gainesville FLORIDA 12 Hour Days
545680 Med Surg Gainesville FLORIDA 12 Hour Days
545670 Med Surg Gainesville FLORIDA 12 Hour Days
545685 Med Surg Gainesville FLORIDA 12 Hour Days
545756 Med Surg Gainesville FLORIDA 12 Hour Days
540619 L&D Lynwood CALIFORNIA 12 Hour Days
540624 Surgical Tech Columbus OHIO 12 Hour Days
543549 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545713 Med Surg Gainesville FLORIDA 12 Hour Days
540742 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540743 PCU Concord CALIFORNIA 12 Hour Days
540744 PCU Concord CALIFORNIA 12 Hour Days
540748 Med Surg Tele Prescott ARIZONA 12 Hour Days
545722 Med Surg Gainesville FLORIDA 12 Hour Days
545743 Med Surg Gainesville FLORIDA 12 Hour Days
545747 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545745 Med Surg Gainesville FLORIDA 12 Hour Days
545741 Med Surg Gainesville FLORIDA 12 Hour Days
540770 Telemetry Prescott ARIZONA 12 Hour Days
545336 Ultrasound Tech Abingdon VIRGINIA 12 Hour Days
542573 Surgical Tech Louisville KENTUCKY 12 Hour Days
545782 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545754 Med Surg Gainesville FLORIDA 12 Hour Days
545757 Med Surg Gainesville FLORIDA 12 Hour Days
545763 Surgical Tech Gainesville FLORIDA 12 Hour Days
540857 ER Springfield MASSACHUSETTS 12 Hour Days
545787 Med Surg Gainesville FLORIDA 12 Hour Days
545786 ICU Gainesville FLORIDA 12 Hour Days
540895 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545734 Med Surg Gainesville FLORIDA 12 Hour Days
545792 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545794 Intermediate Care Gainesville FLORIDA 12 Hour Days
545798 Med Surg Gainesville FLORIDA 12 Hour Days
541037 L&D Walnut Creek CALIFORNIA 12 Hour Days
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
545804 Med Surg Gainesville FLORIDA 12 Hour Days
545807 Med Surg Gainesville FLORIDA 12 Hour Days
545800 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545809 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545818 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545814 Med Surg Gainesville FLORIDA 12 Hour Days
545837 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545829 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545822 Med Surg Gainesville FLORIDA 12 Hour Days
541258 ICU Concord CALIFORNIA 12 Hour Days
542442 Med Surg Oneonta NEW YORK 12 Hour Days
545858 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545856 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545859 Med Surg Gainesville FLORIDA 12 Hour Days
544221 OR Newark NEW JERSEY 12 Hour Days
545865 Med Surg Gainesville FLORIDA 12 Hour Days
545941 Med Surg Gainesville FLORIDA 12 Hour Days
545866 Med Surg Gainesville FLORIDA 12 Hour Days
545870 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545884 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545940 Med Surg Gainesville FLORIDA 12 Hour Days
545799 Med Surg Gainesville FLORIDA 12 Hour Days
545853 Med Surg Gainesville FLORIDA 12 Hour Days
545878 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545844 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545880 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545893 Med Surg Gainesville FLORIDA 12 Hour Days
545890 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
545898 Med Surg Gainesville FLORIDA 12 Hour Days
545906 Med Surg Gainesville FLORIDA 12 Hour Days
545902 ICU Gainesville FLORIDA 12 Hour Days
545896 ICU Gainesville FLORIDA 12 Hour Days
545886 ICU Gainesville FLORIDA 12 Hour Days
545918 Med Surg Gainesville FLORIDA 12 Hour Days
545921 Med Surg Gainesville FLORIDA 12 Hour Days
545920 Med Surg Gainesville FLORIDA 12 Hour Days
545908 Med Surg Gainesville FLORIDA 12 Hour Days
545926 Med Surg Gainesville FLORIDA 12 Hour Days
545924 Med Surg Gainesville FLORIDA 12 Hour Days
545930 Med Surg Gainesville FLORIDA 12 Hour Days
545928 Med Surg Gainesville FLORIDA 12 Hour Days
545933 Med Surg Gainesville FLORIDA 12 Hour Days
541521 PCU Spokane WASHINGTON 12 Hour Days
541522 PCU Spokane WASHINGTON 12 Hour Days
545938 Med Surg Gainesville FLORIDA 12 Hour Days
541525 PCU Spokane WASHINGTON 12 Hour Days
541526 PCU Spokane WASHINGTON 12 Hour Days
541527 PCU Spokane WASHINGTON 12 Hour Days
545661 Med Surg Gainesville FLORIDA 12 Hour Days
545961 Med Surg Gainesville FLORIDA 12 Hour Days
545964 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
546057 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
545976 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545974 Med Surg Gainesville FLORIDA 12 Hour Days
543696 Oncology Bristol TENNESSEE 12 Hour Days
545988 Long Term Care King City CALIFORNIA 12 Hour Days
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
542008 CVICU Little Rock ARKANSAS 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.7353 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 1200,100 in 1.3535 seconds