Listing all records

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

ID Job Specialty City State Shift Title
547899 CNA Lovell WYOMING 12 Hour Days
534923 PT thermopolis WYOMING Days
534924 PT thermopolis WYOMING Days
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
548147 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
543047 PT thermopolis WYOMING Days
545440 OT Rehab thermopolis WYOMING 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.6928 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 asc limit 3700,100 in 2.081 seconds