Listing all records

Displaying records 1401 through 1500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
531763 PT Inman SOUTH CAROLINA Days
546255 PT Falls River MASSACHUSETTS 12 Hour Day/Night Rotate
546286 PT Hayward CALIFORNIA 8 Hour Days
532052 PT Carrizo Springs TEXAS Days
532057 PT San Ramon CALIFORNIA Days
532338 PT Ogden UTAH Days
546346 PT Nogales ARIZONA 8 Hour Days
532855 PT St Johnsbury VERMONT Varied
547950 PT Staples MINNESOTA 8 Hour Days
547833 PT Farmington CONNECTICUT 8 Hour Days
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
545951 PT Sunnyvale CALIFORNIA Days
546014 PT Bolivar MISSOURI 8 Hour Days
534504 PT Raritan NEW JERSEY Days
546646 PT San Ramon CALIFORNIA 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
545112 PT Salem OREGON Days
537738 PT Vidalia GEORGIA 12 Hour Days
545317 PT SANTA ROSA CALIFORNIA 8 Hour Days
547782 PT Indio CALIFORNIA 8 Hour Days
538087 PT Honolulu HAWAII 8 Hour Days
538132 PT Salisbury MISSOURI Days
546423 PT Hayward CALIFORNIA 8 Hour Days
538242 PT Lansing MICHIGAN 8 Hour Days
538243 PT Lansing MICHIGAN 8 Hour Days
546032 PT San Jose CALIFORNIA 10 Hour Days
538557 PT Orwigsburg PENNSYLVANIA Days
543904 PT Crescent City CALIFORNIA 8 Hour Days
538599 PT Springfield PENNSYLVANIA Days
547806 PT Mammoth Lakes CALIFORNIA Days
545066 PT Newport OREGON 8 Hour Days
547730 PT Bolivar MISSOURI 8 Hour Days
539089 PT Fort Dodge IOWA 8 Hour Days
546783 PT Salinas CALIFORNIA 8 Hour Days PT/Physical Therapist
547099 PT Laurinburg NORTH CAROLINA 8 Hour Days
539306 PT Sunnyvale CALIFORNIA Days
539455 PT Athens GEORGIA 8 Hour Days
547951 PT Staples MINNESOTA 8 Hour Days
546287 PT Hamilton NEW JERSEY 8 Hour Days
544504 PT Everett WASHINGTON 8 Hour Days
546644 PT San Ramon CALIFORNIA Days
547271 PT GRAND MARAIS MINNESOTA Varied
548026 PT Escondido CALIFORNIA 8 Hour Days
546645 PT San Ramon CALIFORNIA Days
548029 PT Goldendale WASHINGTON Days
545950 PT Sunnyvale CALIFORNIA Days
546886 PT Globe ARIZONA Days
546035 PT Burbank CALIFORNIA 8 Hour Days
546036 PT Burbank CALIFORNIA 8 Hour Days
544911 PT Apple Valley CALIFORNIA 10 Hour Days
546220 PT Crescent City CALIFORNIA 8 Hour Days
547305 PT Plains MONTANA Varied
545331 PT Sumter SOUTH CAROLINA Days
547485 PT Union City CALIFORNIA 8 Hour Days
544990 PT Buckeye WEST VIRGINIA 8 Hour Days
547867 PT Winter Park FLORIDA Days
546283 PT Hayward CALIFORNIA 8 Hour Days
546191 PT Crescent City CALIFORNIA Varied
545552 PT Wilton CONNECTICUT Varied
541105 PT Estes Park COLORADO 12 Hour Day/Night Rotate
543897 PT Naples FLORIDA Varied
541550 PT Apple Valley CALIFORNIA 8 Hour Days
541551 PT Apple Valley CALIFORNIA 8 Hour Days
544192 PT Wrangell ALASKA Varied
541610 PT Hesperia CALIFORNIA 8 Hour Days
541627 PT Butte MONTANA Days
541652 PT SANTA ROSA CALIFORNIA 8 Hour Days
542958 PT San Jose CALIFORNIA 10 Hour Days
541705 PT Eureka CALIFORNIA 8 Hour Days
541750 PT Union City CALIFORNIA 8 Hour Days
542085 PT Oneonta NEW YORK 8 Hour Days
546321 PT Mission Hills CALIFORNIA 8 Hour Days
544915 PT Mission Hills CALIFORNIA 8 Hour Days
547445 PT Seguin TEXAS 8 Hour Days
542380 PT SANTA ROSA CALIFORNIA 8 Hour Days
542424 PT Norwalk IOWA Days
542427 PT Lakeport CALIFORNIA Varied
546282 PT Hayward CALIFORNIA 8 Hour Days
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
542497 PT Clovis NEW MEXICO 8 Hour Days
547697 PT Norristown PENNSYLVANIA Days
542657 PT Middletown OHIO Days
545111 PT Salem OREGON 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
544444 PT Santa Clara CALIFORNIA 10 Hour Days
543293 PT Hudson FLORIDA 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.5208 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 1400,100 in 1.3446 seconds