Listing all records

Displaying records 2801 through 2900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546402 CT Tech Mount Airy NORTH CAROLINA 8 Hour Nights
546403 CT Tech Mount Airy NORTH CAROLINA 12 Hour Nights
546405 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
546609 EP Tech Pinehurst NORTH CAROLINA 10 Hour Days
546874 Med Surg Tele Greensboro NORTH CAROLINA 12 Hour Nights
546897 Cath Lab New Bern NORTH CAROLINA 8 Hour Days
547045 Cath Lab New Bern NORTH CAROLINA 10 Hour Days
547046 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
547099 PT Laurinburg NORTH CAROLINA 8 Hour Days
547323 Med Surg Tele Raeford NORTH CAROLINA 12 Hour Nights
547474 LTAC Fayetteville NORTH CAROLINA 12 Hour Nights
547475 LTAC Fayetteville NORTH CAROLINA 12 Hour Days
547482 CT Tech Rockingham NORTH CAROLINA 12 Hour Nights
547552 Interventional Radiology Tech Winston-Salem NORTH CAROLINA 8 Hour Days
547604 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
547605 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
547680 Long Term Care Brantwood NORTH CAROLINA 12 Hour Nights
547820 OR Laurinburg NORTH CAROLINA 8 Hour Days
547894 Med Surg Oxford NORTH CAROLINA 12 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544422 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544502 Interventional Radiology Tech Fayetteville NORTH CAROLINA 10 Hour Days
544518 PCU Fayetteville NORTH CAROLINA 12 Hour Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544658 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544667 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
545133 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
546127 Med Surg Oxford NORTH CAROLINA 12 Hour Days
540451 Surgical Tech CVOR Pinehurst NORTH CAROLINA 10 Hour Days
541403 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
542856 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
542858 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
542877 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
543747 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
548036 MLT New Bern NORTH CAROLINA 10 Hour Nights
548037 OR Laurinburg NORTH CAROLINA 8 Hour Days
548221 Social Worker Greensboro NORTH CAROLINA 8 Hour Days Social Worker
548235 ER Greensboro NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
506863 Surgical Tech Durham NORTH CAROLINA 10 Hour Days
512894 MLT Hickory NORTH CAROLINA 12 Hour Days
513169 Phlebotomist Hickory NORTH CAROLINA 12 Hour Nights
513688 Certified Surgical Tech Hickory NORTH CAROLINA 8 Hour Days
515218 Sterile Processing Technician Hickory NORTH CAROLINA 12 Hour Nights
525839 RAD Tech Wilmington NORTH CAROLINA 12 Hour Days Radiology Techs/Technologists
527593 PT Pinehurst NORTH CAROLINA 8 Hour Days
528615 SLP Salisbury NORTH CAROLINA Days
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
538047 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
541782 ICU Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
543590 L&D Devils Lake NORTH DAKOTA 12 Hour Day/Night Rotate
527927 PT Mandan NORTH DAKOTA 8 Hour Day/Night Rotate
535143 OT Rehab Devils Lake NORTH DAKOTA 8 Hour Days
545463 Vascular Ultrasound Tech Hettinger NORTH DAKOTA 8 Hour Days
537785 SLP Fargo NORTH DAKOTA Days
541271 PCU Bismarck NORTH DAKOTA Nights
541283 Surgical Tech CVOR Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
541391 RAD Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
542636 Oncology Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
543439 L&D Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
543454 Home Health Fargo NORTH DAKOTA 8 Hour Day/Night Rotate
543695 L&D WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
547065 Med Surg Grand Forks NORTH DAKOTA Days
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547495 Respiratory Therapist WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547583 Dialysis WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547794 Pediatrics Valley City NORTH DAKOTA Nights
547816 Angiography Grand Forks NORTH DAKOTA Days
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
545058 ER Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
545149 Med Surg Hettinger NORTH DAKOTA 12 Hour Day/Night Rotate
545954 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545955 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
546049 RAD Tech Bismarck NORTH DAKOTA 8 Hour Nights
546050 Pediatrics Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
544158 PACU Cleveland OHIO 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
544208 Med Surg Grove City OHIO 12 Hour Nights
544209 Med Surg Grove City OHIO 12 Hour Nights
544263 Surgical Tech Westerville OHIO 12 Hour Days
544312 BMT Cleveland OHIO 12 Hour Day/Night Rotate
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
544316 Cath Lab Willoughby OHIO 10 Hour Days
544403 First Assist Lancaster OHIO Days
544572 Step Down Willoughby OHIO 12 Hour Nights
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544626 Echo Toledo OHIO 8 Hour Days
544627 Med Surg Tele Akron OHIO 12 Hour Nights
544628 Psych Cleveland OHIO 12 Hour Nights
547595 First Assist Canton OHIO 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.32 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 y.name asc limit 2800,100 in 1.2967 seconds