Listing all records

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

ID Job Specialty City State Shift Title
547672 CVOR Falls Church VIRGINIA 12 Hour Days
547674 CVOR Falls Church VIRGINIA 12 Hour Days
547700 CVOR Sun City ARIZONA 10 Hour Days
547673 CVOR Falls Church VIRGINIA 12 Hour Days
547786 CVOR North Kansas City MISSOURI 8 Hour Days
546355 CVOR Lakewood CALIFORNIA 8 Hour Days
546356 CVOR Lakewood CALIFORNIA 8 Hour Days
546357 CVOR Lakewood CALIFORNIA 8 Hour Days
546474 CVOR Corvallis OREGON 12 Hour Day/Night Rotate
547326 CVOR Ann Arbor MICHIGAN 10 Hour Days
547235 NICU Brooklyn NEW YORK 12 Hour Days
509928 NICU Brooklyn NEW YORK 12 Hour Nights
541845 NICU Walnut Creek CALIFORNIA 12 Hour Nights
547467 NICU Walnut Creek CALIFORNIA 12 Hour Days
548089 NICU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548150 NICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
540008 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540031 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540066 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540067 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540068 NICU Walnut Creek CALIFORNIA 12 Hour Days
540069 NICU Walnut Creek CALIFORNIA 12 Hour Days
540074 NICU Walnut Creek CALIFORNIA 12 Hour Nights
546802 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540138 NICU Walnut Creek CALIFORNIA 12 Hour Days
547466 NICU Des Moines IOWA 12 Hour Nights
540166 NICU Walnut Creek CALIFORNIA 12 Hour Days
540209 NICU Walnut Creek CALIFORNIA 12 Hour Days
540219 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540252 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540254 NICU Walnut Creek CALIFORNIA 12 Hour Days
540257 NICU Walnut Creek CALIFORNIA 12 Hour Days
546575 NICU Brooklyn NEW YORK 12 Hour Nights
540269 NICU Walnut Creek CALIFORNIA 12 Hour Nights
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
540284 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540290 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540296 NICU Walnut Creek CALIFORNIA 12 Hour Nights
547751 NICU Brooklyn NEW YORK 12 Hour Nights
540303 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540814 NICU Lynwood CALIFORNIA 12 Hour Nights
548056 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548053 NICU New York NEW YORK 12 Hour Days RN/Registered Nurse
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
543308 NICU Walnut Creek CALIFORNIA 12 Hour Days
543872 NICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543755 NICU Lynwood CALIFORNIA 12 Hour Nights
547414 NICU Bronx NEW YORK 8 Hour Days
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
544706 NICU Des Moines IOWA 12 Hour Days
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
548351 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
545426 NICU Mishawaka INDIANA 12 Hour Days
545427 NICU Mishawaka INDIANA 12 Hour Nights
547750 NICU Brooklyn NEW YORK 12 Hour Nights
546568 NICU Brooklyn NEW YORK 12 Hour Days
547329 NICU Mission Hills CALIFORNIA 12 Hour Nights
546565 NICU Brooklyn NEW YORK 12 Hour Nights
548312 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
541769 Oncology Pueblo COLORADO 12 Hour Days
521325 Oncology Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521341 Oncology Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
532920 Oncology San Angelo TEXAS Days
534249 Oncology Cleveland OHIO 12 Hour Days
534250 Oncology Cleveland OHIO 12 Hour Nights
548329 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548314 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
539087 Oncology Duluth MINNESOTA 12 Hour Day/Night Rotate
539320 Oncology York PENNSYLVANIA 12 Hour Day/Night Rotate
539713 Oncology Des Moines IOWA 12 Hour Nights
539714 Oncology Des Moines IOWA 12 Hour Nights
548335 Oncology Albany NEW YORK 12 Hour Nights RN/Registered Nurse
542242 Oncology Charlottesville VIRGINIA 12 Hour Nights
542243 Oncology Charlottesville VIRGINIA 12 Hour Nights
542636 Oncology Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
542669 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
542670 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
543041 Oncology Janesville WISCONSIN Varied
543044 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
543096 Oncology Newark NEW JERSEY 8 Hour Days
546781 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
543461 Oncology Kingsport TENNESSEE 12 Hour Nights
548186 Oncology SACRAMENTO CALIFORNIA 12 Hour Nights RN/Registered Nurse
543696 Oncology Bristol TENNESSEE 12 Hour Days
547008 Oncology Everett WASHINGTON 12 Hour Nights
544219 Oncology Newark NEW JERSEY 12 Hour Days
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
548313 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
544678 Oncology Midland TEXAS Nights
544788 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
548330 Oncology Newark NEW JERSEY 8 Hour Days RN/Registered Nurse
547295 Oncology Coos Bay OREGON 10 Hour Days
546724 Oncology Everett WASHINGTON 12 Hour Nights
546270 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546271 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
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.4886 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.specialty desc limit 2500,100 in 1.3566 seconds