Listing all records

Displaying records 3201 through 3300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
542573 Surgical Tech Louisville KENTUCKY 12 Hour Days
541654 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
542401 Surgical Tech Leavenworth KANSAS 8 Hour Days
542605 Surgical Tech Woonsocket RHODE ISLAND 8 Hour Days
542718 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
542826 Surgical Tech Boise IDAHO Days
542946 Surgical Tech Boise IDAHO Days
543119 Surgical Tech Columbus OHIO 12 Hour Days
543127 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543128 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543129 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543130 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543183 Surgical Tech Athens GEORGIA 8 Hour Days
543184 Surgical Tech Athens GEORGIA 8 Hour Days
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
543370 Surgical Tech Silver Spring MARYLAND Nights
543630 Surgical Tech Stafford Springs CONNECTICUT 8 Hour Days
547979 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
544234 Surgical Tech Denville NEW JERSEY 12 Hour Days
544263 Surgical Tech Westerville OHIO 12 Hour Days
548140 Surgical Tech Nacogdoches TEXAS 8 Hour Days CST/Certified Surgical Technician
544345 Surgical Tech Ketchum IDAHO 12 Hour Days
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
544604 Surgical Tech Duluth MINNESOTA 12 Hour Day/Night Rotate
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
544994 Surgical Tech Kearney NEBRASKA 8 Hour Days
545191 Surgical Tech New Albany OHIO 12 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545313 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
545665 Surgical Tech Gainesville FLORIDA 12 Hour Days
545763 Surgical Tech Gainesville FLORIDA 12 Hour Days
547956 Surgical Tech Glens Falls NEW YORK 10 Hour Days
545889 Surgical Tech Gainesville FLORIDA 12 Hour Days
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
546422 Surgical Tech Columbus OHIO Days
546651 Surgical Tech Louisville KENTUCKY 8 Hour Days
546690 Surgical Tech Templeton CALIFORNIA 10 Hour Days
546697 Surgical Tech Reno NEVADA 12 Hour Days
546770 Surgical Tech IOWA CITY IOWA Days
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
546951 Surgical Tech Long Beach CALIFORNIA 12 Hour Nights
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547036 Surgical Tech Falls Church VIRGINIA 8 Hour Day/Night Rotate
547969 Surgical Tech Auburn NEW YORK 10 Hour Days
547189 Surgical Tech Brooklyn NEW YORK 8 Hour Nights
547247 Surgical Tech Detroit MICHIGAN 8 Hour Days
547330 Surgical Tech Macon GEORGIA 8 Hour Days
548083 Surgical Tech Seattle WASHINGTON 10 Hour Days Tech/Technologist
547606 Surgical Tech Boise IDAHO 10 Hour Days
547662 Surgical Tech Omaha NEBRASKA 8 Hour Days
547837 Surgical Tech Honolulu HAWAII 8 Hour Day/Night Rotate
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
547916 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547917 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
525604 RAD Tech Richmond VIRGINIA 12 Hour Days Radiology Techs/Technologists
525605 RAD Tech Boston MASSACHUSETTS 10 Hour Days Radiology Techs/Technologists
525606 RAD Tech Columbus OHIO 8 Hour Evenings Radiology Techs/Technologists
525812 RAD Tech Amarillo TEXAS 8 Hour Evenings Radiology Techs/Technologists
525839 RAD Tech Wilmington NORTH CAROLINA 12 Hour Days Radiology Techs/Technologists
525930 RAD Tech Los Angeles CALIFORNIA 10 Hour Days Radiology Techs/Technologists
526053 RAD Tech Clearwater FLORIDA 8 Hour Days RN/Registered Nurse
526054 RAD Tech Cleveland OHIO 8 Hour Days Radiology Techs/Technologists
533260 RAD Tech Des Moines IOWA 10 Hour Days
534109 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
540083 RAD Tech Farmington CONNECTICUT 8 Hour Days
543886 RAD Tech National City CALIFORNIA 12 Hour Nights
543888 RAD Tech National City CALIFORNIA 12 Hour Days
543944 RAD Tech Walnut Creek CALIFORNIA 10 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
544012 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544202 RAD Tech Dubuque IOWA 8 Hour Days
544240 RAD Tech Reno NEVADA 12 Hour Days
544241 RAD Tech Reno NEVADA 12 Hour Days
544264 RAD Tech Silver Spring MARYLAND 8 Hour Evenings
544670 RAD Tech Los Angeles CALIFORNIA 8 Hour Days
544850 RAD Tech Albuquerque NEW MEXICO 8 Hour Day/Night Rotate
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
544904 RAD Tech New York NEW YORK 8 Hour Days
544909 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544910 RAD Tech Oceanside CALIFORNIA 8 Hour Days
545084 RAD Tech San Diego CALIFORNIA 12 Hour Days
545125 RAD Tech Gig Harbor WASHINGTON 8 Hour Day/Night Rotate
545154 RAD Tech Lebanon NEW HAMPSHIRE 12 Hour Nights
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
545302 RAD Tech Farmington CONNECTICUT 8 Hour Evenings
545411 RAD Tech Rockville MARYLAND 8 Hour Days
545486 RAD Tech Florence SOUTH CAROLINA 8 Hour Days
547141 RAD Tech Farmington CONNECTICUT 8 Hour Nights
545541 RAD Tech Columbus OHIO 8 Hour Nights
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
545564 RAD Tech Peoria ILLINOIS 8 Hour Days
545569 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
547800 RAD Tech Pontiac MICHIGAN 8 Hour Nights
547808 RAD Tech Cleveland OHIO 10 Hour Day/Night Rotate
547809 RAD Tech Cleveland OHIO 8 Hour Days
547858 RAD Tech Winter Haven FLORIDA 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.4487 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 3200,100 in 1.5273 seconds