Listing all records

Displaying records 2301 through 2400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
542380 PT SANTA ROSA CALIFORNIA 8 Hour Days
542424 PT Norwalk IOWA Days
542427 PT Lakeport CALIFORNIA Varied
542497 PT Clovis NEW MEXICO 8 Hour Days
542657 PT Middletown OHIO Days
547806 PT Mammoth Lakes CALIFORNIA Days
548026 PT Escondido CALIFORNIA 8 Hour Days
542701 PT Athens GEORGIA 8 Hour Days
542734 PT Hayward CALIFORNIA 8 Hour Days
542873 PT Monterey CALIFORNIA Days
543047 PT thermopolis WYOMING Days
543293 PT Hudson FLORIDA Days
543406 PT Palm Springs CALIFORNIA 8 Hour Days
543407 PT Palm Springs CALIFORNIA 8 Hour Days
543468 PT Athens GEORGIA 8 Hour Days
547867 PT Winter Park FLORIDA Days
546783 PT Salinas CALIFORNIA 8 Hour Days PT/Physical Therapist
546283 PT Hayward CALIFORNIA 8 Hour Days
546032 PT San Jose CALIFORNIA 10 Hour Days
543897 PT Naples FLORIDA Varied
543904 PT Crescent City CALIFORNIA 8 Hour Days
544167 PT Garden City KANSAS 12 Hour Day/Night Rotate
544192 PT Wrangell ALASKA Varied
544444 PT Santa Clara CALIFORNIA 10 Hour Days
544504 PT Everett WASHINGTON 8 Hour Days
544641 PT Monterey CALIFORNIA Days
547950 PT Staples MINNESOTA 8 Hour Days
547949 PT Philadelphia PENNSYLVANIA Varied
547951 PT Staples MINNESOTA 8 Hour Days
546645 PT San Ramon CALIFORNIA Days
546644 PT San Ramon CALIFORNIA Days
544911 PT Apple Valley CALIFORNIA 10 Hour Days
544912 PT Apple Valley CALIFORNIA 10 Hour Days
544915 PT Mission Hills CALIFORNIA 8 Hour Days
544972 PT Garden City KANSAS Varied
544990 PT Buckeye WEST VIRGINIA 8 Hour Days
546646 PT San Ramon CALIFORNIA Days
545066 PT Newport OREGON 8 Hour Days
545111 PT Salem OREGON Days
545112 PT Salem OREGON Days
546423 PT Hayward CALIFORNIA 8 Hour Days
545317 PT SANTA ROSA CALIFORNIA 8 Hour Days
545331 PT Sumter SOUTH CAROLINA Days
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
545552 PT Wilton CONNECTICUT Varied
547099 PT Laurinburg NORTH CAROLINA 8 Hour Days
546014 PT Bolivar MISSOURI 8 Hour Days
547271 PT GRAND MARAIS MINNESOTA Varied
547305 PT Plains MONTANA Varied
546035 PT Burbank CALIFORNIA 8 Hour Days
547352 PT Falls City NEBRASKA 8 Hour Days
547351 PT Falls City NEBRASKA 8 Hour Days
547485 PT Union City CALIFORNIA 8 Hour Days
546036 PT Burbank CALIFORNIA 8 Hour Days
545950 PT Sunnyvale CALIFORNIA Days
545951 PT Sunnyvale CALIFORNIA Days
523059 CVOR Tech Los Angeles CALIFORNIA 10 Hour Days CST/Certified Surgical Technician
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
541891 Telemetry Farmington CONNECTICUT 12 Hour Nights
524989 Telemetry Maywood ILLINOIS 12 Hour Nights
527493 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
526356 Telemetry Boise IDAHO 12 Hour Nights
546976 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
534901 Telemetry Boise IDAHO 12 Hour Nights
534902 Telemetry Boise IDAHO 12 Hour Nights
534903 Telemetry Boise IDAHO 12 Hour Nights
534904 Telemetry Boise IDAHO 12 Hour Nights
540063 Telemetry Farmington CONNECTICUT 12 Hour Nights
540065 Telemetry Farmington CONNECTICUT 12 Hour Days
540107 Telemetry Concord CALIFORNIA 12 Hour Nights
540113 Telemetry Concord CALIFORNIA 12 Hour Nights
540150 Telemetry Concord CALIFORNIA 12 Hour Days
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
546904 Telemetry Cleveland OHIO 12 Hour Nights
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
540226 Telemetry Concord CALIFORNIA 12 Hour Days
544116 Telemetry Cleveland OHIO 12 Hour Nights
548217 Telemetry New York NEW YORK 12 Hour Days RN/Registered Nurse
546844 Telemetry Farmington CONNECTICUT 12 Hour Days
546859 Telemetry Everett WASHINGTON 12 Hour Nights
547931 Telemetry Brownsville TEXAS 12 Hour Days
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
544525 Telemetry Wailuku HAWAII 12 Hour Nights
546898 Telemetry Cleveland OHIO 12 Hour Nights
546899 Telemetry Spokane WASHINGTON 12 Hour Nights
546902 Telemetry Cleveland OHIO 12 Hour Nights
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
544954 Telemetry Twin Falls IDAHO 12 Hour Nights
544955 Telemetry Twin Falls IDAHO 12 Hour Days
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
545165 Telemetry Cleveland OHIO 12 Hour Nights
545227 Telemetry Cleveland OHIO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545229 Telemetry Cleveland OHIO 12 Hour Nights
545230 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
546977 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
545502 Telemetry Boise IDAHO 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.6243 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 2300,100 in 1.3174 seconds