Listing all records

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

ID Job Specialty City State Shift Title
538435 CT Tech Harvard ILLINOIS 8 Hour Evenings
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
538591 CT Tech Ann Arbor MICHIGAN 12 Hour Days
538911 CT Tech Alturas CALIFORNIA 8 Hour Varied
539711 CT Tech Clinton IOWA 12 Hour Days
541236 CT Tech Petoskey MICHIGAN 12 Hour Nights
540060 CT Tech Farmington CONNECTICUT 10 Hour Days
540070 CT Tech Concord CALIFORNIA 10 Hour Nights
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
542160 CT Tech Lynwood CALIFORNIA 12 Hour Day/Night Rotate
542321 CT Tech Boise IDAHO 10 Hour Days
542943 CT Tech San Bernardino CALIFORNIA 8 Hour Day/Night Rotate
543005 CT Tech Oceanside CALIFORNIA 10 Hour Days
543336 CT Tech Westerville OHIO 10 Hour Days
543040 CT Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543318 CT Tech Staten Island NEW YORK 8 Hour Evenings
543332 CT Tech Waimea HAWAII 12 Hour Day/Night Rotate
543343 CT Tech Staten Island NEW YORK 8 Hour Days
543585 CT Tech Laconia NEW HAMPSHIRE 12 Hour Days
543757 CT Tech Lynwood CALIFORNIA 12 Hour Days
543758 CT Tech Lynwood CALIFORNIA 12 Hour Days
543782 CT Tech Woonsocket RHODE ISLAND 8 Hour Nights
543801 CT Tech Long Prairie MINNESOTA 12 Hour Days
543887 CT Tech National City CALIFORNIA 12 Hour Nights
543900 CT Tech Culbertson MONTANA Days
543990 CT Tech Boise IDAHO 10 Hour Evenings
546395 CT Tech Wichita Falls TEXAS 8 Hour Evenings
544121 CT Tech Avalon CALIFORNIA 8 Hour Varied
544228 CT Tech Denville NEW JERSEY 12 Hour Day/Night Rotate
544242 CT Tech Reno NEVADA 12 Hour Nights
544243 CT Tech Reno NEVADA 12 Hour Nights
544343 CT Tech Boise IDAHO 10 Hour Nights
544409 CT Tech Springfield VERMONT 8 Hour Nights
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
544489 CT Tech Culbertson MONTANA Days
544514 CT Tech Vernon Rockville CONNECTICUT 8 Hour Nights
544543 CT Tech Riverhead NEW YORK 10 Hour Nights
544775 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
544929 CT Tech Titusville FLORIDA 10 Hour Nights
544975 CT Tech Glendive MONTANA 8 Hour Varied
544996 CT Tech Omaha NEBRASKA 12 Hour Nights
545217 CT Tech York MAINE Days
546704 CT Tech Des Moines IOWA 10 Hour Days
545257 CT Tech Roseburg OREGON 10 Hour Nights
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
545390 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
545392 CT Tech Anchorage ALASKA 12 Hour Days
545490 CT Tech Farmington CONNECTICUT 8 Hour Nights
545532 CT Tech Montrose COLORADO 12 Hour Varied
545533 CT Tech Montrose COLORADO 12 Hour Varied
546247 CT Tech Toledo OHIO 8 Hour Evenings
546317 CT Tech ODESSA TEXAS 12 Hour Days
546345 CT Tech Goodyear ARIZONA 10 Hour Days
546352 CT Tech Manteca CALIFORNIA 8 Hour Days
546402 CT Tech Mount Airy NORTH CAROLINA 8 Hour Nights
546403 CT Tech Mount Airy NORTH CAROLINA 12 Hour Nights
546602 CT Tech Minneapolis MINNESOTA 12 Hour Days
546703 CT Tech Kremmling COLORADO 12 Hour Days
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
546787 CT Tech Robinson ILLINOIS 8 Hour Evenings
546811 CT Tech Harrison ARKANSAS 10 Hour Evenings
546923 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
546946 CT Tech Brattleboro VERMONT 12 Hour Nights
546966 CT Tech Silverdale WASHINGTON 10 Hour Nights
547007 CT Tech Maryville ILLINOIS 12 Hour Nights
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
547068 CT Tech Pella IOWA 12 Hour Nights
547076 CT Tech Farmington CONNECTICUT 12 Hour Nights
547077 CT Tech Farmington CONNECTICUT 12 Hour Nights
547244 CT Tech Birmingham ALABAMA 10 Hour Nights
547255 CT Tech Mullins SOUTH CAROLINA 12 Hour Nights
547275 CT Tech Syracuse NEW YORK 12 Hour Nights
547277 CT Tech Sioux City IOWA 10 Hour Nights
547389 CT Tech Cleveland OHIO 8 Hour Nights
547390 CT Tech Cleveland OHIO 8 Hour Evenings
547436 CT Tech Olympia WASHINGTON 12 Hour Nights
547470 CT Tech Hays KANSAS 8 Hour Nights
547479 CT Tech Arlington VIRGINIA 10 Hour Days
547482 CT Tech Rockingham NORTH CAROLINA 12 Hour Nights
547489 CT Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547522 CT Tech Cook MINNESOTA 12 Hour Day/Night Rotate
547556 CT Tech Ritzville WASHINGTON 8 Hour Days
547557 CT Tech Akron OHIO 12 Hour Days
547633 CT Tech Titusville FLORIDA 12 Hour Nights
547744 CT Tech Moses Lake WASHINGTON 12 Hour Nights
547761 CT Tech Glendale ARIZONA 8 Hour Days
547763 CT Tech Glendale ARIZONA 10 Hour Nights
547764 CT Tech Phoenix ARIZONA 10 Hour Days
547780 CT Tech Sunnyvale TEXAS 12 Hour Nights
547781 CT Tech Goodyear ARIZONA 10 Hour Nights
547844 CT Tech Des Moines IOWA 10 Hour Days
547886 CT Tech McCall IDAHO 12 Hour Nights
547887 CT Tech McCall IDAHO Days
547890 CT Tech Knoxville TENNESSEE 12 Hour Nights
547922 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
547936 CT Tech Morgantown WEST VIRGINIA 8 Hour Evenings
547974 CT Tech TOWNSHEND VERMONT Varied
548010 CT Tech Fort Bragg CALIFORNIA 12 Hour Day/Night Rotate
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.5915 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 3500,100 in 1.4604 seconds