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

Caregiver Jobs in Cottonwood AZ

 What:  Where:
[ Start New Search ] [ Advanced Search ]


Caregiver jobs within of Cottonwood, AZ. [ 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.jobTitle, a.companyName, a.category) AGAINST ('+Caregiver ') as relevance
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 MATCH(a.jobTitle, a.companyName, a.category) AGAINST ('+Caregiver ' IN BOOLEAN MODE) 
			AND 
			postalCode IN (select distinct postalCode from zip_code_full AS f where ((3958*3.1415926*sqrt((f.latitude-'34.72')*(f.latitude-'34.72') + cos(f.latitude/57.29578)*cos('30'/57.29578)*(f.longitude-'-112.01')*(f.longitude-'-112.01'))/180) <= '25'))

			
			 AND a.CPC > 0.05 

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


Caregiver
The Mentor Network - Cottonwood, Arizona
Caregiver( Job Number: 140000U0) Primary Location United States-AZ-AZCottonwood Description Cottonwood is located an hour and a half north of Phoenix near Camp Verde. Arizona MENTOR is currently seeking Caregivers in the Cottonwood area. Direct...
Last Updated on 2014-04-22 by The Mentor Network
[ Save Job ]

Caregiver
The Mentor Network - Cottonwood, Arizona
Caregiver( Job Number: 140000U0) Primary Location United States-AZ-AZCottonwood Description Cottonwood is located an hour and a half north of Phoenix near Camp Verde. Arizona MENTOR is currently seeking Caregivers in the Cottonwood area. Direct...
Last Updated on 2014-04-22 by The Mentor Network
[ Save Job ]



Job list generated in 0.023 seconds.