SELECT jb_employers.employer_id, jb_employers.logo_filename, user.first_name, user.last_name, user.company_name, email.email, phone.phone, fax.phone AS fax, addr.street AS addr1, addr.city AS addr2, addr.state AS addr3 FROM jb_employers INNER JOIN jb_privacy AS priv ON (priv.id = jb_employers.employer_id) LEFT JOIN jb_emails AS email ON (jb_employers.employer_id = email.user_id AND email.is_default = 1 AND priv.show_email = 1) LEFT JOIN jb_phone_numbers AS phone ON (jb_employers.employer_id = phone.user_id AND phone.is_default = 1 AND priv.show_phone = 1) LEFT JOIN jb_users AS user ON (jb_employers.employer_id = user.id AND priv.show_name = 1) LEFT JOIN jb_phone_numbers AS fax ON (jb_employers.employer_id = fax.user_id AND fax.name = 'FAX' AND priv.show_fax = 1) LEFT JOIN jb_addresses AS addr ON (jb_employers.employer_id = addr.user_id AND priv.show_address = 1) WHERE jb_employers.employer_id = 1018: Can't open file: './jlisx_webjobs/jb_phone_numbers.frm' (errno: 24)

Date Job Title City Pay Options
Mar 27 MOHS Histology Technician
MOHS Histology Technician Job Opening in Chicago, IL
Chicago Not Specified
Apr 24 Histotech
Histotech needed for June Vacation Coverage
Denver Not Specified
May 16 Histotech
Histotech Job in Northern Central Florida
Gainesville Not Specified
May 29 Histology Sales Representative
Histology Sales Representative Job in Michigan
Columbus Not Specified
Jun 1 Histology Manager
Histology Manager job in Texas
Houston Not Specified
Histosearch     -  -  - Histonet Archives -  -  -  -  
Home | Register | My Account | Employers | Contact Us
All contents © Copyright 2014 Histosearch All rights reserved.