Listing all records

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

ID Job Specialty City State Shift Title
548018 MLT Aberdeen WASHINGTON 10 Hour Nights
547100 Therapy Rehab Abbeville SOUTH CAROLINA 8 Hour Days
546703 CT Tech Kremmling COLORADO 12 Hour Days
536307 MRI Tech Janesville WISCONSIN 8 Hour Days
538434 Nuclear Med Technician Janesville WISCONSIN 8 Hour Days
538892 Med Surg Janesville WISCONSIN 12 Hour Nights
543041 Oncology Janesville WISCONSIN Varied
543454 Home Health Fargo NORTH DAKOTA 8 Hour Day/Night Rotate
531244 ICU   CALIFORNIA 12 Hour Days RN/Registered Nurse
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.7549 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 desc limit 3700,100 in 1.981 seconds