Listing all records

Displaying records 201 through 300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540042 ICU Concord CALIFORNIA 12 Hour Days
548375 ICU Chicago ILLINOIS 12 Hour Nights RN/Registered Nurse
545242 ICU Scottsbluff NEBRASKA 12 Hour Varied
545730 ICU Gainesville FLORIDA 12 Hour Nights
545911 ICU Gainesville FLORIDA 12 Hour Nights
531138 ICU Ogdensburg NEW YORK 12 Hour Nights
540274 ICU Concord CALIFORNIA 12 Hour Days
540244 ICU Concord CALIFORNIA 12 Hour Days
529965 ICU Boise IDAHO 12 Hour Nights
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
540200 ICU Walnut Creek CALIFORNIA 12 Hour Nights
547977 ICU Memphis TENNESSEE 12 Hour Nights
542908 ICU Cleveland OHIO 12 Hour Day/Night Rotate
545793 ICU Gainesville FLORIDA 12 Hour Nights
537141 ICU Ogdensburg NEW YORK 12 Hour Nights
532473 ICU Maywood ILLINOIS 12 Hour Nights
536431 ICU Ann Arbor MICHIGAN 12 Hour Nights
540055 ICU Farmington CONNECTICUT 12 Hour Nights
545689 ICU Gainesville FLORIDA 12 Hour Nights
545839 ICU Gainesville FLORIDA 12 Hour Nights
545831 ICU Gainesville FLORIDA 12 Hour Days
548331 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
545886 ICU Gainesville FLORIDA 12 Hour Days
548366 ICU Anaheim CALIFORNIA 12 Hour Days RN/Registered Nurse
548393 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
547905 ICU Greeley COLORADO 12 Hour Nights
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
547895 OR Coos Bay OREGON 10 Hour Days
546469 OR Louisville KENTUCKY 8 Hour Days
546393 OR Johnson City TENNESSEE Nights
543781 OR Redding CALIFORNIA 8 Hour Days
545284 OR El Paso TEXAS 12 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544221 OR Newark NEW JERSEY 12 Hour Days
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
546689 OR Templeton CALIFORNIA 10 Hour Days
544251 OR Farmington CONNECTICUT 10 Hour Days
543725 OR Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547720 OR Concord CALIFORNIA 8 Hour Days
540632 OR Maywood ILLINOIS 10 Hour Days
544768 OR ODESSA TEXAS 12 Hour Days
543780 OR Woonsocket RHODE ISLAND 8 Hour Days
547699 OR Sun City ARIZONA 12 Hour Days
539658 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate
546995 OR Athens GEORGIA 8 Hour Days
540192 OR Concord CALIFORNIA 12 Hour Days
547755 OR Albany NEW YORK 12 Hour Days
543991 OR Omaha NEBRASKA 10 Hour Days
544649 OR Silver Spring MARYLAND Nights
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
545194 OR Paris ILLINOIS 8 Hour Evenings
536589 OR New York NEW YORK 12 Hour Nights
544615 OR Duluth MINNESOTA 8 Hour Day/Night Rotate
544647 OR Silver Spring MARYLAND 12 Hour Days
547836 OR Honolulu HAWAII 8 Hour Day/Night Rotate
544817 OR Albany NEW YORK 12 Hour Day/Night Rotate
546367 OR Maywood ILLINOIS 10 Hour Days
540019 OR Farmington CONNECTICUT 12 Hour Days
540058 OR Walnut Creek CALIFORNIA 12 Hour Days
541257 OR Concord CALIFORNIA 10 Hour Evenings
544201 OR Germantown MARYLAND 8 Hour Evenings
540005 OR Farmington CONNECTICUT 10 Hour Days
543729 OR Pella IOWA 10 Hour Varied
546679 OR Waterloo IOWA 12 Hour Days
543779 OR Woonsocket RHODE ISLAND 8 Hour Days
547152 OR Brooklyn NEW YORK 8 Hour Days
543885 OR National City CALIFORNIA 8 Hour Days
546805 OR Peoria ILLINOIS Nights
544818 OR Maywood ILLINOIS 10 Hour Days
547675 OR Waterloo IOWA 12 Hour Days
537715 OR Farmington CONNECTICUT 10 Hour Days
541392 OR East Norriton PENNSYLVANIA 8 Hour Days
537716 OR Farmington CONNECTICUT 10 Hour Days
544293 OR Maywood ILLINOIS 10 Hour Days
540628 OR Mason City IOWA 8 Hour Days
544294 OR Maywood ILLINOIS 10 Hour Days
547183 OR Brooklyn NEW YORK 12 Hour Nights
544645 OR Silver Spring MARYLAND 12 Hour Days
540025 OR Concord CALIFORNIA 10 Hour Evenings
540305 OR Walnut Creek CALIFORNIA 12 Hour Nights
544648 OR Silver Spring MARYLAND Nights
540239 OR Walnut Creek CALIFORNIA 12 Hour Days
544644 OR Silver Spring MARYLAND 12 Hour Days
544562 OR Oregon City OREGON 10 Hour Day/Night Rotate
544846 OR Espanola NEW MEXICO 10 Hour Days
547795 OR Tuba City ARIZONA 10 Hour Days
540010 OR Walnut Creek CALIFORNIA 12 Hour Days
536758 OR Germantown MARYLAND 8 Hour Days
540310 OR Walnut Creek CALIFORNIA 12 Hour Days
546489 OR Brooklyn NEW YORK 8 Hour Days
546757 OR Petoskey MICHIGAN 10 Hour Days
546711 OR Muskegon MICHIGAN 10 Hour Days
543751 OR Victorville CALIFORNIA 8 Hour Days
543455 OR Cape Girardeau MISSOURI Days
544482 OR Germantown MARYLAND 8 Hour Days
547820 OR Laurinburg NORTH CAROLINA 8 Hour Days
546103 OR Springfield MASSACHUSETTS 8 Hour Days
539391 OR Bristol TENNESSEE 12 Hour Varied
544646 OR Silver Spring MARYLAND 12 Hour Days
540627 OR Mason City IOWA 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.5433 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 asc limit 200,100 in 1.5683 seconds