Listing all records

Displaying records 3501 through 3600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
539176 ICU Albany NEW YORK 12 Hour Days
540042 ICU Concord CALIFORNIA 12 Hour Days
540055 ICU Farmington CONNECTICUT 12 Hour Nights
540056 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540057 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540086 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540105 ICU Concord CALIFORNIA 12 Hour Nights
540116 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540117 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540118 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540119 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540120 ICU Walnut Creek CALIFORNIA 12 Hour Days
540128 ICU Walnut Creek CALIFORNIA 12 Hour Days
540175 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540200 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540203 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540208 ICU Concord CALIFORNIA 12 Hour Days
540211 ICU Concord CALIFORNIA 12 Hour Nights
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540230 ICU Walnut Creek CALIFORNIA 12 Hour Days
540234 ICU Concord CALIFORNIA 12 Hour Nights
540235 ICU Concord CALIFORNIA 12 Hour Days
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540238 ICU Walnut Creek CALIFORNIA 12 Hour Days
540241 ICU Concord CALIFORNIA 12 Hour Days
540242 ICU Concord CALIFORNIA 12 Hour Nights
540244 ICU Concord CALIFORNIA 12 Hour Days
540346 ICU Walnut Creek CALIFORNIA 12 Hour Days
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
542063 ICU Wailuku HAWAII 12 Hour Nights
542176 ICU Boise IDAHO 12 Hour Nights
542177 ICU Boise IDAHO 12 Hour Nights
542740 ICU Saratoga Springs NEW YORK 12 Hour Nights
542781 ICU Boise IDAHO 12 Hour Nights
542782 ICU Boise IDAHO 12 Hour Nights
543200 ICU Newark NEW JERSEY 12 Hour Days
543668 ICU Bristol TENNESSEE 12 Hour Days
543669 ICU Bristol TENNESSEE 12 Hour Nights
543884 ICU Philadelphia PENNSYLVANIA 12 Hour Days
544060 ICU Pontiac MICHIGAN 12 Hour Nights
544222 ICU Passaic NEW JERSEY 12 Hour Nights
544388 ICU Scottsbluff NEBRASKA 12 Hour Varied
544570 ICU Burbank CALIFORNIA 12 Hour Nights
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
545242 ICU Scottsbluff NEBRASKA 12 Hour Varied
545311 ICU Colville WASHINGTON 12 Hour Nights
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
546470 ICU East Norriton PENNSYLVANIA 12 Hour Days
546566 ICU Brooklyn NEW YORK 12 Hour Days
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
546698 ICU East Norriton PENNSYLVANIA 12 Hour Nights
546708 ICU Albany NEW YORK 12 Hour Nights
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
547084 ICU Pendleton OREGON 12 Hour Nights
547085 ICU Pendleton OREGON 12 Hour Nights
547258 ICU Portland OREGON 12 Hour Nights
547259 ICU Portland OREGON 12 Hour Nights
547260 ICU Portland OREGON 12 Hour Nights
547281 ICU Muskegon MICHIGAN 12 Hour Nights
547282 ICU Muskegon MICHIGAN 12 Hour Nights
547318 ICU Meridian IDAHO 12 Hour Nights
547427 ICU York MAINE 12 Hour Nights
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
547575 ICU Lewiston MAINE 12 Hour Days
547593 ICU Newton IOWA 12 Hour Nights
547603 ICU Issaquah WASHINGTON 12 Hour Days
547664 ICU Oceanside CALIFORNIA 12 Hour Nights
547668 ICU Laconia NEW HAMPSHIRE Nights
547676 ICU Lowville NEW YORK 12 Hour Nights
547707 ICU North Platte NEBRASKA Nights
547793 ICU Bozeman MONTANA 12 Hour Day/Night Rotate
547812 ICU Woonsocket RHODE ISLAND 12 Hour Nights
547882 ICU Johnson City TENNESSEE 12 Hour Nights
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
547905 ICU Greeley COLORADO 12 Hour Nights
547906 ICU Sun City ARIZONA 12 Hour Nights
547924 ICU Boise IDAHO 12 Hour Nights
547925 ICU Boise IDAHO 12 Hour Nights
547977 ICU Memphis TENNESSEE 12 Hour Nights
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
548025 ICU Portland OREGON 12 Hour Nights
548034 ICU Newton IOWA 12 Hour Nights
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
548066 ICU Bellefontaine OHIO 12 Hour Nights RN/Registered Nurse
548081 ICU Hartford CONNECTICUT 12 Hour Nights RN/Registered Nurse
548116 ICU Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548127 ICU Glens Falls NEW YORK 12 Hour Days RN/Registered Nurse
548136 ICU Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548177 ICU Rancho Cordova CALIFORNIA 12 Hour Nights RN/Registered Nurse
548181 ICU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548196 ICU Ranson WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
548213 ICU Arlington WASHINGTON 12 Hour Days RN/Registered Nurse
548229 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548231 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548237 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
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.5105 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 3500,100 in 2.24 seconds