Listing all records

Displaying records 3301 through 3400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
546695 ER Oceanside CALIFORNIA 12 Hour Nights
546709 ER Albany NEW YORK 12 Hour Nights
546710 ER Albany NEW YORK 12 Hour Nights
546760 ER Auburn NEW YORK 12 Hour Nights
546761 ER Auburn NEW YORK 12 Hour Nights
548359 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
546868 ER MERCED CALIFORNIA 12 Hour Days
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
546912 ER Goldendale WASHINGTON 12 Hour Days
546913 ER Des Moines IOWA 12 Hour Days
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
546937 ER Albany NEW YORK 12 Hour Nights
546938 ER Albany NEW YORK 12 Hour Nights
546939 ER Albany NEW YORK 12 Hour Nights
547126 ER Des Moines IOWA 12 Hour Days
547138 ER Arlington WASHINGTON 12 Hour Nights
548367 ER FOLSOM CALIFORNIA 12 Hour Nights RN/Registered Nurse
547279 ER Muskegon MICHIGAN 12 Hour Nights
547280 ER Muskegon MICHIGAN 12 Hour Nights
547289 ER CORDOVA ALASKA 12 Hour Nights
547290 ER Norton VIRGINIA 12 Hour Days
547480 ER Manchester CONNECTICUT 12 Hour Nights
547481 ER Manchester CONNECTICUT 12 Hour Nights
547550 ER Manchester CONNECTICUT 12 Hour Nights
547566 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547576 ER Watertown NEW YORK 12 Hour Day/Night Rotate
548198 ER Casa Grande ARIZONA 12 Hour Nights RN/Registered Nurse
547623 ER Albany OREGON 12 Hour Day/Night Rotate
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
547711 ER New York NEW YORK 12 Hour Days
547776 ER Morton WASHINGTON Nights
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
547914 ER Estes Park COLORADO 12 Hour Nights
547918 ER Des Moines IOWA 12 Hour Nights
547919 ER Des Moines IOWA 12 Hour Days
547920 ER Des Moines IOWA 12 Hour Days
547930 ER Brownsville TEXAS 12 Hour Nights
547967 ER Madison WISCONSIN 12 Hour Day/Night Rotate
547975 ER Goldendale WASHINGTON 12 Hour Nights
548167 ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548003 ER Pittsfield MASSACHUSETTS 12 Hour Nights
540019 OR Farmington CONNECTICUT 12 Hour Days
540025 OR Concord CALIFORNIA 10 Hour Evenings
540026 OR Concord CALIFORNIA 8 Hour Days
540045 OR Farmington CONNECTICUT 10 Hour Days
540053 OR Walnut Creek CALIFORNIA 12 Hour Nights
540058 OR Walnut Creek CALIFORNIA 12 Hour Days
540061 OR Farmington CONNECTICUT 10 Hour Days
540062 OR Farmington CONNECTICUT 10 Hour Days
540077 OR Walnut Creek CALIFORNIA 12 Hour Days
540084 OR Walnut Creek CALIFORNIA 12 Hour Days
540109 OR Walnut Creek CALIFORNIA 12 Hour Days
540192 OR Concord CALIFORNIA 12 Hour Days
548294 OR Madison WISCONSIN 12 Hour Days RN/Registered Nurse
548289 OR Brownwood TEXAS 8 Hour Days RN/Registered Nurse
548299 OR Arlington VIRGINIA 10 Hour Days RN/Registered Nurse
540239 OR Walnut Creek CALIFORNIA 12 Hour Days
543779 OR Woonsocket RHODE ISLAND 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
548194 OR Norman OKLAHOMA 12 Hour Days RN/Registered Nurse
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
548288 OR Victorville CALIFORNIA 8 Hour Days RN/Registered Nurse
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
545284 OR El Paso TEXAS 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
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
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.5678 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 3300,100 in 1.3691 seconds