Listing all records

Displaying records 3301 through 3400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546128 Certified Surgical Tech Florence SOUTH CAROLINA 12 Hour Days
479108 SLP Spearfish SOUTH DAKOTA Days
519983 PT Big Stone City SOUTH DAKOTA 8 Hour Days
519986 PTA Big Stone City SOUTH DAKOTA Varied
519987 Therapy Rehab Big Stone City SOUTH DAKOTA 8 Hour Days
419839 Med Surg Bristol TENNESSEE 12 Hour Nights
542786 Step Down Kingsport TENNESSEE 12 Hour Nights
543820 Oncology Bristol TENNESSEE 12 Hour Nights
543938 Med Surg Kingsport TENNESSEE 12 Hour Days
533362 CNA Kingsport TENNESSEE 12 Hour Nights
539391 OR Bristol TENNESSEE 12 Hour Varied
539616 PCU Johnson City TENNESSEE 12 Hour Nights
539617 Pulmonary Johnson City TENNESSEE 12 Hour Nights
539618 PCU Johnson City TENNESSEE 12 Hour Days
539620 PCU Johnson City TENNESSEE 12 Hour Nights
539660 Long Term Care Greeneville TENNESSEE 12 Hour Nights
539703 Long Term Care Kingsport TENNESSEE 12 Hour Nights
544793 Cath Lab Bartlett TENNESSEE 8 Hour Days
544853 Med Surg Kingsport TENNESSEE 12 Hour Nights
544861 Dialysis Johnson City TENNESSEE 10 Hour Day/Night Rotate
544944 PCU Johnson City TENNESSEE 12 Hour Days
544947 Cath Lab Johnson City TENNESSEE Days
545292 CVICU Memphis TENNESSEE 12 Hour Nights
545526 Med Surg Memphis TENNESSEE 12 Hour Days
546196 Med Surg Bristol TENNESSEE 12 Hour Nights
546198 Med Surg Bristol TENNESSEE 12 Hour Days
546201 Registered Nurse Bristol TENNESSEE 12 Hour Nights
546393 OR Johnson City TENNESSEE Nights
546464 Med Surg Bristol TENNESSEE 12 Hour Nights
546466 Med Surg Greeneville TENNESSEE 12 Hour Nights
546629 PCU Bristol TENNESSEE 12 Hour Days
547069 Step Down Johnson City TENNESSEE 12 Hour Nights
547246 Postpartum Memphis TENNESSEE 12 Hour Nights
547425 CVOR Kingsport TENNESSEE 8 Hour Days
547426 Scrub Tech Kingsport TENNESSEE 8 Hour Days
547521 Med Surg Tele Bristol TENNESSEE 12 Hour Nights
547581 Pulmonary Johnson City TENNESSEE 12 Hour Days
547882 ICU Johnson City TENNESSEE 12 Hour Nights
547890 CT Tech Knoxville TENNESSEE 12 Hour Nights
542772 Med Surg Kingsport TENNESSEE 12 Hour Nights
542773 Med Surg Kingsport TENNESSEE 12 Hour Nights
542775 Med Surg Johnson City TENNESSEE 12 Hour Nights
542779 PCU Bristol TENNESSEE 12 Hour Nights
542790 PCU Kingsport TENNESSEE 12 Hour Nights
543225 PCU Johnson City TENNESSEE 12 Hour Nights
543446 Acute Care Kingsport TENNESSEE 12 Hour Days
543461 Oncology Kingsport TENNESSEE 12 Hour Nights
543668 ICU Bristol TENNESSEE 12 Hour Days
543669 ICU Bristol TENNESSEE 12 Hour Nights
543696 Oncology Bristol TENNESSEE 12 Hour Days
543821 Med Surg Tele Bristol TENNESSEE 12 Hour Days
547977 ICU Memphis TENNESSEE 12 Hour Nights
548310 ER Memphis TENNESSEE 12 Hour Nights RN/Registered Nurse
547929 L&D San Antonio TEXAS 12 Hour Nights
547930 ER Brownsville TEXAS 12 Hour Nights
547931 Telemetry Brownsville TEXAS 12 Hour Days
547964 Mammo Tech San Angelo TEXAS 8 Hour Days
548021 PCU Abilene TEXAS 12 Hour Nights
548094 ER ODESSA TEXAS 12 Hour Nights RN/Registered Nurse
548097 Med Surg Tele Lufkin TEXAS 12 Hour Days RN/Registered Nurse
548140 Surgical Tech Nacogdoches TEXAS 8 Hour Days CST/Certified Surgical Technician
548158 Scrub Tech Abilene TEXAS 8 Hour Days CST/Certified Surgical Technician
548282 ICU Lufkin TEXAS 12 Hour Nights RN/Registered Nurse
548289 OR Brownwood TEXAS 8 Hour Days RN/Registered Nurse
548309 ER Abilene TEXAS 12 Hour Day/Night Rotate RN/Registered Nurse
548311 ER Dallas TEXAS 12 Hour Nights RN/Registered Nurse
546317 CT Tech ODESSA TEXAS 12 Hour Days
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
546359 DOU El Paso TEXAS 12 Hour Nights
546688 L&D San Antonio TEXAS 12 Hour Nights
546948 Echo Lufkin TEXAS 8 Hour Day/Night Rotate
547114 Outpatient Clinic Wichita Falls TEXAS 8 Hour Days
547409 Postpartum ODESSA TEXAS 12 Hour Days
547442 Electrophysiology Tech San Antonio TEXAS 10 Hour Days
547445 PT Seguin TEXAS 8 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
547451 LPN/LVN Abilene TEXAS 8 Hour Day/Night Rotate
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
547453 Surgical Tech CVOR Abilene TEXAS 8 Hour Days
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
547455 PCU Abilene TEXAS 12 Hour Days
547456 Neuro Med Surg/Tele Abilene TEXAS 12 Hour Nights
547457 ICU Abilene TEXAS 12 Hour Nights
547458 Outpatient Clinic Abilene TEXAS 10 Hour Day/Night Rotate
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
547460 MRI Tech Abilene TEXAS 8 Hour Days
547490 Pharmacist Abilene TEXAS 12 Hour Days
547519 Hospice Amarillo TEXAS Days
547780 CT Tech Sunnyvale TEXAS 12 Hour Nights
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
547957 OR Mesquite TEXAS 8 Hour Days
464113 SLP Ballinger TEXAS Days
507014 Therapy Rehab Ballinger TEXAS Days
518254 PT Cleburne TEXAS Varied
525811 CT Tech Amarillo TEXAS 12 Hour Nights Tech/Technologist
525812 RAD Tech Amarillo TEXAS 8 Hour Evenings Radiology Techs/Technologists
527053 CVOR Houston TEXAS 8 Hour Days RN/Registered Nurse
528446 PTA Killeen TEXAS Days
532052 PT Carrizo Springs TEXAS Days
532920 Oncology San Angelo TEXAS 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.8081 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 3300,100 in 1.5253 seconds