Listing all records

Displaying records 901 through 1000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
526545 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
547698 ICU Saratoga Springs NEW YORK 12 Hour Nights
541326 Certified Surgical Tech Albuquerque NEW MEXICO 12 Hour Nights
543886 RAD Tech National City CALIFORNIA 12 Hour Nights
534331 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
540349 Telemetry Concord CALIFORNIA 12 Hour Nights
540338 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540498 Pediatric ER New York NEW YORK 12 Hour Nights
540569 Telemetry Farmington CONNECTICUT 12 Hour Nights
534901 Telemetry Boise IDAHO 12 Hour Nights
534902 Telemetry Boise IDAHO 12 Hour Nights
534903 Telemetry Boise IDAHO 12 Hour Nights
534904 Telemetry Boise IDAHO 12 Hour Nights
541384 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
535227 Orthopedics Des Moines IOWA 12 Hour Nights
540582 Med Surg Des Moines IOWA 12 Hour Nights
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
540482 OR New York NEW YORK 12 Hour Nights
535387 Rehab Clive IOWA 12 Hour Nights
535463 ICU Sioux City IOWA 12 Hour Nights
540345 ICU Walnut Creek CALIFORNIA 12 Hour Nights
535604 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
540337 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540456 Med Surg Boise IDAHO 12 Hour Nights
547059 ER Rome NEW YORK 12 Hour Nights
540129 Med Surg Tele Concord CALIFORNIA 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
543598 Rehab Twin Falls IDAHO 12 Hour Nights
543613 Telemetry Boise IDAHO 12 Hour Nights
543607 Telemetry Nampa IDAHO 12 Hour Nights
543644 ER Walnut Creek CALIFORNIA 12 Hour Nights
543647 ER Walnut Creek CALIFORNIA 12 Hour Nights
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
540146 ER Concord CALIFORNIA 12 Hour Nights
543646 ER Walnut Creek CALIFORNIA 12 Hour Nights
543649 ER Walnut Creek CALIFORNIA 12 Hour Nights
543650 ER Walnut Creek CALIFORNIA 12 Hour Nights
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
543651 ER Walnut Creek CALIFORNIA 12 Hour Nights
540154 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540155 ER Walnut Creek CALIFORNIA 12 Hour Nights
543669 ICU Bristol TENNESSEE 12 Hour Nights
540157 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540336 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
543740 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Nights
543730 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights
540164 Med Surg Concord CALIFORNIA 12 Hour Nights
540165 PICU Walnut Creek CALIFORNIA 12 Hour Nights
543747 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
540167 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540168 Pediatrics Walnut Creek CALIFORNIA 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
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
540883 ER Hartford CONNECTICUT 12 Hour Nights
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
543824 ER Lansing MICHIGAN 12 Hour Nights
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
543887 CT Tech National City CALIFORNIA 12 Hour Nights
540191 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
541332 PCU Albuquerque NEW MEXICO 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
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
540210 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540211 ICU Concord CALIFORNIA 12 Hour Nights
544031 Telemetry Portland OREGON 12 Hour Nights
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
544034 PCU Spokane WASHINGTON 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
544049 Med Surg Palm Springs CALIFORNIA 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544037 Step Down Lansing MICHIGAN 12 Hour Nights
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544051 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544530 Med Surg Waterloo IOWA 12 Hour Nights
544091 Med Surg Norman OKLAHOMA 12 Hour Nights
544067 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
544116 Telemetry Cleveland OHIO 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.5168 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 900,100 in 1.6672 seconds