Listing all records

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

ID Job Specialty City State Shift Title
547244 CT Tech Birmingham ALABAMA 10 Hour Nights
547320 First Assist Opelika ALABAMA 8 Hour Days
547440 Electrophysiology Tech Birmingham ALABAMA 10 Hour Days
547648 RAD Tech Dothan ALABAMA 8 Hour Days
547933 Med Surg Anniston ALABAMA 12 Hour Nights
513720 PT Bessemer ALABAMA Varied
519750 Med Surg Montgomery ALABAMA 12 Hour Days
533767 PT Bessemer ALABAMA Varied
546167 Med Surg Tele Dothan ALABAMA 12 Hour Nights
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.7028 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 y.name desc limit 3700,100 in 1.733 seconds