Search Jobs - My New Job Search


Home | Post Jobs | Job Seekers | Web Publishers
Job Search
Search Jobs
Browse Jobs
Registration
Employers
Web Publishers
Job Seekers


Follow us on Twitter

HW Search & Selection Jobs

Search for HW Search & Selection jobs.

Advanced Job Search
What type of job:
With all of these words:
With none of these words:
Posted by this company:
Located Within: miles from
City or ZIP Code, U.S. Only
Posted within the last: days
[ Start New Search ] [ Basic Search ]
SELECT DISTINCT a.companyCampaignJobID, a.companyCampaignID, a.lastUpdateDate, a.jobTitle, a.jobDescription,
a.companyName, a.city, a.state, a.countryID, a.postalCode, a.category,
c.companyName AS posterName 
FROM company_campaign_job_live AS a, company_campaign AS b, company AS c
WHERE a.companyCampaignID = b.companyCampaignID
AND b.companyID = c.companyID
AND a.expirationDate >= '2014-04-23'
AND a.contactTypeID = 1
 AND a.companyName LIKE 'HW Search & Selection%' 

GROUP BY a.jobDescription
ORDER BY c.companyTypeID ASC, a.CPC DESC
LIMIT 0,20


No jobs were found matching your criteria.

Job list generated in 0.001 seconds.