Listing all records

Displaying records 2001 through 2100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545582 Step Down Cleveland OHIO 12 Hour Nights
545591 RAD Tech Richmond VIRGINIA 8 Hour Days
545592 RAD Tech Richmond VIRGINIA 8 Hour Days
545597 Med Surg Peoria ILLINOIS 12 Hour Nights
545599 RAD Tech Richmond VIRGINIA 8 Hour Days
545600 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545605 ER Peoria ILLINOIS 12 Hour Nights
545606 Interventional Radiology Tech Mission Viejo CALIFORNIA 10 Hour Days
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
545611 Cath Lab Mission Viejo CALIFORNIA 10 Hour Days
545613 EP Tech Mission Viejo CALIFORNIA 10 Hour Days
545616 Med Surg Lancaster SOUTH CAROLINA 12 Hour Nights
545617 Med Surg Gainesville FLORIDA 12 Hour Days
545618 MLT Gainesville FLORIDA 8 Hour Nights
545619 Med Surg Gainesville FLORIDA 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
545621 ER Massena NEW YORK 12 Hour Nights
545622 Cardiovascular Prescott ARIZONA 12 Hour Day/Night Rotate
545624 Surgical Tech CVOR Prescott ARIZONA 8 Hour Days
545625 Telemetry Prescott Valley ARIZONA 12 Hour Nights
545626 Telemetry Prescott Valley ARIZONA 12 Hour Day/Night Rotate
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
545628 Med Surg Gainesville FLORIDA 12 Hour Days
545629 ICU Gainesville FLORIDA 12 Hour Nights
545630 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545631 ICU Gainesville FLORIDA 12 Hour Nights
545632 Med Surg Gainesville FLORIDA 12 Hour Days
545633 Med Surg Gainesville FLORIDA 12 Hour Nights
545634 Med Surg Gainesville FLORIDA 12 Hour Days
545635 Med Surg Gainesville FLORIDA 12 Hour Nights
545636 ICU Gainesville FLORIDA 12 Hour Nights
545637 ICU Gainesville FLORIDA 12 Hour Nights
545638 Med Surg Gainesville FLORIDA 12 Hour Days
545639 ICU Gainesville FLORIDA 12 Hour Nights
545640 EEG Tech Gainesville FLORIDA 10 Hour Days
545641 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545642 Med Surg Gainesville FLORIDA 12 Hour Nights
545643 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545644 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545646 Med Surg Gainesville FLORIDA 12 Hour Days
545647 Med Surg Gainesville FLORIDA 12 Hour Days
545648 RAD Tech Gainesville FLORIDA 12 Hour Nights
545649 RAD Tech Gainesville FLORIDA 12 Hour Nights
545650 RAD Tech Gainesville FLORIDA 10 Hour Nights
545651 RAD Tech Gainesville FLORIDA 10 Hour Nights
545652 Med Surg Gainesville FLORIDA 12 Hour Nights
545653 Med Surg Gainesville FLORIDA 12 Hour Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
545655 Med Surg Gainesville FLORIDA 12 Hour Nights
545656 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545657 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545658 Med Surg Gainesville FLORIDA 12 Hour Days
545659 Med Surg Gainesville FLORIDA 12 Hour Days
545660 Med Surg Gainesville FLORIDA 12 Hour Days
545661 Med Surg Gainesville FLORIDA 12 Hour Days
545662 MLT Gainesville FLORIDA 12 Hour Nights
545663 MLT Gainesville FLORIDA 12 Hour Nights
545664 MLT Gainesville FLORIDA 8 Hour Days
545665 Surgical Tech Gainesville FLORIDA 12 Hour Days
545666 Surgical Tech CVOR Gainesville FLORIDA 12 Hour Days
545667 Med Surg Gainesville FLORIDA 12 Hour Days
545668 MLT Gainesville FLORIDA 8 Hour Days
545669 Case Manager Gainesville FLORIDA 10 Hour Days
545670 Med Surg Gainesville FLORIDA 12 Hour Days
545671 Cardiology Gainesville FLORIDA 12 Hour Nights
545672 RAD Tech Gainesville FLORIDA 12 Hour Days
545673 Med Surg Gainesville FLORIDA 12 Hour Nights
545674 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545675 ICU Gainesville FLORIDA 12 Hour Nights
545676 Med Surg Gainesville FLORIDA 12 Hour Nights
545677 Med Surg Gainesville FLORIDA 12 Hour Nights
545678 ICU Gainesville FLORIDA 12 Hour Days
545679 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545680 Med Surg Gainesville FLORIDA 12 Hour Days
545681 Med Surg Gainesville FLORIDA 12 Hour Nights
545682 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545683 Med Surg Gainesville FLORIDA 12 Hour Nights
545684 PACU Gainesville FLORIDA 12 Hour Days
545685 Med Surg Gainesville FLORIDA 12 Hour Days
545686 Med Surg Gainesville FLORIDA 12 Hour Nights
545687 ICU Gainesville FLORIDA 12 Hour Nights
545688 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545689 ICU Gainesville FLORIDA 12 Hour Nights
545690 Med Surg Gainesville FLORIDA 12 Hour Days
545691 RAD Tech Gainesville FLORIDA 10 Hour Days
545692 PICU Gainesville FLORIDA 12 Hour Nights
545693 ICU Gainesville FLORIDA 12 Hour Nights
545694 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545695 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545696 Ultrasound Tech Gainesville FLORIDA 8 Hour Days
545697 Med Surg Gainesville FLORIDA 12 Hour Days
545698 Med Surg Gainesville FLORIDA 12 Hour Days
545699 Med Surg Gainesville FLORIDA 12 Hour Nights
545700 Ultrasound Tech Gainesville FLORIDA 10 Hour Days
545701 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545702 Med Surg Gainesville FLORIDA 12 Hour Days
545703 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545704 Med Surg Gainesville FLORIDA 12 Hour Days
545705 RRT- Respiratory Gainesville FLORIDA 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 2.0347 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.id asc limit 2000,100 in 1.1908 seconds