Listing all records

Displaying records 3401 through 3500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543089 OR San Dimas CALIFORNIA 8 Hour Days
543230 OR Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544104 OR Langhorne PENNSYLVANIA 12 Hour Nights
543296 OR Albuquerque NEW MEXICO 12 Hour Days
543297 OR Albuquerque NEW MEXICO Nights
543337 OR Farmington CONNECTICUT 10 Hour Days
543338 OR Farmington CONNECTICUT 10 Hour Days
543455 OR Cape Girardeau MISSOURI Days
543725 OR Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
543729 OR Pella IOWA 10 Hour Varied
543751 OR Victorville CALIFORNIA 8 Hour Days
543779 OR Woonsocket RHODE ISLAND 8 Hour Days
543780 OR Woonsocket RHODE ISLAND 8 Hour Days
543781 OR Redding CALIFORNIA 8 Hour Days
543885 OR National City CALIFORNIA 8 Hour Days
543991 OR Omaha NEBRASKA 10 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544201 OR Germantown MARYLAND 8 Hour Evenings
544221 OR Newark NEW JERSEY 12 Hour Days
544251 OR Farmington CONNECTICUT 10 Hour Days
544293 OR Maywood ILLINOIS 10 Hour Days
544294 OR Maywood ILLINOIS 10 Hour Days
544768 OR ODESSA TEXAS 12 Hour Days
544482 OR Germantown MARYLAND 8 Hour Days
544562 OR Oregon City OREGON 10 Hour Day/Night Rotate
544615 OR Duluth MINNESOTA 8 Hour Day/Night Rotate
544644 OR Silver Spring MARYLAND 12 Hour Days
544645 OR Silver Spring MARYLAND 12 Hour Days
544646 OR Silver Spring MARYLAND 12 Hour Days
544647 OR Silver Spring MARYLAND 12 Hour Days
544648 OR Silver Spring MARYLAND Nights
544649 OR Silver Spring MARYLAND Nights
544817 OR Albany NEW YORK 12 Hour Day/Night Rotate
544818 OR Maywood ILLINOIS 10 Hour Days
544846 OR Espanola NEW MEXICO 10 Hour Days
544886 OR Aspen COLORADO 10 Hour Days
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
545020 OR Clarkston WASHINGTON 10 Hour Varied
545021 OR Clarkston WASHINGTON 10 Hour Varied
545026 OR Albany NEW YORK 12 Hour Day/Night Rotate
545030 OR Gardner MASSACHUSETTS 10 Hour Days
548408 OR Cleveland OHIO 12 Hour Days RN/Registered Nurse
545284 OR El Paso TEXAS 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
548394 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate RN/Registered Nurse
548142 OR Bakersfield CALIFORNIA 8 Hour Day/Night Rotate RN/Registered Nurse
548288 OR Victorville CALIFORNIA 8 Hour Days RN/Registered Nurse
546103 OR Springfield MASSACHUSETTS 8 Hour Days
546367 OR Maywood ILLINOIS 10 Hour Days
546393 OR Johnson City TENNESSEE Nights
546469 OR Louisville KENTUCKY 8 Hour Days
546489 OR Brooklyn NEW YORK 8 Hour Days
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
546679 OR Waterloo IOWA 12 Hour Days
546689 OR Templeton CALIFORNIA 10 Hour Days
546711 OR Muskegon MICHIGAN 10 Hour Days
546757 OR Petoskey MICHIGAN 10 Hour Days
546805 OR Peoria ILLINOIS Nights
546995 OR Athens GEORGIA 8 Hour Days
547152 OR Brooklyn NEW YORK 8 Hour Days
547183 OR Brooklyn NEW YORK 12 Hour Nights
547675 OR Waterloo IOWA 12 Hour Days
547699 OR Sun City ARIZONA 12 Hour Days
547720 OR Concord CALIFORNIA 8 Hour Days
547755 OR Albany NEW YORK 12 Hour Days
547795 OR Tuba City ARIZONA 10 Hour Days
547820 OR Laurinburg NORTH CAROLINA 8 Hour Days
547836 OR Honolulu HAWAII 8 Hour Day/Night Rotate
547895 OR Coos Bay OREGON 10 Hour Days
547957 OR Mesquite TEXAS 8 Hour Days
547923 OR Muskegon MICHIGAN 10 Hour Days
547955 OR Madison WISCONSIN 10 Hour Day/Night Rotate
548162 OR Centerville IOWA 8 Hour Days RN/Registered Nurse
548163 OR Mason City IOWA 8 Hour Days RN/Registered Nurse
548037 OR Laurinburg NORTH CAROLINA 8 Hour Days
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
548043 OR Bakersfield CALIFORNIA 8 Hour Days RN/Registered Nurse
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
548046 OR BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548091 OR Columbia SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
548105 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
523775 ICU Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
530342 ICU Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
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
544870 ICU Oxford NORTH CAROLINA 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.4219 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 3400,100 in 1.3865 seconds