Listing all records

Displaying records 3601 through 3700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547957 OR Mesquite TEXAS 8 Hour Days
547918 ER Des Moines IOWA 12 Hour Nights
547919 ER Des Moines IOWA 12 Hour Days
547920 ER Des Moines IOWA 12 Hour Days
547921 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
547922 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
547923 OR Muskegon MICHIGAN 10 Hour Days
547924 ICU Boise IDAHO 12 Hour Nights
547925 ICU Boise IDAHO 12 Hour Nights
547926 Med Surg Boise IDAHO 12 Hour Nights
547927 Med Surg Boise IDAHO 12 Hour Nights
547928 Cath Lab Lexington KENTUCKY 8 Hour Days
547929 L&D San Antonio TEXAS 12 Hour Nights
547930 ER Brownsville TEXAS 12 Hour Nights
547931 Telemetry Brownsville TEXAS 12 Hour Days
547933 Med Surg Anniston ALABAMA 12 Hour Nights
547936 CT Tech Morgantown WEST VIRGINIA 8 Hour Evenings
547938 Acute Care Mt. Vernon WASHINGTON 12 Hour Nights
547939 Radiation Therapy Twin Falls IDAHO 12 Hour Days
547940 Nuclear Med Technician Mission Viejo CALIFORNIA 8 Hour Days
547941 Med Surg Tele Vernon Rockville CONNECTICUT 12 Hour Nights
547942 PACU Sterling ILLINOIS 8 Hour Days
547945 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
547946 L&D Perryville MISSOURI 12 Hour Nights
547947 Echo Minneapolis MINNESOTA 8 Hour Days
547948 MLT Wolf Point MONTANA 8 Hour Days
547949 PT Philadelphia PENNSYLVANIA Varied
547950 PT Staples MINNESOTA 8 Hour Days
547951 PT Staples MINNESOTA 8 Hour Days
547952 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547953 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547954 L&D Cincinnati OHIO Days
547955 OR Madison WISCONSIN 10 Hour Day/Night Rotate
547956 Surgical Tech Glens Falls NEW YORK 10 Hour Days
547958 Cath Lab San Diego CALIFORNIA 8 Hour Days
547959 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547962 PICU Madison WISCONSIN 12 Hour Day/Night Rotate
547963 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
547964 Mammo Tech San Angelo TEXAS 8 Hour Days
547965 SLP Spanaway WASHINGTON Days
547966 LPN/LVN Spanaway WASHINGTON Days
547967 ER Madison WISCONSIN 12 Hour Day/Night Rotate
547969 Surgical Tech Auburn NEW YORK 10 Hour Days
547970 Pediatric ER Bronx NEW YORK Nights
547971 Acute Care Bronx NEW YORK Days
547972 Cardiac Telemetry Albany NEW YORK 12 Hour Nights
547973 Med Surg Oneonta NEW YORK 12 Hour Days
547974 CT Tech TOWNSHEND VERMONT Varied
547975 ER Goldendale WASHINGTON 12 Hour Nights
547977 ICU Memphis TENNESSEE 12 Hour Nights
547978 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547979 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547980 Med Surg Tele Lewiston MAINE 12 Hour Nights
547981 Med Surg Tele Lewiston MAINE 12 Hour Nights
547982 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547983 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547984 Home Health Portland OREGON 8 Hour Days
547985 Home Health Portland OREGON 8 Hour Days
547988 Intermediate Care Rumford MAINE 12 Hour Days
547989 Intermediate Care Rumford MAINE 12 Hour Days
547990 Cardiology Torrance CALIFORNIA 12 Hour Days
547991 Cardiology Torrance CALIFORNIA 12 Hour Days
547992 Case Manager Torrance CALIFORNIA 8 Hour Days
547994 Med Surg Tele Warrensville Heights OHIO 12 Hour Days
547995 Med Surg Tele Warrensville Heights OHIO 12 Hour Days
547996 Med Surg Perryville MISSOURI 12 Hour Days
547997 Med Surg Perryville MISSOURI 12 Hour Days
547998 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547999 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
548005 Med Surg Tele Des Moines IOWA 12 Hour Nights
548006 Med Surg Tele Des Moines IOWA 12 Hour Days
548007 Med Surg Tele Des Moines IOWA 12 Hour Days
548008 Respiratory Therapist Plains MONTANA Days
548009 RAD Tech Honolulu HAWAII 8 Hour Day/Night Rotate
548010 CT Tech Fort Bragg CALIFORNIA 12 Hour Day/Night Rotate
548011 SLP Crescent City CALIFORNIA 8 Hour Days
548012 PT Crescent City CALIFORNIA 8 Hour Days
548013 Outpatient Clinic Berlin NEW HAMPSHIRE 8 Hour Days
548014 Long Term Care Kane PENNSYLVANIA 12 Hour Nights
548015 CNA San Francisco CALIFORNIA 8 Hour Days
548016 CNA San Francisco CALIFORNIA 8 Hour Days
548018 MLT Aberdeen WASHINGTON 10 Hour Nights
548019 CNA Corvallis OREGON 12 Hour Day/Night Rotate
548020 MRI Tech Glenwood Springs COLORADO 12 Hour Varied
548021 PCU Abilene TEXAS 12 Hour Nights
548022 OT Rehab Rushville ILLINOIS Varied
548023 LPN/LVN Mullins SOUTH CAROLINA 12 Hour Nights
548024 Telemetry Cleveland OHIO 12 Hour Nights
548025 ICU Portland OREGON 12 Hour Nights
548026 PT Escondido CALIFORNIA 8 Hour Days
548027 PTA Escondido CALIFORNIA 8 Hour Days
548029 PT Goldendale WASHINGTON Days
548030 Sterile Processing Technician Wenatchee WASHINGTON 12 Hour Day/Night Rotate
548032 CT Tech Columbus OHIO 10 Hour Nights
548033 Med Surg Tele Des Moines IOWA 12 Hour Days
548034 ICU Newton IOWA 12 Hour Nights
548035 Echo Pagosa Springs COLORADO 8 Hour Days
548036 MLT New Bern NORTH CAROLINA 10 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.6812 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.title desc limit 3600,100 in 1.7907 seconds