Listing all records

Displaying records 1301 through 1400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547324 Telemetry Portland OREGON 12 Hour Nights
548024 Telemetry Cleveland OHIO 12 Hour Nights
539751 Telemetry Boise IDAHO 12 Hour Nights
545165 Telemetry Cleveland OHIO 12 Hour Nights
540003 Telemetry Farmington CONNECTICUT 12 Hour Days
540011 Telemetry Farmington CONNECTICUT 12 Hour Nights
544031 Telemetry Portland OREGON 12 Hour Nights
540040 Telemetry Farmington CONNECTICUT 12 Hour Days
543309 Telemetry Farmington CONNECTICUT 12 Hour Nights
540063 Telemetry Farmington CONNECTICUT 12 Hour Nights
540065 Telemetry Farmington CONNECTICUT 12 Hour Days
546742 Telemetry Charleston WEST VIRGINIA 12 Hour Nights
540107 Telemetry Concord CALIFORNIA 12 Hour Nights
540113 Telemetry Concord CALIFORNIA 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
540150 Telemetry Concord CALIFORNIA 12 Hour Days
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
540226 Telemetry Concord CALIFORNIA 12 Hour Days
540261 Telemetry Concord CALIFORNIA 12 Hour Nights
545227 Telemetry Cleveland OHIO 12 Hour Nights
545230 Telemetry Cleveland OHIO 12 Hour Nights
540323 Telemetry Concord CALIFORNIA 12 Hour Nights
546899 Telemetry Spokane WASHINGTON 12 Hour Nights
540342 Telemetry Concord CALIFORNIA 12 Hour Days
540349 Telemetry Concord CALIFORNIA 12 Hour Nights
540529 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
540569 Telemetry Farmington CONNECTICUT 12 Hour Nights
544955 Telemetry Twin Falls IDAHO 12 Hour Days
543465 Telemetry Wailuku HAWAII 12 Hour Nights
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
540745 Telemetry Prescott ARIZONA 12 Hour Day/Night Rotate
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
540770 Telemetry Prescott ARIZONA 12 Hour Days
546976 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
545503 Telemetry Boise IDAHO 12 Hour Nights
543038 Telemetry San Diego CALIFORNIA 12 Hour Day/Night Rotate
541117 Telemetry Farmington CONNECTICUT 12 Hour Nights
546844 Telemetry Farmington CONNECTICUT 12 Hour Days
547308 Telemetry Nampa IDAHO 12 Hour Nights
541381 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
547311 Telemetry Twin Falls IDAHO 12 Hour Days
546725 Telemetry Everett WASHINGTON 12 Hour Nights
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
543215 Telemetry Cleveland OHIO 12 Hour Nights
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
542615 Telemetry Terre Haute INDIANA 12 Hour Nights
542653 Telemetry Charleston SOUTH CAROLINA 12 Hour Nights
548342 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
548348 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
523059 CVOR Tech Los Angeles CALIFORNIA 10 Hour Days CST/Certified Surgical Technician
460916 PT Lawton OKLAHOMA 8 Hour Days
472729 PT Holyoke MASSACHUSETTS Days
475928 PT Lewiston IDAHO Days
476614 PT Crownsville MARYLAND Days
547869 PT Savannah GEORGIA Days
492900 PT Lancaster MASSACHUSETTS Days
504432 PT Honolulu HAWAII Days
505340 PT San Jose CALIFORNIA Days
518254 PT Cleburne TEXAS Varied
541860 PT Lovington NEW MEXICO 8 Hour Days
548029 PT Goldendale WASHINGTON Days
544990 PT Buckeye WEST VIRGINIA 8 Hour Days
524261 PT San Ramon CALIFORNIA Days
525066 PT Mason City IOWA 8 Hour Days
525843 PT Elizabeth WEST VIRGINIA 8 Hour Days PT/Physical Therapist
526505 PT Plains MONTANA Varied
526586 PT Lewiston IDAHO Days
546783 PT Salinas CALIFORNIA 8 Hour Days PT/Physical Therapist
545951 PT Sunnyvale CALIFORNIA Days
544167 PT Garden City KANSAS 12 Hour Day/Night Rotate
547271 PT GRAND MARAIS MINNESOTA Varied
533274 PT Lawton OKLAHOMA Days
533275 PT Lawton OKLAHOMA Days
546234 PT Blountstown FLORIDA Days
533767 PT Bessemer ALABAMA Varied
547135 PT Lufkin TEXAS 8 Hour Days
533910 PT Hayward CALIFORNIA 8 Hour Days
543047 PT thermopolis WYOMING Days
547833 PT Farmington CONNECTICUT 8 Hour Days
534504 PT Raritan NEW JERSEY Days
534706 PT King City CALIFORNIA Days
534713 PT Redding CALIFORNIA 8 Hour Days
534923 PT thermopolis WYOMING Days
534924 PT thermopolis WYOMING Days
534999 PT Kerrville TEXAS Days
535174 PT San Francisco CALIFORNIA 8 Hour Days
535556 PT Athens GEORGIA 8 Hour Days
535640 PT NORTHRIDGE CALIFORNIA 8 Hour Days
547056 PT Sacramento CALIFORNIA 8 Hour Days
547949 PT Philadelphia PENNSYLVANIA Varied
547951 PT Staples MINNESOTA 8 Hour Days
547806 PT Mammoth Lakes CALIFORNIA Days
547867 PT Winter Park FLORIDA Days
546191 PT Crescent City CALIFORNIA Varied
544911 PT Apple Valley CALIFORNIA 10 Hour Days
544972 PT Garden City KANSAS Varied
543468 PT Athens GEORGIA 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.7765 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 1300,100 in 1.6237 seconds