Listing all records

Displaying records 1201 through 1300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545300 Med Surg Helena MONTANA 12 Hour Nights
540133 ER Concord CALIFORNIA 12 Hour Nights
540135 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540136 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540137 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545311 ICU Colville WASHINGTON 12 Hour Nights
545338 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
540146 ER Concord CALIFORNIA 12 Hour Nights
545328 CNA Salem OREGON 12 Hour Nights
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
540154 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540155 ER Walnut Creek CALIFORNIA 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
540157 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
543740 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Nights
540164 Med Surg Concord CALIFORNIA 12 Hour Nights
540165 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540167 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540168 Pediatrics Walnut Creek CALIFORNIA 12 Hour Nights
545421 RN Columbus OHIO 12 Hour Nights
540170 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540171 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540172 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540173 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540174 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540175 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545453 ER Lynwood CALIFORNIA 12 Hour Nights
543747 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
547904 ICU Mesa ARIZONA 12 Hour Nights
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
545514 L&D Arcata CALIFORNIA 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
545502 Telemetry Boise IDAHO 12 Hour Nights
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540191 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
544104 OR Langhorne PENNSYLVANIA 12 Hour Nights
540197 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540199 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540200 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540201 ER Concord CALIFORNIA 12 Hour Nights
540202 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540203 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545579 ER Willoughby OHIO 12 Hour Nights
545605 ER Peoria ILLINOIS 12 Hour Nights
540210 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540211 ICU Concord CALIFORNIA 12 Hour Nights
545597 Med Surg Peoria ILLINOIS 12 Hour Nights
543755 NICU Lynwood CALIFORNIA 12 Hour Nights
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545616 Med Surg Lancaster SOUTH CAROLINA 12 Hour Nights
540218 ER Concord CALIFORNIA 12 Hour Nights
540219 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540220 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
545621 ER Massena NEW YORK 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
545633 Med Surg Gainesville FLORIDA 12 Hour Nights
545636 ICU Gainesville FLORIDA 12 Hour Nights
545635 Med Surg Gainesville FLORIDA 12 Hour Nights
545631 ICU Gainesville FLORIDA 12 Hour Nights
543974 ER Newark NEW JERSEY 12 Hour Nights
545639 ICU Gainesville FLORIDA 12 Hour Nights
540234 ICU Concord CALIFORNIA 12 Hour Nights
545643 Pediatric ER Gainesville FLORIDA 12 Hour Nights
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
545642 Med Surg Gainesville FLORIDA 12 Hour Nights
545641 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545637 ICU Gainesville FLORIDA 12 Hour Nights
545648 RAD Tech Gainesville FLORIDA 12 Hour Nights
540242 ICU Concord CALIFORNIA 12 Hour Nights
540243 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545649 RAD Tech Gainesville FLORIDA 12 Hour Nights
545652 Med Surg Gainesville FLORIDA 12 Hour Nights
545653 Med Surg Gainesville FLORIDA 12 Hour Nights
540250 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540251 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540252 NICU Walnut Creek CALIFORNIA 12 Hour Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
542772 Med Surg Kingsport TENNESSEE 12 Hour Nights
542781 ICU Boise IDAHO 12 Hour Nights
541620 Med Surg Spokane WASHINGTON 12 Hour Nights
541647 Med Surg Colville WASHINGTON 12 Hour Nights
541649 Med Surg Chewelah WASHINGTON 12 Hour Nights
542779 PCU Bristol TENNESSEE 12 Hour Nights
542775 Med Surg Johnson City TENNESSEE 12 Hour Nights
541657 Med Surg Walla Walla WASHINGTON 12 Hour Nights
541700 L&D Eureka CALIFORNIA 12 Hour Nights
542773 Med Surg Kingsport TENNESSEE 12 Hour Nights
545663 MLT Gainesville FLORIDA 12 Hour Nights
544658 Med Surg Fayetteville NORTH CAROLINA 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.6838 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.shift desc limit 1200,100 in 1.6052 seconds