Listing all records

Displaying records 3001 through 3100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547620 PICU Santa Clara CALIFORNIA 12 Hour Days
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
548104 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547636 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
548264 CNA Lowville NEW YORK 8 Hour Nights CNA/Certified Nursing Assistant
517902 Med Surg Tele Wailuku HAWAII 8 Hour Nights
519045 Med Surg Kula HAWAII 8 Hour Nights
541765 CVOR Oceanside CALIFORNIA 8 Hour Nights
523400 Med Surg Kula HAWAII 8 Hour Nights
523403 Med Surg Kula HAWAII 8 Hour Nights
524667 CT Tech Baker City OREGON 8 Hour Nights
524703 CT Tech Pontiac MICHIGAN 8 Hour Nights
526714 CT Tech Hartford CONNECTICUT 8 Hour Nights
531609 CT Tech Jackson MISSISSIPPI 8 Hour Nights
535905 Psych Concord CALIFORNIA 8 Hour Nights
534687 Med Surg Tele Concord CALIFORNIA 8 Hour Nights
537444 CNA Brooklyn NEW YORK 8 Hour Nights
535465 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
535732 Pharmacist New York NEW YORK 8 Hour Nights
536228 RAD Tech Maywood ILLINOIS 8 Hour Nights
537445 CNA Brooklyn NEW YORK 8 Hour Nights
539629 CT Tech Cleveland OHIO 8 Hour Nights
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
538869 MRI Tech Lexington KENTUCKY 8 Hour Nights
539754 L&D Wailuku HAWAII 8 Hour Nights
540034 PCU Concord CALIFORNIA 8 Hour Nights
540196 Histology Technician Walnut Creek CALIFORNIA 8 Hour Nights
540232 Psych Concord CALIFORNIA 8 Hour Nights
540488 SNF Staten Island NEW YORK 8 Hour Nights
547749 Med Surg New York NEW YORK 8 Hour Nights
540854 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540855 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540856 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540859 ER Springfield MASSACHUSETTS 8 Hour Nights
540861 ER Springfield MASSACHUSETTS 8 Hour Nights
541039 Psych Concord CALIFORNIA 8 Hour Nights
547799 RAD Tech Pontiac MICHIGAN 8 Hour Nights
541109 MLT Syracuse NEW YORK 8 Hour Nights
547911 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
542345 MLT Westerville OHIO 8 Hour Nights
543286 RAD Tech Lynwood CALIFORNIA 8 Hour Nights
543519 MRI Tech Beachwood OHIO 8 Hour Nights
543617 Social Worker Twin Falls IDAHO 8 Hour Nights
543618 Social Worker Twin Falls IDAHO 8 Hour Nights
543703 RAD Tech Commerce Twp MICHIGAN 8 Hour Nights
543782 CT Tech Woonsocket RHODE ISLAND 8 Hour Nights
544220 MICU Newark NEW JERSEY 8 Hour Nights
544409 CT Tech Springfield VERMONT 8 Hour Nights
544514 CT Tech Vernon Rockville CONNECTICUT 8 Hour Nights
545190 Pharmacy Tech Mishawaka INDIANA 8 Hour Nights
545422 ER Springfield MASSACHUSETTS 8 Hour Nights
545490 CT Tech Farmington CONNECTICUT 8 Hour Nights
547141 RAD Tech Farmington CONNECTICUT 8 Hour Nights
545541 RAD Tech Columbus OHIO 8 Hour Nights
545618 MLT Gainesville FLORIDA 8 Hour Nights
545718 MLT Gainesville FLORIDA 8 Hour Nights
545761 MLT Gainesville FLORIDA 8 Hour Nights
547748 Med Surg New York NEW YORK 8 Hour Nights
545985 Long Term Care Oneonta NEW YORK 8 Hour Nights
546049 RAD Tech Bismarck NORTH DAKOTA 8 Hour Nights
547800 RAD Tech Pontiac MICHIGAN 8 Hour Nights
546402 CT Tech Mount Airy NORTH CAROLINA 8 Hour Nights
547910 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
546451 Therapy Rehab Macon GEORGIA 8 Hour Nights
546712 Respiratory Therapist Springfield MASSACHUSETTS 8 Hour Nights
546713 L&D Springfield MASSACHUSETTS 8 Hour Nights
546714 L&D Springfield MASSACHUSETTS 8 Hour Nights
547039 Supervisor Oneonta NEW YORK 8 Hour Nights
547187 Med Surg Brooklyn NEW YORK 8 Hour Nights
547189 Surgical Tech Brooklyn NEW YORK 8 Hour Nights
547424 Long Term Care GRAND MARAIS MINNESOTA 8 Hour Nights
547389 CT Tech Cleveland OHIO 8 Hour Nights
547470 CT Tech Hays KANSAS 8 Hour Nights
548230 CNA Sacramento CALIFORNIA 8 Hour Evenings CNA/Certified Nursing Assistant
525606 RAD Tech Columbus OHIO 8 Hour Evenings Radiology Techs/Technologists
525812 RAD Tech Amarillo TEXAS 8 Hour Evenings Radiology Techs/Technologists
534109 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
540085 Psych Concord CALIFORNIA 8 Hour Evenings
540098 Case Manager Concord CALIFORNIA 8 Hour Evenings
540148 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540163 Surgical Tech Concord CALIFORNIA 8 Hour Evenings
540177 Psych Concord CALIFORNIA 8 Hour Evenings
540178 Med Surg Concord CALIFORNIA 8 Hour Evenings
540204 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540214 Case Manager Concord CALIFORNIA 8 Hour Evenings
540245 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
544201 OR Germantown MARYLAND 8 Hour Evenings
546148 Med Surg Spokane WASHINGTON 8 Hour Evenings
548205 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
544264 RAD Tech Silver Spring MARYLAND 8 Hour Evenings
544377 Ultrasound Tech Silver Spring MARYLAND 8 Hour Evenings
548206 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
544832 MLT East St Louis ILLINOIS 8 Hour Evenings
544835 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
544909 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
545171 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545178 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545264 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545274 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545302 RAD Tech Farmington CONNECTICUT 8 Hour Evenings
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.6421 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 3000,100 in 1.5451 seconds