Listing all records

Displaying records 2801 through 2900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
534687 Med Surg Tele Concord CALIFORNIA 8 Hour Nights
539110 PCU Concord CALIFORNIA 12 Hour Nights
539111 OR Concord CALIFORNIA 10 Hour Days
539112 Social Worker Concord CALIFORNIA 8 Hour Days
540025 OR Concord CALIFORNIA 10 Hour Evenings
540026 OR Concord CALIFORNIA 8 Hour Days
540027 OR Concord CALIFORNIA 12 Hour Days
540028 OR Concord CALIFORNIA 10 Hour Days
540029 PCU Concord CALIFORNIA 8 Hour Days
540033 Med Surg Tele Concord CALIFORNIA 8 Hour Days
540034 PCU Concord CALIFORNIA 8 Hour Nights
540035 PCU Concord CALIFORNIA 8 Hour Days
540038 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540042 ICU Concord CALIFORNIA 12 Hour Days
540047 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540048 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540050 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540051 Psych Concord CALIFORNIA 8 Hour Evenings
540052 Psych Concord CALIFORNIA 8 Hour Evenings
540054 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540059 PACU Concord CALIFORNIA 10 Hour Days
546228 Pediatrics Concord NEW HAMPSHIRE 12 Hour Nights
546303 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546304 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546992 Certified Surgical Tech Concord MASSACHUSETTS 8 Hour Days
547532 CCU Concord MASSACHUSETTS 12 Hour Nights
547720 OR Concord CALIFORNIA 8 Hour Days
544890 ER Concord CALIFORNIA 12 Hour Days
545035 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545196 Social Worker Concord CALIFORNIA 8 Hour Days
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
548374 Med Surg Tele Concord OHIO 12 Hour Nights RN/Registered Nurse
548384 Telemetry Concord CALIFORNIA 12 Hour Days RN/Registered Nurse
540070 CT Tech Concord CALIFORNIA 10 Hour Nights
540071 PACU Concord CALIFORNIA 12 Hour Days
540076 ER Concord CALIFORNIA 12 Hour Nights
540078 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540079 Cath Lab Concord CALIFORNIA 10 Hour Days
540080 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540081 Case Manager Concord CALIFORNIA 8 Hour Days
540085 Psych Concord CALIFORNIA 8 Hour Evenings
540087 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540088 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540089 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540091 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540092 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540093 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540095 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540096 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540097 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540098 Case Manager Concord CALIFORNIA 8 Hour Evenings
540099 ER Concord CALIFORNIA 12 Hour Nights
540100 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540102 Med Surg Concord CALIFORNIA 12 Hour Nights
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
540105 ICU Concord CALIFORNIA 12 Hour Nights
540106 ER Concord CALIFORNIA 12 Hour Nights
540107 Telemetry Concord CALIFORNIA 12 Hour Nights
540108 ER Concord CALIFORNIA 12 Hour Nights
540111 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540112 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540113 Telemetry Concord CALIFORNIA 12 Hour Nights
540124 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540127 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540129 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540130 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540131 Cath Lab Concord CALIFORNIA 10 Hour Days
540132 Cath Lab Concord CALIFORNIA 10 Hour Days
540133 ER Concord CALIFORNIA 12 Hour Nights
540134 Cath Lab Concord CALIFORNIA 10 Hour Days
540135 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540137 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540141 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540142 Intermediate Care Concord CALIFORNIA 12 Hour Days
540144 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540146 ER Concord CALIFORNIA 12 Hour Nights
540147 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540149 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540150 Telemetry Concord CALIFORNIA 12 Hour Days
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
540152 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
540153 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540154 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540156 ER Concord CALIFORNIA 12 Hour Days
540157 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540158 Peri-Operative Concord CALIFORNIA 8 Hour Days
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
540160 Med Surg Concord CALIFORNIA 12 Hour Days
540161 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540163 Surgical Tech Concord CALIFORNIA 8 Hour Evenings
540164 Med Surg Concord CALIFORNIA 12 Hour Nights
540167 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540173 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540174 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540177 Psych Concord CALIFORNIA 8 Hour Evenings
540178 Med Surg Concord CALIFORNIA 8 Hour Evenings
540179 Case Manager Concord CALIFORNIA 12 Hour Days
540181 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540182 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540183 Med Surg Tele Concord CALIFORNIA 12 Hour 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.7169 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 z.city desc limit 2800,100 in 1.6539 seconds