Listing all records

Displaying records 1501 through 1600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
542085 PT Oneonta NEW YORK 8 Hour 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
547951 PT Staples MINNESOTA 8 Hour Days
547271 PT GRAND MARAIS MINNESOTA Varied
542657 PT Middletown OHIO Days
542701 PT Athens GEORGIA 8 Hour Days
547305 PT Plains MONTANA Varied
542734 PT Hayward CALIFORNIA 8 Hour Days
546014 PT Bolivar MISSOURI 8 Hour Days
542873 PT Monterey CALIFORNIA Days
543897 PT Naples FLORIDA Varied
543047 PT thermopolis WYOMING Days
544912 PT Apple Valley CALIFORNIA 10 Hour Days
544915 PT Mission Hills CALIFORNIA 8 Hour Days
544911 PT Apple Valley CALIFORNIA 10 Hour Days
545552 PT Wilton CONNECTICUT Varied
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
544972 PT Garden City KANSAS Varied
543904 PT Crescent City CALIFORNIA 8 Hour Days
548012 PT Crescent City CALIFORNIA 8 Hour Days
546191 PT Crescent City CALIFORNIA Varied
546032 PT San Jose CALIFORNIA 10 Hour Days
545112 PT Salem OREGON Days
547057 OT Sacramento CALIFORNIA 8 Hour Days
547683 OT Athens GEORGIA 8 Hour Days
546807 OT Saranac Lake NEW YORK 8 Hour Days
546862 OT Syracuse NEW YORK 8 Hour Days
547607 OT Crescent City CALIFORNIA 8 Hour Days
547609 OT Garden City KANSAS 8 Hour Days
547608 OT Crescent City CALIFORNIA 8 Hour Days
484788 PTA Merced CALIFORNIA Days
501006 PTA Freehold NEW JERSEY Days
505339 PTA San Jose CALIFORNIA Days
519986 PTA Big Stone City SOUTH DAKOTA Varied
523531 PTA Oakland NEW JERSEY Days
523666 PTA Freemont CALIFORNIA Days
524151 PTA Ramsey NEW JERSEY Days
524265 PTA San Ramon CALIFORNIA Days
527223 PTA Hayward CALIFORNIA Days
527487 PTA North Providence RHODE ISLAND Days
528446 PTA Killeen TEXAS Days
529353 PTA Harwich MASSACHUSETTS Days
529430 PTA New Providence NEW JERSEY Days
530585 PTA Yeadon PENNSYLVANIA Days
546867 PTA Wilton CONNECTICUT Varied
531884 PTA Avoca IOWA Days
532598 PTA Hanford CALIFORNIA Days
533521 PTA Belton TEXAS Days
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
535270 PTA Modesto CALIFORNIA Days
535271 PTA Modesto CALIFORNIA Days
535889 PTA Essex MARYLAND Days
547883 PTA Daly City CALIFORNIA Days
539734 PTA Avoca IOWA Days
546110 PTA Clovis NEW MEXICO 8 Hour Days
546221 PTA Crescent City CALIFORNIA 8 Hour Day/Night Rotate
548027 PTA Escondido CALIFORNIA 8 Hour Days
542449 PTA Lakeport CALIFORNIA 8 Hour Days
543087 PTA Ukiah CALIFORNIA 8 Hour Days
546767 PTA Charlton MASSACHUSETTS Days
444999 PACU Bangor MAINE 12 Hour Days
516790 PACU Everett WASHINGTON 12 Hour Days
547942 PACU Sterling ILLINOIS 8 Hour Days
548257 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
548258 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
544158 PACU Cleveland OHIO 12 Hour Nights
546681 PACU Hot Springs ARKANSAS 8 Hour Days
546256 PACU Hilo HAWAII 12 Hour Day/Night Rotate
548017 PACU Chico CALIFORNIA 10 Hour Days
548061 PACU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
545684 PACU Gainesville FLORIDA 12 Hour Days
545303 PACU Farmington CONNECTICUT 10 Hour Days
540004 PACU Walnut Creek CALIFORNIA 12 Hour Days
540059 PACU Concord CALIFORNIA 10 Hour Days
540071 PACU Concord CALIFORNIA 12 Hour Days
540162 PACU Walnut Creek CALIFORNIA 12 Hour Days
540171 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540206 PACU Concord CALIFORNIA 10 Hour Days
540301 PACU Concord CALIFORNIA 10 Hour Days
540317 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540344 PACU Concord CALIFORNIA 12 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
543752 PACU Victorville CALIFORNIA 8 Hour Days
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
548306 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
541958 CVICU Spokane WASHINGTON 12 Hour Nights
525187 CVICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548276 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
546627 CVICU Madison WISCONSIN 8 Hour Day/Night Rotate
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
548295 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
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.5634 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 1500,100 in 1.825 seconds