Listing all records

Displaying records 2201 through 2300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545411 RAD Tech Rockville MARYLAND 8 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
545414 OT Rehab San Angelo TEXAS 8 Hour Day/Night Rotate
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
545421 RN Columbus OHIO 12 Hour Nights
545422 ER Springfield MASSACHUSETTS 8 Hour Nights
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
545424 Med Surg Waterbury CONNECTICUT 12 Hour Days
545425 L&D Mishawaka INDIANA 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
545427 NICU Mishawaka INDIANA 12 Hour Nights
545440 OT Rehab thermopolis WYOMING Days
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
545453 ER Lynwood CALIFORNIA 12 Hour Nights
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
545486 RAD Tech Florence SOUTH CAROLINA 8 Hour Days
547904 ICU Mesa ARIZONA 12 Hour Nights
545489 MRI Tech Farmington CONNECTICUT 8 Hour Evenings
545490 CT Tech Farmington CONNECTICUT 8 Hour Nights
545498 Respiratory Therapist Des Moines IOWA 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
545500 Med Surg Tele Des Moines IOWA 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 12 Hour Days
545502 Telemetry Boise IDAHO 12 Hour Nights
545503 Telemetry Boise IDAHO 12 Hour Nights
545514 L&D Arcata CALIFORNIA 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
545526 Med Surg Memphis TENNESSEE 12 Hour Days
547141 RAD Tech Farmington CONNECTICUT 8 Hour Nights
545532 CT Tech Montrose COLORADO 12 Hour Varied
545533 CT Tech Montrose COLORADO 12 Hour Varied
545539 Interventional Radiology Tech Columbia SOUTH CAROLINA 8 Hour Days
545541 RAD Tech Columbus OHIO 8 Hour Nights
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
545552 PT Wilton CONNECTICUT Varied
545553 Outpatient Clinic Greencastle INDIANA 10 Hour Days
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
545564 RAD Tech Peoria ILLINOIS 8 Hour Days
545565 Therapy Rehab Springfield MISSOURI 8 Hour Days
545566 Therapy Rehab Springfield MISSOURI 8 Hour Days
545790 MRI Tech Gainesville FLORIDA 8 Hour Evenings
545791 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545792 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545793 ICU Gainesville FLORIDA 12 Hour Nights
545795 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545796 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545797 Med Surg Gainesville FLORIDA 12 Hour Days
545798 Med Surg Gainesville FLORIDA 12 Hour Days
545799 Med Surg Gainesville FLORIDA 12 Hour Days
545800 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545801 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545802 Med Surg Gainesville FLORIDA 12 Hour Nights
545804 Med Surg Gainesville FLORIDA 12 Hour Days
545805 Med Surg Gainesville FLORIDA 12 Hour Nights
545806 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545807 Med Surg Gainesville FLORIDA 12 Hour Days
545808 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545809 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545810 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545811 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545812 ICU Gainesville FLORIDA 12 Hour Nights
545813 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545814 Med Surg Gainesville FLORIDA 12 Hour Days
545815 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545816 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545817 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545818 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545819 Med Surg Gainesville FLORIDA 12 Hour Nights
545821 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545822 Med Surg Gainesville FLORIDA 12 Hour Days
545823 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545824 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545825 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545826 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545827 Med Surg Gainesville FLORIDA 12 Hour Nights
545828 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545829 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545830 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545831 ICU Gainesville FLORIDA 12 Hour Days
545832 ICU Gainesville FLORIDA 12 Hour Nights
545833 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545834 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545835 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545836 ICU Gainesville FLORIDA 12 Hour Nights
545837 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545838 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545839 ICU Gainesville FLORIDA 12 Hour Nights
545840 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545841 Med Surg Gainesville FLORIDA 12 Hour Days
545842 ICU Gainesville FLORIDA 12 Hour Nights
545843 ICU Gainesville FLORIDA 12 Hour Days
545844 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545845 Med Surg Gainesville FLORIDA 12 Hour Nights
545846 Med Surg Gainesville FLORIDA 12 Hour Nights
545847 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545848 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545849 Med Surg 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 1.4447 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.title desc limit 2200,100 in 1.4675 seconds