Listing all records

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

ID Job Specialty City State Shift Title
548029 PT Goldendale WASHINGTON Days
548030 Sterile Processing Technician Wenatchee WASHINGTON 12 Hour Day/Night Rotate
548032 CT Tech Columbus OHIO 10 Hour Nights
548033 Med Surg Tele Des Moines IOWA 12 Hour Days
548034 ICU Newton IOWA 12 Hour Nights
548035 Echo Pagosa Springs COLORADO 8 Hour Days
548036 MLT New Bern NORTH CAROLINA 10 Hour Nights
548037 OR Laurinburg NORTH CAROLINA 8 Hour Days
548038 Telemetry BAKERSFIELD CALIFORNIA 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.7648 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.title desc limit 3700,100 in 1.6657 seconds