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 = 1532: Can't open file: './jlisx_webjobs/jb_phone_numbers.frm' (errno: 24)

Histosearch     -  -  - Histonet Archives -  -  -  -  
Home | Register | My Account | Employers | Contact Us
All contents © Copyright 2014 Histosearch All rights reserved.