Listing all records

Displaying records 2501 through 2600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543005 CT Tech Oceanside CALIFORNIA 10 Hour Days
543006 CVOR Oceanside CALIFORNIA 8 Hour Days
543790 RAD Tech Oceanside CALIFORNIA 8 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544012 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544908 ER Oceanside CALIFORNIA 12 Hour Nights
544909 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544910 RAD Tech Oceanside CALIFORNIA 8 Hour Days
547932 Telemetry - Per Diem Oceanside CALIFORNIA 12 Hour Nights
548274 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
548359 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
546692 Med Surg Oceanside CALIFORNIA 12 Hour Days
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
546694 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
546695 ER Oceanside CALIFORNIA 12 Hour Nights
547664 ICU Oceanside CALIFORNIA 12 Hour Nights
547665 Oncology Oceanside CALIFORNIA 12 Hour Nights
517294 Surgical Tech Oceanside CALIFORNIA 10 Hour Days
517474 Ortho Tech Oceanside CALIFORNIA 8 Hour Days
520291 CT Tech Oceanside CALIFORNIA 10 Hour Days
541765 CVOR Oceanside CALIFORNIA 8 Hour Nights
524582 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
524588 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
525235 CT Tech Oceanside CALIFORNIA 10 Hour Days
527624 Scrub Tech Oceanside CALIFORNIA 10 Hour Days
527625 Sterile Processing Technician Oceanside CALIFORNIA 10 Hour Nights
527789 RAD Tech Oceanside CALIFORNIA 8 Hour Days
528610 OR Oceanside CALIFORNIA 10 Hour Days
530433 Surgical Tech Oceanside CALIFORNIA Varied
531037 Nuclear Medicine Oceanside CALIFORNIA 8 Hour Days
534108 Echo Oceanside CALIFORNIA 10 Hour Days
534109 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
548094 ER ODESSA TEXAS 12 Hour Nights RN/Registered Nurse
544768 OR ODESSA TEXAS 12 Hour Days
546317 CT Tech ODESSA TEXAS 12 Hour Days
547409 Postpartum ODESSA TEXAS 12 Hour Days
532338 PT Ogden UTAH Days
531138 ICU Ogdensburg NEW YORK 12 Hour Nights
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
537141 ICU Ogdensburg NEW YORK 12 Hour Nights
537792 L&D Ogdensburg NEW YORK 12 Hour Nights
543428 ICU Ogdensburg NEW YORK 12 Hour Nights
538261 ICU Ogdensburg NEW YORK 12 Hour Nights
546410 ICU Ogdensburg NEW YORK 12 Hour Nights
546411 ICU Ogdensburg NEW YORK 12 Hour Nights
546833 Med Surg Ogdensburg NEW YORK 12 Hour Nights
546259 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546260 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546270 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546271 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546781 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
547702 RAD Tech Oklahoma City OKLAHOMA 12 Hour Nights
520665 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521322 ICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521323 Step Down Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521324 CVICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521325 Oncology Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521326 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521327 Step Down Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521337 Med Surg Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521340 Med Surg Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521341 Oncology Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521981 Step Down Oklahoma City OKLAHOMA 12 Hour Days
521994 Step Down Oklahoma City OKLAHOMA 12 Hour Days
540725 Step Down Oklahoma City OKLAHOMA 12 Hour Nights
543955 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543957 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543958 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543959 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
546717 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546720 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546722 Med Surg Olympia WASHINGTON 12 Hour Nights
547436 CT Tech Olympia WASHINGTON 12 Hour Nights
547643 Med Surg Olympia WASHINGTON 12 Hour Nights
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
544995 PCU Omaha NEBRASKA 12 Hour Nights
544996 CT Tech Omaha NEBRASKA 12 Hour Nights
545262 PCU Omaha NEBRASKA 12 Hour Nights
543991 OR Omaha NEBRASKA 10 Hour Days
538194 CT Tech Omaha NEBRASKA 12 Hour Nights
538195 CT Tech Omaha NEBRASKA 12 Hour Days
547656 Rehab Omaha NEBRASKA 12 Hour Days
547657 PCU Omaha NEBRASKA 12 Hour Nights
547658 PCU Omaha NEBRASKA 12 Hour Nights
547659 PCU Omaha NEBRASKA 12 Hour Days
547662 Surgical Tech Omaha NEBRASKA 8 Hour Days
547039 Supervisor Oneonta NEW YORK 8 Hour Nights
542442 Med Surg Oneonta NEW YORK 12 Hour Days
542085 PT Oneonta NEW YORK 8 Hour Days
543186 Med Surg Oneonta NEW YORK 12 Hour Days
545985 Long Term Care Oneonta NEW YORK 8 Hour Nights
547973 Med Surg Oneonta NEW YORK 12 Hour Days
548205 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548206 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548301 ER Oneonta NEW YORK 12 Hour Days RN/Registered Nurse
548328 LPN/LVN Oneonta NEW YORK 12 Hour Days LPN/Licensed Practical Nurse
541809 Med Surg Oneonta NEW YORK 12 Hour Nights
541810 Med Surg Oneonta NEW YORK 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.5855 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 z.city asc limit 2500,100 in 1.4138 seconds