Listing all records

Displaying records 801 through 900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545777 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545786 ICU Gainesville FLORIDA 12 Hour Days
545782 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545787 Med Surg Gainesville FLORIDA 12 Hour Days
540271 Med Surg Concord CALIFORNIA 12 Hour Days
545816 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
535030 Surgical Tech Louisville KENTUCKY 12 Hour Days
545794 Intermediate Care Gainesville FLORIDA 12 Hour Days
540265 Med Surg Concord CALIFORNIA 12 Hour Days
545757 Med Surg Gainesville FLORIDA 12 Hour Days
535099 Radiology Bronx NEW YORK 12 Hour Days
540156 ER Concord CALIFORNIA 12 Hour Days
545804 Med Surg Gainesville FLORIDA 12 Hour Days
535179 CT Tech Columbus OHIO 12 Hour Days
545829 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545811 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545818 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545837 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545798 Med Surg Gainesville FLORIDA 12 Hour Days
545844 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545831 ICU Gainesville FLORIDA 12 Hour Days
535418 Respiratory Therapist Mason City IOWA 12 Hour Days
545841 Med Surg Gainesville FLORIDA 12 Hour Days
545854 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545792 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545858 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545853 Med Surg Gainesville FLORIDA 12 Hour Days
540295 ER Walnut Creek CALIFORNIA 12 Hour Days
545284 OR El Paso TEXAS 12 Hour Days
540340 ICU Walnut Creek CALIFORNIA 12 Hour Days
545279 Cardiovascular Dubuque IOWA 12 Hour Days
540038 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540039 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540040 Telemetry Farmington CONNECTICUT 12 Hour Days
540041 Ultrasound Tech Farmington CONNECTICUT 12 Hour Days
540042 ICU Concord CALIFORNIA 12 Hour Days
540343 ICU Walnut Creek CALIFORNIA 12 Hour Days
540342 Telemetry Concord CALIFORNIA 12 Hour Days
540047 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540048 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545392 CT Tech Anchorage ALASKA 12 Hour Days
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
540058 OR Walnut Creek CALIFORNIA 12 Hour Days
545617 Med Surg Gainesville FLORIDA 12 Hour Days
540347 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545710 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540065 Telemetry Farmington CONNECTICUT 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
545498 Respiratory Therapist Des Moines IOWA 12 Hour Days
540068 NICU Walnut Creek CALIFORNIA 12 Hour Days
540069 NICU Walnut Creek CALIFORNIA 12 Hour Days
540304 L&D Walnut Creek CALIFORNIA 12 Hour Days
540071 PACU Concord CALIFORNIA 12 Hour Days
540073 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 12 Hour Days
540077 OR Walnut Creek CALIFORNIA 12 Hour Days
540078 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540080 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545638 Med Surg Gainesville FLORIDA 12 Hour Days
540084 OR Walnut Creek CALIFORNIA 12 Hour Days
545634 Med Surg Gainesville FLORIDA 12 Hour Days
540088 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540089 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545657 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545656 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545659 Med Surg Gainesville FLORIDA 12 Hour Days
545658 Med Surg Gainesville FLORIDA 12 Hour Days
540094 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540095 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540096 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545667 Med Surg Gainesville FLORIDA 12 Hour Days
545672 RAD Tech Gainesville FLORIDA 12 Hour Days
545684 PACU Gainesville FLORIDA 12 Hour Days
545680 Med Surg Gainesville FLORIDA 12 Hour Days
545670 Med Surg Gainesville FLORIDA 12 Hour Days
545666 Surgical Tech CVOR Gainesville FLORIDA 12 Hour Days
545690 Med Surg Gainesville FLORIDA 12 Hour Days
545697 Med Surg Gainesville FLORIDA 12 Hour Days
545704 Med Surg Gainesville FLORIDA 12 Hour Days
540109 OR Walnut Creek CALIFORNIA 12 Hour Days
545698 Med Surg Gainesville FLORIDA 12 Hour Days
540111 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545715 Med Surg Gainesville FLORIDA 12 Hour Days
540114 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545713 Med Surg Gainesville FLORIDA 12 Hour Days
545721 Med Surg Gainesville FLORIDA 12 Hour Days
545734 Med Surg Gainesville FLORIDA 12 Hour Days
545725 Med Surg Gainesville FLORIDA 12 Hour Days
545719 Med Surg Gainesville FLORIDA 12 Hour Days
540120 ICU Walnut Creek CALIFORNIA 12 Hour Days
545743 Med Surg Gainesville FLORIDA 12 Hour Days
540122 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545735 Med Surg Gainesville FLORIDA 12 Hour Days
545747 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540125 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545746 Med Surg Gainesville FLORIDA 12 Hour Days
540128 ICU Walnut Creek CALIFORNIA 12 Hour Days
540130 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545795 RRT- Respiratory Gainesville FLORIDA 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.6854 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 800,100 in 1.6276 seconds