Listing all records

Displaying records 1201 through 1300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
531138 ICU Ogdensburg NEW YORK 12 Hour Nights
531354 ER - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531355 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531394 Pediatrics Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531618 Med Surg Massena NEW YORK 12 Hour Nights
531765 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531766 PICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
532671 ER Bronx NEW YORK 12 Hour Days
534169 Med Surg Oneonta NEW YORK 12 Hour Nights
534655 CT Tech Syracuse NEW YORK 8 Hour Days
537444 CNA Brooklyn NEW YORK 8 Hour Nights
535099 Radiology Bronx NEW YORK 12 Hour Days
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
535732 Pharmacist New York NEW YORK 8 Hour Nights
536558 ER Syracuse NEW YORK 12 Hour Nights RN/Registered Nurse
536589 OR New York NEW YORK 12 Hour Nights
536590 OR New York NEW YORK 12 Hour Nights
537141 ICU Ogdensburg NEW YORK 12 Hour Nights
537185 CT Tech Syracuse NEW YORK Nights
537445 CNA Brooklyn NEW YORK 8 Hour Nights
537446 CNA Brooklyn NEW YORK 8 Hour Days
537741 Psych New York NEW YORK 12 Hour Days
537792 L&D Ogdensburg NEW YORK 12 Hour Nights
538306 Step Down Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
537958 MRI Tech Staten Island NEW YORK 8 Hour Evenings
543428 ICU Ogdensburg NEW YORK 12 Hour Nights
538261 ICU Ogdensburg NEW YORK 12 Hour Nights
538497 Laboratory New York NEW YORK 8 Hour Evenings
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
546759 L&D Auburn NEW YORK 12 Hour Nights
538581 Long Term Care Canton NEW YORK 12 Hour Varied
538622 ER New York NEW YORK 12 Hour Nights
538624 ER New York NEW YORK 12 Hour Nights
538625 Med Surg Brooklyn NEW YORK 12 Hour Days
538686 Laboratory New York NEW YORK 8 Hour Days
543405 ICU Rome NEW YORK 12 Hour Nights
539176 ICU Albany NEW YORK 12 Hour Days
539177 Cardiology Albany NEW YORK 12 Hour Nights
539178 Med Surg Troy NEW YORK 12 Hour Nights
539293 Supervisor Brooklyn NEW YORK 8 Hour Days
539294 Radiology Queens NEW YORK 8 Hour Days
539450 Med Surg New York NEW YORK 8 Hour Evenings
539559 Laboratory New York NEW YORK 8 Hour Evenings
539926 Med Surg Schenectady NEW YORK 12 Hour Days
544153 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
544267 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544268 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544269 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544270 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
544389 Lab Tech Syracuse NEW YORK 8 Hour Days
544390 Lab Tech Syracuse NEW YORK 8 Hour Days
544433 Ambulatory Syracuse NEW YORK 8 Hour Days
544481 Lab Tech Syracuse NEW YORK 12 Hour Nights
547870 Med Surg Tele Rome NEW YORK 10 Hour Nights
544543 CT Tech Riverhead NEW YORK 10 Hour Nights
544608 SLP Syracuse NEW YORK 8 Hour Days
544817 OR Albany NEW YORK 12 Hour Day/Night Rotate
544819 ER Schenectady NEW YORK 12 Hour Nights
544904 RAD Tech New York NEW YORK 8 Hour Days
544905 Mammo Tech Port Jefferson NEW YORK 8 Hour Days
545026 OR Albany NEW YORK 12 Hour Day/Night Rotate
545069 Mammo Tech Port Jefferson NEW YORK 8 Hour Days
545169 Acute Care Bronx NEW YORK 12 Hour Days
545170 Infusion New York NEW YORK 8 Hour Days
545171 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545173 Med Surg Brooklyn NEW YORK 12 Hour Days
545178 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
545192 Acute Care Bronx NEW YORK 12 Hour Nights
545338 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
545621 ER Massena NEW YORK 12 Hour Nights
545985 Long Term Care Oneonta NEW YORK 8 Hour Nights
546045 EEG Tech Syracuse NEW YORK 8 Hour Days
546056 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
546057 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
546181 SLP Cooperstown NEW YORK 8 Hour Days
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
544701 OB/GYN Socorro NEW MEXICO 8 Hour Day/Night Rotate
544846 OR Espanola NEW MEXICO 10 Hour Days
544850 RAD Tech Albuquerque NEW MEXICO 8 Hour Day/Night Rotate
545082 Vascular Ultrasound Tech Artesia NEW MEXICO Days
545128 Med Surg Albuquerque NEW MEXICO 12 Hour Nights
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
546110 PTA Clovis NEW MEXICO 8 Hour Days
546309 ER Santa Rosa NEW MEXICO 12 Hour Nights
546310 ER Santa Rosa NEW MEXICO 12 Hour Nights
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
547066 PCU Rio Rancho NEW MEXICO 12 Hour Nights
547374 PCU Albuquerque NEW MEXICO 12 Hour Days
547377 PCU Albuquerque NEW MEXICO 12 Hour Days
547489 CT Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547515 Medical Assistant Ruidoso NEW MEXICO 8 Hour Days
547822 Interventional Radiology Tech Farmington NEW MEXICO 8 Hour Days
541326 Certified Surgical Tech Albuquerque NEW MEXICO 12 Hour Nights
541332 PCU Albuquerque NEW MEXICO 12 Hour Nights
542340 Home Health Santa Fe NEW MEXICO 8 Hour Days RN/Registered Nurse
542497 PT Clovis NEW MEXICO 8 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.608 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 desc limit 1200,100 in 1.3594 seconds