Listing all records

Displaying records 2201 through 2300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
523668 PT Oakland CALIFORNIA Days
523669 PT San Rafael CALIFORNIA 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
546036 PT Burbank CALIFORNIA 8 Hour Days
526505 PT Plains MONTANA Varied
547949 PT Philadelphia PENNSYLVANIA Varied
526586 PT Lewiston IDAHO Days
530463 PT Republic WASHINGTON Days
531219 PT Williamstown NEW JERSEY Days
545950 PT Sunnyvale CALIFORNIA Days
531489 PT Ramsey NEW JERSEY Days
546191 PT Crescent City CALIFORNIA Varied
531763 PT Inman SOUTH CAROLINA Days
532052 PT Carrizo Springs TEXAS Days
532057 PT San Ramon CALIFORNIA Days
532338 PT Ogden UTAH Days
546014 PT Bolivar MISSOURI 8 Hour Days
532855 PT St Johnsbury VERMONT Varied
533274 PT Lawton OKLAHOMA Days
533275 PT Lawton OKLAHOMA Days
533767 PT Bessemer ALABAMA Varied
547135 PT Lufkin TEXAS 8 Hour Days
533910 PT Hayward CALIFORNIA 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
538557 PT Orwigsburg PENNSYLVANIA Days
538599 PT Springfield PENNSYLVANIA Days
539089 PT Fort Dodge IOWA 8 Hour Days
539306 PT Sunnyvale CALIFORNIA Days
539455 PT Athens GEORGIA 8 Hour Days
546220 PT Crescent City CALIFORNIA 8 Hour Days
546646 PT San Ramon CALIFORNIA Days
546286 PT Hayward CALIFORNIA 8 Hour Days
546035 PT Burbank CALIFORNIA 8 Hour Days
547782 PT Indio CALIFORNIA 8 Hour Days
548012 PT Crescent City CALIFORNIA 8 Hour Days
542085 PT Oneonta NEW YORK 8 Hour Days
547485 PT Union City CALIFORNIA 8 Hour Days
547867 PT Winter Park FLORIDA Days
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
547869 PT Savannah GEORGIA Days
542657 PT Middletown OHIO Days
542701 PT Athens GEORGIA 8 Hour Days
542734 PT Hayward CALIFORNIA 8 Hour Days
545951 PT Sunnyvale CALIFORNIA 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
547951 PT Staples MINNESOTA 8 Hour Days
546032 PT San Jose CALIFORNIA 10 Hour Days
546234 PT Blountstown FLORIDA Days
547697 PT Norristown PENNSYLVANIA Days
543897 PT Naples FLORIDA Varied
543904 PT Crescent City CALIFORNIA 8 Hour Days
546255 PT Falls River MASSACHUSETTS 12 Hour Day/Night Rotate
544167 PT Garden City KANSAS 12 Hour Day/Night Rotate
544192 PT Wrangell ALASKA Varied
548026 PT Escondido CALIFORNIA 8 Hour Days
546283 PT Hayward CALIFORNIA 8 Hour Days
546282 PT Hayward CALIFORNIA 8 Hour Days
548172 PT Red Bluff CALIFORNIA 8 Hour Days RN/Registered Nurse
546645 PT San Ramon CALIFORNIA Days
546644 PT San Ramon CALIFORNIA Days
544444 PT Santa Clara CALIFORNIA 10 Hour Days
546287 PT Hamilton NEW JERSEY 8 Hour Days
544504 PT Everett WASHINGTON 8 Hour Days
547730 PT Bolivar MISSOURI 8 Hour Days
544641 PT Monterey CALIFORNIA Days
546321 PT Mission Hills CALIFORNIA 8 Hour Days
548029 PT Goldendale WASHINGTON 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
545066 PT Newport OREGON 8 Hour Days
545111 PT Salem OREGON Days
545112 PT Salem OREGON Days
546423 PT Hayward CALIFORNIA 8 Hour Days
547806 PT Mammoth Lakes CALIFORNIA Days
546346 PT Nogales ARIZONA 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
547833 PT Farmington CONNECTICUT 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.39 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 2200,100 in 1.5513 seconds