Listing all records

Displaying records 2101 through 2200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548052 Med Surg Pontiac MICHIGAN 12 Hour Nights RN/Registered Nurse
548072 ER Lansing MICHIGAN 12 Hour Days RN/Registered Nurse
548315 Surgical Tech Detroit MICHIGAN 8 Hour Days Tech/Technologist
548317 ST Muskegon MICHIGAN 12 Hour Days Tech/Technologist
548318 Surgical Tech Bad Axe MICHIGAN 8 Hour Days Tech/Technologist
548334 CVICU Petoskey MICHIGAN 12 Hour Nights RN/Registered Nurse
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
544937 Med Surg Detroit MICHIGAN 12 Hour Nights
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
546142 Cardiology Muskegon MICHIGAN 12 Hour Days
546143 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
546144 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546145 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546146 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546147 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546177 Medical Assistant West Branch MICHIGAN 8 Hour Days
540599 Interventional Radiology Tech Pontiac MICHIGAN 8 Hour Days
541191 Echo Ann Arbor MICHIGAN 8 Hour Days
543078 Surgical Tech CVOR Ann Arbor MICHIGAN 12 Hour Days
543201 Psych Grand Rapids MICHIGAN 8 Hour Evenings RN/Registered Nurse
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
543527 Step Down Lansing MICHIGAN Nights
543703 RAD Tech Commerce Twp MICHIGAN 8 Hour Nights
543787 PICU Detroit MICHIGAN 12 Hour Days
543824 ER Lansing MICHIGAN 12 Hour Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
544037 Step Down Lansing MICHIGAN 12 Hour Nights
544060 ICU Pontiac MICHIGAN 12 Hour Nights
546223 ICU Ann Arbor MICHIGAN 12 Hour Nights
546224 CCU Ann Arbor MICHIGAN 12 Hour Nights
546348 Cardiac ICU Detroit MICHIGAN 12 Hour Nights
546349 Interventional Radiology Detroit MICHIGAN 8 Hour Days
546382 Step Down Lansing MICHIGAN 12 Hour Nights
546392 Sterile Processing Tech Muskegon MICHIGAN Nights
546637 Sterile Processing Tech Muskegon MICHIGAN Nights
546684 L&D Detroit MICHIGAN 12 Hour Days
546711 OR Muskegon MICHIGAN 10 Hour Days
546757 OR Petoskey MICHIGAN 10 Hour Days
546923 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
546924 Cath Lab Detroit MICHIGAN 8 Hour Days
547666 PT Bad Axe MICHIGAN 8 Hour Days
547061 Sterile Processing Tech Muskegon MICHIGAN Nights
547062 Sterile Processing Tech Muskegon MICHIGAN Nights
547245 Ultrasound Tech Detroit MICHIGAN 8 Hour Days
547247 Surgical Tech Detroit MICHIGAN 8 Hour Days
547276 Sterile Processing Tech Muskegon MICHIGAN Nights
547279 ER Muskegon MICHIGAN 12 Hour Nights
547280 ER Muskegon MICHIGAN 12 Hour Nights
547281 ICU Muskegon MICHIGAN 12 Hour Nights
547282 ICU Muskegon MICHIGAN 12 Hour Nights
547326 CVOR Ann Arbor MICHIGAN 10 Hour Days
547568 CCU Marshall MICHIGAN 12 Hour Nights
547638 Med Surg Tele Lansing MICHIGAN 12 Hour Nights
547681 Radiation Therapy Flint MICHIGAN 10 Hour Days
547779 MLT Detroit MICHIGAN 8 Hour Evenings
547799 RAD Tech Pontiac MICHIGAN 8 Hour Nights
547800 RAD Tech Pontiac MICHIGAN 8 Hour Nights
547876 RAD Tech Pontiac MICHIGAN 8 Hour Evenings
548249 Med Surg Pontiac MICHIGAN 12 Hour Days RN/Registered Nurse
548250 CST Pontiac MICHIGAN 8 Hour Days CST/Certified Surgical Technician
547921 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
547922 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
524703 CT Tech Pontiac MICHIGAN 8 Hour Nights
531502 Surgical Tech Muskegon MICHIGAN 12 Hour Nights
531702 OR Muskegon MICHIGAN 10 Hour Days
531824 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
535912 CT Tech Detroit MICHIGAN 12 Hour Nights
536431 ICU Ann Arbor MICHIGAN 12 Hour Nights
542041 ICU Ann Arbor MICHIGAN 12 Hour Nights
538242 PT Lansing MICHIGAN 8 Hour Days
538243 PT Lansing MICHIGAN 8 Hour Days
538400 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
540864 CT Tech Pigeon MICHIGAN 12 Hour Nights
538591 CT Tech Ann Arbor MICHIGAN 12 Hour Days
541236 CT Tech Petoskey MICHIGAN 12 Hour Nights
539979 Case Manager Petoskey MICHIGAN 8 Hour Days
472544 PT E Lamberton MINNESOTA Days
491571 Therapy Rehab E Lamberton MINNESOTA Days
537821 Dosimetrist Duluth MINNESOTA Varied
539087 Oncology Duluth MINNESOTA 12 Hour Day/Night Rotate
543801 CT Tech Long Prairie MINNESOTA 12 Hour Days
547947 Echo Minneapolis MINNESOTA 8 Hour Days
547950 PT Staples MINNESOTA 8 Hour Days
547951 PT Staples MINNESOTA 8 Hour Days
544897 CNA Breckenridge MINNESOTA 12 Hour Day/Night Rotate
544604 Surgical Tech Duluth MINNESOTA 12 Hour Day/Night Rotate
544615 OR Duluth MINNESOTA 8 Hour Day/Night Rotate
546264 ER Robbinsdale MINNESOTA 12 Hour Nights
546602 CT Tech Minneapolis MINNESOTA 12 Hour Days
547111 Ophthalmic Tech Duluth MINNESOTA Days
547424 Long Term Care GRAND MARAIS MINNESOTA 8 Hour Nights
547271 PT GRAND MARAIS MINNESOTA Varied
547522 CT Tech Cook MINNESOTA 12 Hour Day/Night Rotate
527125 Therapy Rehab Shelby MISSISSIPPI Days
531609 CT Tech Jackson MISSISSIPPI 8 Hour Nights
534605 Therapy Rehab Springfield MISSOURI Varied
534941 Med Surg Cape Girardeau MISSOURI Nights
534942 Med Surg Cape Girardeau MISSOURI Nights
535638 Rehab Cape Girardeau MISSOURI 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.5131 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 2100,100 in 1.4137 seconds