Listing all records

Displaying records 1301 through 1400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545793 ICU Gainesville FLORIDA 12 Hour Nights
540210 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540211 ICU Concord CALIFORNIA 12 Hour Nights
545789 Med Surg Gainesville FLORIDA 12 Hour Nights
545801 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545802 Med Surg Gainesville FLORIDA 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
545808 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545810 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545805 Med Surg Gainesville FLORIDA 12 Hour Nights
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545813 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545812 ICU Gainesville FLORIDA 12 Hour Nights
545820 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545824 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545821 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545819 Med Surg Gainesville FLORIDA 12 Hour Nights
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
545826 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
540234 ICU Concord CALIFORNIA 12 Hour Nights
545832 ICU Gainesville FLORIDA 12 Hour Nights
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
545830 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545828 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545825 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545835 Pediatric ER Gainesville FLORIDA 12 Hour Nights
540242 ICU Concord CALIFORNIA 12 Hour Nights
540243 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
545834 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545836 ICU Gainesville FLORIDA 12 Hour Nights
545840 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545838 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545842 ICU 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
545845 Med Surg Gainesville FLORIDA 12 Hour Nights
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
544269 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
544149 Long Term Care Moscow IDAHO 12 Hour Nights
543259 Step Down Cleveland OHIO 12 Hour Nights
541620 Med Surg Spokane WASHINGTON 12 Hour Nights
545122 Med Surg Lancaster OHIO 12 Hour Nights
541647 Med Surg Colville WASHINGTON 12 Hour Nights
541649 Med Surg Chewelah WASHINGTON 12 Hour Nights
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
541657 Med Surg Walla Walla WASHINGTON 12 Hour Nights
541700 L&D Eureka CALIFORNIA 12 Hour Nights
545848 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
543465 Telemetry Wailuku HAWAII 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
542063 ICU Wailuku HAWAII 12 Hour Nights
542071 Med Surg Tele Wailuku HAWAII 12 Hour Nights
543494 Med Surg Nashua NEW HAMPSHIRE 12 Hour Nights
542103 Medical Assistant Portland OREGON 12 Hour Nights
542104 Medical Assistant Portland OREGON 12 Hour Nights
542137 Med Surg Brooklyn NEW YORK 12 Hour Nights
542138 Med Surg Brooklyn NEW YORK 12 Hour Nights
542176 ICU Boise IDAHO 12 Hour Nights
542177 ICU Boise IDAHO 12 Hour Nights
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
542242 Oncology Charlottesville VIRGINIA 12 Hour Nights
542243 Oncology Charlottesville VIRGINIA 12 Hour Nights
542272 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
542273 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
542375 Med Surg Spokane WASHINGTON 12 Hour Nights
547059 ER Rome NEW YORK 12 Hour Nights
542390 Pediatric ER New York NEW YORK 12 Hour Nights
543475 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
542451 ER Rockford ILLINOIS 12 Hour Nights
542466 Neurology Des Moines IOWA 12 Hour Nights
546182 Med Surg Peoria ILLINOIS 12 Hour Nights
545262 PCU Omaha NEBRASKA 12 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
545292 CVICU Memphis TENNESSEE 12 Hour Nights
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
542615 Telemetry Terre Haute INDIANA 12 Hour Nights
542617 PCU Sun City West ARIZONA 12 Hour Nights
543466 Med Surg Tele Wailuku HAWAII 12 Hour Nights
542653 Telemetry Charleston SOUTH CAROLINA 12 Hour Nights
542685 Postpartum Kealakekua HAWAII 12 Hour Nights
542713 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
542740 ICU Saratoga Springs NEW YORK 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 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
542781 ICU Boise IDAHO 12 Hour Nights
542782 ICU Boise IDAHO 12 Hour Nights
542790 PCU Kingsport TENNESSEE 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.8296 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 1300,100 in 1.545 seconds