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

LKI Jobs in Kenner, LA

Search for LKI jobs in Kenner, LA.

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 ]

Showing all jobs in Kenner, LA. [ Save this Search ] [ Receive E-Mail Alerts ]
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 , MATCH(a.city, a.state, a.postalCode) AGAINST ('+Louisiana +Kenner ') as relevance2
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-24'
AND a.contactTypeID = 1
 AND a.state = 'Louisiana'  AND MATCH(a.city, a.state, a.postalCode) AGAINST ('+Louisiana +Kenner ' IN BOOLEAN MODE)  AND a.companyName LIKE 'LKI%' 

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


No jobs were found matching your criteria.

Job list generated in 0.037 seconds.