Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
537514 CT Tech The Dalles OREGON 12 Hour Day/Night Rotate
540425 CT Tech Oceanside CALIFORNIA 8 Hour Evenings
543887 CT Tech National City CALIFORNIA 12 Hour Nights
543336 CT Tech Westerville OHIO 10 Hour Days
544929 CT Tech Titusville FLORIDA 10 Hour Nights
536776 CT Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
536227 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
547390 CT Tech Cleveland OHIO 8 Hour Evenings
543318 CT Tech Staten Island NEW YORK 8 Hour Evenings
543332 CT Tech Waimea HAWAII 12 Hour Day/Night Rotate
543585 CT Tech Laconia NEW HAMPSHIRE 12 Hour Days
547556 CT Tech Ritzville WASHINGTON 8 Hour Days
536231 CT Tech Maywood ILLINOIS 8 Hour Evenings
546247 CT Tech Toledo OHIO 8 Hour Evenings
526713 CT Tech Silver Spring MARYLAND 10 Hour Days
547470 CT Tech Hays KANSAS 8 Hour Nights
544489 CT Tech Culbertson MONTANA Days
503607 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
544543 CT Tech Riverhead NEW YORK 10 Hour Nights
540263 CT Tech Concord CALIFORNIA 10 Hour Nights
539711 CT Tech Clinton IOWA 12 Hour Days
543900 CT Tech Culbertson MONTANA Days
535912 CT Tech Detroit MICHIGAN 12 Hour Nights
530562 CT Tech Camp Hill PENNSYLVANIA 10 Hour Nights
547522 CT Tech Cook MINNESOTA 12 Hour Day/Night Rotate
546811 CT Tech Harrison ARKANSAS 10 Hour Evenings
525811 CT Tech Amarillo TEXAS 12 Hour Nights Tech/Technologist
544975 CT Tech Glendive MONTANA 8 Hour Varied
540812 CT Tech Denville NEW JERSEY 8 Hour Days
547479 CT Tech Arlington VIRGINIA 10 Hour Days
543005 CT Tech Oceanside CALIFORNIA 10 Hour Days
540060 CT Tech Farmington CONNECTICUT 10 Hour Days
545532 CT Tech Montrose COLORADO 12 Hour Varied
532545 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
545979 CT Tech Santa Barbara CALIFORNIA 12 Hour Day/Night Rotate
540070 CT Tech Concord CALIFORNIA 10 Hour Nights
531899 CT Tech Marysville OHIO 12 Hour Nights
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
546703 CT Tech Kremmling COLORADO 12 Hour Days
546704 CT Tech Des Moines IOWA 10 Hour Days
529510 CT Tech Bethel ALASKA 12 Hour Day/Night Rotate
542321 CT Tech Boise IDAHO 10 Hour Days
517854 CT Tech Akron OHIO 10 Hour Days
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
547077 CT Tech Farmington CONNECTICUT 12 Hour Nights
541236 CT Tech Petoskey MICHIGAN 12 Hour Nights
547275 CT Tech Syracuse NEW YORK 12 Hour Nights
547389 CT Tech Cleveland OHIO 8 Hour Nights
540747 CT Tech SANTA CRUZ CALIFORNIA 8 Hour Day/Night Rotate
543757 CT Tech Lynwood CALIFORNIA 12 Hour Days
544228 CT Tech Denville NEW JERSEY 12 Hour Day/Night Rotate
535179 CT Tech Columbus OHIO 12 Hour Days
546317 CT Tech ODESSA TEXAS 12 Hour Days
534972 CT Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
545490 CT Tech Farmington CONNECTICUT 8 Hour Nights
546787 CT Tech Robinson ILLINOIS 8 Hour Evenings
546966 CT Tech Silverdale WASHINGTON 10 Hour Nights
537185 CT Tech Syracuse NEW YORK Nights
540864 CT Tech Pigeon MICHIGAN 12 Hour Nights
543801 CT Tech Long Prairie MINNESOTA 12 Hour Days
544343 CT Tech Boise IDAHO 10 Hour Nights
526794 CT Tech Silver Spring MARYLAND 10 Hour Nights
536752 CT Tech Roseburg OREGON 12 Hour Nights
525235 CT Tech Oceanside CALIFORNIA 10 Hour Days
544409 CT Tech Springfield VERMONT 8 Hour Nights
547436 CT Tech Olympia WASHINGTON 12 Hour Nights
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
533177 CT Tech Roseburg OREGON 8 Hour Days
524667 CT Tech Baker City OREGON 8 Hour Nights
524703 CT Tech Pontiac MICHIGAN 8 Hour Nights
545887 CT Tech Hereford TEXAS 8 Hour Days
520291 CT Tech Oceanside CALIFORNIA 10 Hour Days
538591 CT Tech Ann Arbor MICHIGAN 12 Hour Days
543040 CT Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
547244 CT Tech Birmingham ALABAMA 10 Hour Nights
547277 CT Tech Sioux City IOWA 10 Hour Nights
545257 CT Tech Roseburg OREGON 10 Hour Nights
540278 CT Tech Concord CALIFORNIA 10 Hour Nights
539629 CT Tech Cleveland OHIO 8 Hour Nights
546352 CT Tech Manteca CALIFORNIA 8 Hour Days
538400 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
531609 CT Tech Jackson MISSISSIPPI 8 Hour Nights
538402 CT Tech Bellefontaine OHIO 12 Hour Nights
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
543343 CT Tech Staten Island NEW YORK 8 Hour Days
546403 CT Tech Mount Airy NORTH CAROLINA 12 Hour Nights
538435 CT Tech Harvard ILLINOIS 8 Hour Evenings
544514 CT Tech Vernon Rockville CONNECTICUT 8 Hour Nights
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
545390 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
547482 CT Tech Rockingham NORTH CAROLINA 12 Hour Nights
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
545217 CT Tech York MAINE Days
547007 CT Tech Maryville ILLINOIS 12 Hour Nights
544775 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
547068 CT Tech Pella IOWA 12 Hour Nights
545392 CT Tech Anchorage ALASKA 12 Hour Days
542160 CT Tech Lynwood CALIFORNIA 12 Hour Day/Night Rotate
538911 CT Tech Alturas CALIFORNIA 8 Hour Varied
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.6312 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 100,100 in 1.2892 seconds