Listing all records

Displaying records 401 through 500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
541829 RAD Tech CHANDLER ARIZONA 12 Hour Day/Night Rotate
527789 RAD Tech Oceanside CALIFORNIA 8 Hour Days
545672 RAD Tech Gainesville FLORIDA 12 Hour Days
547797 RAD Tech Columbus OHIO 8 Hour Days
545541 RAD Tech Columbus OHIO 8 Hour Nights
542986 RAD Tech Tuba City ARIZONA 12 Hour Day/Night Rotate
547702 RAD Tech Oklahoma City OKLAHOMA 12 Hour Nights
547648 RAD Tech Dothan ALABAMA 8 Hour Days
538598 RAD Tech IOWA CITY IOWA Varied
545486 RAD Tech Florence SOUTH CAROLINA 8 Hour Days
529591 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
529597 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
543060 RAD Tech Toppenish WASHINGTON 8 Hour Days
545564 RAD Tech Peoria ILLINOIS 8 Hour Days
545570 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
548009 RAD Tech Honolulu HAWAII 8 Hour Day/Night Rotate
547809 RAD Tech Cleveland OHIO 8 Hour Days
531151 RAD Tech Farmington CONNECTICUT 8 Hour Days Radiology Techs/Technologists
545571 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
543703 RAD Tech Commerce Twp MICHIGAN 8 Hour Nights
545691 RAD Tech Gainesville FLORIDA 10 Hour Days
543312 RAD Tech Denville NEW JERSEY Nights
540012 RAD Tech Farmington CONNECTICUT 10 Hour Evenings
532201 RAD Tech Louisville KENTUCKY 8 Hour Days
543286 RAD Tech Lynwood CALIFORNIA 8 Hour Nights
547119 RAD Tech REDWOOD CITY CALIFORNIA 8 Hour Days
532202 RAD Tech Louisville KENTUCKY 8 Hour Days
545772 RAD Tech Gainesville FLORIDA 10 Hour Days
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
543790 RAD Tech Oceanside CALIFORNIA 8 Hour Days
543778 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
545411 RAD Tech Rockville MARYLAND 8 Hour Days
533260 RAD Tech Des Moines IOWA 10 Hour Days
539836 RAD Tech Seattle WASHINGTON 8 Hour Days
546682 RAD Tech Lexington KENTUCKY 10 Hour Days
544202 RAD Tech Dubuque IOWA 8 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
544012 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
545154 RAD Tech Lebanon NEW HAMPSHIRE 12 Hour Nights
544241 RAD Tech Reno NEVADA 12 Hour Days
534109 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
545600 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
545783 RAD Tech Gainesville FLORIDA 10 Hour Evenings
547799 RAD Tech Pontiac MICHIGAN 8 Hour Nights
547876 RAD Tech Pontiac MICHIGAN 8 Hour Evenings
547798 RAD Tech Columbus OHIO 8 Hour Days
543783 RAD Tech Redding CALIFORNIA 8 Hour Days
546389 RAD Tech Greenville SOUTH CAROLINA 8 Hour Days
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
543183 Surgical Tech Athens GEORGIA 8 Hour Days
496817 Surgical Tech Peterborough NEW HAMPSHIRE 8 Hour Days
548272 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
548245 Surgical Tech Gilbert ARIZONA 12 Hour Nights RN/Registered Nurse
544234 Surgical Tech Denville NEW JERSEY 12 Hour Days
506863 Surgical Tech Durham NORTH CAROLINA 10 Hour Days
536253 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540039 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
517294 Surgical Tech Oceanside CALIFORNIA 10 Hour Days
542573 Surgical Tech Louisville KENTUCKY 12 Hour Days
543630 Surgical Tech Stafford Springs CONNECTICUT 8 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
544604 Surgical Tech Duluth MINNESOTA 12 Hour Day/Night Rotate
521665 Surgical Tech Louisville KENTUCKY 12 Hour Day/Night Rotate
540180 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
540014 Surgical Tech Farmington CONNECTICUT 10 Hour Days
540018 Surgical Tech Farmington CONNECTICUT 8 Hour Days
524748 Surgical Tech Boise IDAHO 10 Hour Days
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
544994 Surgical Tech Kearney NEBRASKA 8 Hour Days
545763 Surgical Tech Gainesville FLORIDA 12 Hour Days
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
543184 Surgical Tech Athens GEORGIA 8 Hour Days
543370 Surgical Tech Silver Spring MARYLAND Nights
531502 Surgical Tech Muskegon MICHIGAN 12 Hour Nights
539151 Surgical Tech Fresno CALIFORNIA 10 Hour Days
540163 Surgical Tech Concord CALIFORNIA 8 Hour Evenings
540287 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
546951 Surgical Tech Long Beach CALIFORNIA 12 Hour Nights
547837 Surgical Tech Honolulu HAWAII 8 Hour Day/Night Rotate
544263 Surgical Tech Westerville OHIO 12 Hour Days
547662 Surgical Tech Omaha NEBRASKA 8 Hour Days
534167 Surgical Tech Centerville IOWA 8 Hour Days
544345 Surgical Tech Ketchum IDAHO 12 Hour Days
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
545665 Surgical Tech Gainesville FLORIDA 12 Hour Days
535030 Surgical Tech Louisville KENTUCKY 12 Hour Days
547189 Surgical Tech Brooklyn NEW YORK 8 Hour Nights
547036 Surgical Tech Falls Church VIRGINIA 8 Hour Day/Night Rotate
540136 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
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.6925 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 400,100 in 1.565 seconds