Listing all records

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

ID Job Specialty City State Shift Title
547945 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
547972 Cardiac Telemetry Albany NEW YORK 12 Hour Nights
545613 EP Tech Mission Viejo CALIFORNIA 10 Hour Days
546609 EP Tech Pinehurst NORTH CAROLINA 10 Hour Days
548228 EP Tech Evanston ILLINOIS 8 Hour Days Advanced Practice
547900 Infection Prevention Specialist Seattle WASHINGTON 12 Hour Day/Night Rotate
547594 Urgent Care Corvallis OREGON 8 Hour Days
547875 Urgent Care Saratoga Springs NEW YORK 12 Hour Days
548203 Technician Hartford CONNECTICUT 8 Hour Days Tech/Technologist
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.5052 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.specialty asc limit 3700,100 in 1.4859 seconds