Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
538580 Echo Technologist Columbia MISSOURI Days
542657 PT Middletown OHIO Days
541443 COTA Towson MARYLAND Days
531884 PTA Avoca IOWA Days
528446 PTA Killeen TEXAS Days
472544 PT E Lamberton MINNESOTA Days
472729 PT Holyoke MASSACHUSETTS Days
474328 PT North Manchester INDIANA Days
475928 PT Lewiston IDAHO Days
476614 PT Crownsville MARYLAND Days
484788 PTA Merced CALIFORNIA Days
538132 PT Salisbury MISSOURI Days
491571 Therapy Rehab E Lamberton MINNESOTA Days
492900 PT Lancaster MASSACHUSETTS Days
534700 Therapy Rehab Lewiston IDAHO Days
495103 SLP South Bend INDIANA Days
496231 COTA Oakhurst CALIFORNIA Days
528482 SLP Fresno CALIFORNIA Days
542780 SLP Oakhurst CALIFORNIA Days
532920 Oncology San Angelo TEXAS Days
527231 PT North Kingstown RHODE ISLAND Days
539306 PT Sunnyvale CALIFORNIA Days
544290 Infusion Oncology Sidney MONTANA Days
526144 Therapy Rehab Baltimore MARYLAND Days
534999 PT Kerrville TEXAS Days
542847 SLP Oakland NEW JERSEY Days
504432 PT Honolulu HAWAII Days
505339 PTA San Jose CALIFORNIA Days
505340 PT San Jose CALIFORNIA Days
505341 OT Rehab San Jose CALIFORNIA Days
505342 OT Rehab San Jose CALIFORNIA Days
532338 PT Ogden UTAH Days
535268 COTA San Andreas CALIFORNIA Days
527125 Therapy Rehab Shelby MISSISSIPPI Days
531994 Physician New Lisbon WISCONSIN Days
514085 Therapy Rehab Sparks NEVADA Days
532052 PT Carrizo Springs TEXAS Days
514692 SLP Spanaway WASHINGTON Days
514696 Therapy Rehab Spanaway WASHINGTON Days
541984 Med Surg New York NEW YORK Days
515247 PT Hanford CALIFORNIA Days
515505 PT Scranton SOUTH CAROLINA Days
516484 PT Hot Springs VIRGINIA Days
528504 SLP Juneau ALASKA Days
543911 COTA Hanford CALIFORNIA Days
534923 PT thermopolis WYOMING Days
516937 SLP Roseburg OREGON Days
517267 PT Kapaau HAWAII Days
517269 PT Kapaau HAWAII Days
534971 Administration Kealakekua HAWAII Days
534629 SLP Pomona CALIFORNIA Days
517691 SLP Vernon CONNECTICUT Days
538557 PT Orwigsburg PENNSYLVANIA Days
543046 Histology Technician Watertown NEW YORK Days
535216 Mammo Tech Juneau ARKANSAS Days
535269 COTA San Andreas CALIFORNIA Days
518165 Endoscopy IOWA CITY IOWA Days
518534 COTA NEWMAN CALIFORNIA Days
535270 PTA Modesto CALIFORNIA Days
538599 PT Springfield PENNSYLVANIA Days
535271 PTA Modesto CALIFORNIA Days
538717 Surgical Tech Columbus OHIO Days
528615 SLP Salisbury NORTH CAROLINA Days
535536 CNA Cincinnati OHIO Days
529033 PT San Ramon CALIFORNIA Days
538440 COTA Monterey CALIFORNIA Days
528766 PT Sparks NEVADA Days
542462 SLP Williamstown NEW JERSEY Days
543977 Sterile Processing Tech Lamar COLORADO Days
534093 SLP Freehold NEW JERSEY Days
527092 PT Boardman OHIO Days
540589 MLT Watertown NEW YORK Days
527223 PTA Hayward CALIFORNIA Days
539310 Speech Language Roseburg OREGON Days
527222 PT Freemont CALIFORNIA Days
527324 PT Palm Springs CALIFORNIA Days
541627 PT Butte MONTANA Days
521294 Ultrasound Tech Bethel ALASKA Days
534504 PT Raritan NEW JERSEY Days
532598 PTA Hanford CALIFORNIA Days
527487 PTA North Providence RHODE ISLAND Days
533274 PT Lawton OKLAHOMA Days
533521 PTA Belton TEXAS Days
533275 PT Lawton OKLAHOMA Days
537785 SLP Fargo NORTH DAKOTA Days
543178 Neuro Intensive Care New York NEW YORK Days
522368 Clinic Bethel ALASKA Days
522372 PT Weaverville CALIFORNIA Days
522373 LPN/LVN Bethel ALASKA Days
542353 Therapy Rehab Inman SOUTH CAROLINA Days
534628 SLP Pomona CALIFORNIA Days
523531 PTA Oakland NEW JERSEY Days
523666 PTA Freemont CALIFORNIA Days
523668 PT Oakland CALIFORNIA Days
523669 PT San Rafael CALIFORNIA Days
534924 PT thermopolis WYOMING Days
534706 PT King City CALIFORNIA Days
524151 PTA Ramsey NEW JERSEY Days
524261 PT San Ramon CALIFORNIA Days
524265 PTA San Ramon CALIFORNIA 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.5578 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 100,100 in 1.6837 seconds