Listing all records

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

ID Job Specialty City State Shift Title
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
547302 MLT York MAINE 8 Hour Day/Night Rotate
547427 ICU York MAINE 12 Hour Nights
542049 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days
543822 Certified Surgical Tech York MAINE 8 Hour Days
548195 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days CST/Certified Surgical Technician
479983 PT YUBA CITY CALIFORNIA Days
547815 Scrub Tech Yuma COLORADO 12 Hour Nights
547708 Surgical Tech CVOR Zanesville OHIO 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.6731 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 z.city asc limit 3700,100 in 1.5057 seconds