Listing all records

Displaying records 3701 through 3709 out of a total 3,709 records. Prev

ID Job Specialty City State Shift Title
547873 Endoscopy Columbia MISSOURI 8 Hour Varied
542578 Outpatient Clinic Chillicothe OHIO 10 Hour Varied
543729 OR Pella IOWA 10 Hour Varied
545020 OR Clarkston WASHINGTON 10 Hour Varied
545021 OR Clarkston WASHINGTON 10 Hour Varied
546884 Respiratory Therapist Sitka ALASKA 10 Hour Varied
547499 Cath Lab Pueblo COLORADO 10 Hour Varied
547834 Dialysis Tech Everett WASHINGTON 10 Hour Varied
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
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.379 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 asc limit 3700,100 in 1.4506 seconds