webJobs Copyright 2008, Web Scribble Solutions, Inc. All Rights Reserved. webJobs: Job board software Job board software Job script
Home Login Contact Us
SELECT DISTINCT j.id AS job_id, a.id AS agent_id, u.id AS seeker_id, CASE WHEN u.first_name IS NULL or u.first_name = '' THEN e.email ELSE CONCAT(u.first_name, ' ', u.last_name) END AS name, e.email, j.job_title, j.city, j.state, u2.company_name FROM jb_users AS u INNER JOIN jb_agent AS a ON a.seeker_id = u.id LEFT JOIN jb_zips AS z ON z.zipcode=a.zip INNER JOIN jb_agent_keyword AS kw ON kw.agent_id = a.id INNER JOIN jb_emails AS e ON (u.id = e.user_id AND e.name='PRIMARY'), jb_jobs AS j INNER JOIN jb_employers AS emp ON (emp.employer_id = j.employer_id) INNER JOIN jb_users AS u2 ON (emp.employer_id = u2.id) WHERE ((j.job_type<>'' AND a.major LIKE CONCAT( '%', j.job_type, '%' )) OR a.major='') AND ((j.job_type<>'' AND a.industries LIKE CONCAT( '%', j.job_type, '%' )) OR a.industries='') AND ((((a.country = j.country OR a.country = '') AND ((j.state<>'' AND a.locations LIKE CONCAT( '%', j.state, '%' )) OR a.locations = '') AND (a.city = j.city OR a.city = '')) AND (a.zip='' OR a.zip_radius='' OR z.zipcode IS NULL)) OR (a.zip<>'' AND a.zip_radius<>'' AND z.zipcode IS NOT NULL AND SQRT(POWER(j.zlong - z.longw, 2) + POWER(j.zlat - z.latn, 2))*69 < a.zip_radius )) AND (a.position_type = j.position_type OR a.position_type ='') AND ((j.req_experience<>'' AND a.experience_level LIKE CONCAT( '%', j.req_experience, '%' )) OR a.experience_level='') AND ((j.req_education<>'' AND a.education_level LIKE CONCAT( '%', j.req_education, '%' )) OR a.education_level='') AND (j.short_description LIKE CONCAT( '%', kw.keyword, '%' ) OR j.long_description LIKE CONCAT( '%', kw.keyword, '%' ) OR j.job_title LIKE CONCAT( '%', kw.keyword, '%' )) AND ((emp.company_type<>'' AND a.employer_type LIKE CONCAT( '%', emp.company_type, '%' )) OR a.employer_type='') AND (a.salary_type = j.salary_type OR a.salary_type ='') AND (a.min_salary=0 OR a.min_salary='' OR (j.approx_salary >= a.min_salary AND j.approx_salary_range = 0.00) OR (j.approx_salary_range <> 0.00 AND j.approx_salary_range >= a.min_salary)) AND (a.max_salary=0 OR a.max_salary='' OR (j.approx_salary <= a.max_salary AND j.approx_salary_range = 0.00) OR (j.approx_salary_range <> 0.00 AND j.approx_salary_range <= a.max_salary)) AND j.time>'1429987684' ORDER BY j.time DESC: Unknown column 'a.city' in 'where clause'
 
Quick Search
   
 

Search by Job Type

Search by State


Search by Job ID
 

Employers

Job Seekers

Already a member?

Latest Jobs

Job Title
Physical Therapy Assistant
Johnston Health - Clayton,
The Physical Therapist Assistant is responsible for administering physical
Posted - December 30, 2014
 
Registered Nurse / Labor & Delivery
Johnston Health - Clayton,
Responsible for the delivery of patient care through the nursing process of
Posted - February 16, 2015
 
Registered Nurse
Johnston Health - Clayton,
Multiple openings Responsible for the delivery of patient care through the
Posted - March 22, 2015
 
Physician Assistant II Gastroenterology
WakeMed - Raleigh,
Med Health & Hospitals is a nationally recognized, private, not-for-pro
Posted - April 25, 2015
 
Physician Assistant IV Urgent Care
WakeMed - Raleigh,
Med Health & Hospitals is a nationally recognized, private, not-for-pro
Posted - April 25, 2015
 
jobs by Indeed job search