Listing all records

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

ID Job Specialty City State Shift Title
540122 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540123 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540124 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540125 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540126 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540127 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540128 ICU Walnut Creek CALIFORNIA 12 Hour Days
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
540136 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540137 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540138 NICU Walnut Creek CALIFORNIA 12 Hour Days
540139 MLT Walnut Creek CALIFORNIA 10 Hour Nights
540140 L&D Walnut Creek CALIFORNIA 12 Hour Days
540141 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540142 Intermediate Care Concord CALIFORNIA 12 Hour Days
540143 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
540144 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540145 L&D Walnut Creek CALIFORNIA 12 Hour Days
540146 ER Concord CALIFORNIA 12 Hour Nights
540147 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540148 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
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
540155 ER Walnut Creek 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
540162 PACU Walnut Creek CALIFORNIA 12 Hour Days
540163 Surgical Tech Concord CALIFORNIA 8 Hour Evenings
540164 Med Surg Concord CALIFORNIA 12 Hour Nights
540165 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540166 NICU Walnut Creek CALIFORNIA 12 Hour Days
540167 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540168 Pediatrics Walnut Creek CALIFORNIA 12 Hour Nights
540169 L&D Walnut Creek CALIFORNIA 12 Hour Days
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
540176 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540177 Psych Concord CALIFORNIA 8 Hour Evenings
540178 Med Surg Concord CALIFORNIA 8 Hour Evenings
540179 Case Manager Concord CALIFORNIA 12 Hour Days
540180 Surgical Tech Walnut Creek 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
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540187 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540189 Peri-Operative Concord CALIFORNIA 8 Hour Days
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
540191 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540192 OR Concord CALIFORNIA 12 Hour Days
540194 Case Manager Concord CALIFORNIA 8 Hour Days
540195 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540196 Histology Technician Walnut Creek CALIFORNIA 8 Hour Nights
540197 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540198 ER Concord CALIFORNIA 12 Hour Days
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
540204 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540205 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540206 PACU Concord CALIFORNIA 10 Hour Days
540207 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540208 ICU Concord CALIFORNIA 12 Hour Days
540209 NICU Walnut Creek CALIFORNIA 12 Hour Days
540210 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540211 ICU Concord CALIFORNIA 12 Hour Nights
540212 Intermediate Care Concord CALIFORNIA 12 Hour Days
540213 ER Concord CALIFORNIA 12 Hour Days
540214 Case Manager Concord CALIFORNIA 8 Hour Evenings
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540217 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540218 ER Concord CALIFORNIA 12 Hour Nights
540219 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540220 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540221 PICU Walnut Creek CALIFORNIA 12 Hour Days
540222 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.6639 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 y.name desc limit 3000,100 in 1.4609 seconds