Listing all records

Displaying records 201 through 300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547539 Case Manager Vail COLORADO Days
543047 PT thermopolis WYOMING Days
547564 Echo Technologist Cape Girardeau MISSOURI Days
547580 Therapy Rehab Helena MONTANA Days
532338 PT Ogden UTAH Days
546770 Surgical Tech IOWA CITY IOWA Days
520208 PT NEWMAN CALIFORNIA Days
544489 CT Tech Culbertson MONTANA Days
547708 Surgical Tech CVOR Zanesville OHIO Days
529926 SLP Grand Junction COLORADO Days
532598 PTA Hanford CALIFORNIA Days
542826 Surgical Tech Boise IDAHO Days
521294 Ultrasound Tech Bethel ALASKA Days
541984 Med Surg New York NEW YORK Days
538717 Surgical Tech Columbus OHIO Days
545314 Interventional Radiology SANTA ROSA CALIFORNIA Days
541627 PT Butte MONTANA Days
538557 PT Orwigsburg PENNSYLVANIA Days
532920 Oncology San Angelo TEXAS Days
538599 PT Springfield PENNSYLVANIA Days
547392 Cath Lab Cleveland OHIO Days
522368 Clinic Bethel ALASKA Days
522372 PT Weaverville CALIFORNIA Days
522373 LPN/LVN Bethel ALASKA Days
545950 PT Sunnyvale CALIFORNIA Days
534706 PT King City CALIFORNIA Days
543911 COTA Hanford CALIFORNIA Days
544947 Cath Lab Johnson City TENNESSEE Days
545440 OT Rehab thermopolis WYOMING Days
534971 Administration Kealakekua HAWAII Days
523531 PTA Oakland NEW JERSEY Days
523666 PTA Freemont CALIFORNIA Days
523668 PT Oakland CALIFORNIA Days
523669 PT San Rafael CALIFORNIA Days
539310 Speech Language Roseburg OREGON Days
545339 APRN Plymouth WISCONSIN Days
545111 PT Salem OREGON Days
524151 PTA Ramsey NEW JERSEY Days
524261 PT San Ramon CALIFORNIA Days
524265 PTA San Ramon CALIFORNIA Days
545951 PT Sunnyvale CALIFORNIA Days
545082 Vascular Ultrasound Tech Artesia NEW MEXICO Days
542424 PT Norwalk IOWA Days
547887 CT Tech McCall IDAHO Days
545217 CT Tech York MAINE Days
531489 PT Ramsey NEW JERSEY Days
545331 PT Sumter SOUTH CAROLINA Days
545371 Step Down Cincinnati OHIO Days
546886 PT Globe ARIZONA Days
547883 PTA Daly City CALIFORNIA Days
540565 Cath Lab Cape Girardeau MISSOURI Days
547869 PT Savannah GEORGIA Days
542873 PT Monterey CALIFORNIA Days
531219 PT Williamstown NEW JERSEY Days
546422 Surgical Tech Columbus OHIO Days
530585 PTA Yeadon PENNSYLVANIA Days
542822 Therapy Rehab Cheraw SOUTH CAROLINA Days
546234 PT Blountstown FLORIDA Days
540589 MLT Watertown NEW YORK Days
534093 SLP Freehold NEW JERSEY Days
526144 Therapy Rehab Baltimore MARYLAND Days
534504 PT Raritan NEW JERSEY Days
543900 CT Tech Culbertson MONTANA Days
526368 COTA Colfax WISCONSIN Days
526396 Therapy Rehab Cedar Falls IOWA Days
526586 PT Lewiston IDAHO Days
546644 PT San Ramon CALIFORNIA Days
533274 PT Lawton OKLAHOMA Days
546645 PT San Ramon CALIFORNIA Days
534924 PT thermopolis WYOMING Days
546767 PTA Charlton MASSACHUSETTS Days
547519 Hospice Amarillo TEXAS Days
527092 PT Boardman OHIO Days
527125 Therapy Rehab Shelby MISSISSIPPI Days
541443 COTA Towson MARYLAND Days
527222 PT Freemont CALIFORNIA Days
527223 PTA Hayward CALIFORNIA Days
527231 PT North Kingstown RHODE ISLAND Days
527324 PT Palm Springs CALIFORNIA Days
543977 Sterile Processing Tech Lamar COLORADO Days
527487 PTA North Providence RHODE ISLAND Days
534999 PT Kerrville TEXAS Days
544485 SLP Danvers MASSACHUSETTS Days
535909 PT Blue Hill NEBRASKA Days
535270 PTA Modesto CALIFORNIA Days
535536 CNA Cincinnati OHIO Days
535889 PTA Essex MARYLAND Days
529353 PTA Harwich MASSACHUSETTS Days
532052 PT Carrizo Springs TEXAS Days
528446 PTA Killeen TEXAS Days
544403 First Assist Lancaster OHIO Days
528482 SLP Fresno CALIFORNIA Days
528504 SLP Juneau ALASKA Days
532057 PT San Ramon CALIFORNIA Days
544168 COTA Madera CALIFORNIA Days
528615 SLP Salisbury NORTH CAROLINA Days
528766 PT Sparks NEVADA Days
529033 PT San Ramon CALIFORNIA Days
546798 Interventional Radiology Tech IOWA CITY IOWA Days
529609 PT Low Moor VIRGINIA 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.5224 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.shift desc limit 200,100 in 1.1742 seconds