Search from over 6281 jobs!
Advanced Search
getJobs:
query
RESULTSET
query
  AREALONG AREAMATCH CAREERTYPE CITY CITYMATCH COMPANY CONTACTID COUNTRY COUNTRYID COUNTRYMATCH DATEACTIVE DATEADDED DATEADDEDDISPLAY DATEUPDATEDDISPLAY DISTANCE DISTGROUP DOY FEATURED FLAGSHIP FRONTPAGE INDUSTRYSECTOR INDUSTRYTYPE ISCONFIDENTIAL ISRECRUITER JOBID LASTUPDATED MEMBERID MPE NOOFAPPLICATIONS PARTNER STATE STATEMATCH TITLE TOTALJOBS VIEWS YEARUPDATED
1 West United States 0 Farm & Ranch Operations/Herdsperson/On Farm [empty string] 0 agriCAREERS, INC. 20000 USA 2 0 2016-09-23 00:00:00.0 2016-09-23 12:14:48.04 3 days ago 3 days ago 9999 5 267 Standard 0 [empty string] Production/Farming Crop Production 0 1 561775 2016-09-23 12:14:48.087 187482 0 0 0 ID 0 Crop Manager # F603 4 0 2016
2 West United States 0 Farm & Ranch Operations/Herdsperson/On Farm [empty string] 0 Hansen Agri-PLACEMENT 5680 USA 2 0 2016-09-21 00:00:00.0 2016-09-21 09:15:05.463 5 days ago 5 days ago 9999 5 265 Standard 0 [empty string] Production/Farming Animal Production - Dairy 0 1 561185 2016-09-21 09:15:05.5 60347 0 1 0 ID 0 Herd Manager (KH-6402) 4 0 2016
3 West United States 0 Veterinarian/Vet Assistant Boise 0 GPAC 13217 USA 2 0 2016-09-11 00:00:00.0 2016-09-11 11:52:00.0 15 days ago 7 days ago 9999 5 255 Standard 0 0 Production/Farming Animal Production - Beef 0 1 558254 2016-09-19 05:14:00.0 149699 0 5 0 ID 0 Cattle Manager 4 0 2016
4 West United States 0 Sales/Retail [empty string] 0 Ag 1 Source 4600 USA 2 0 2016-09-26 00:00:00.0 2016-07-22 14:55:00.0 6 hours ago 2 days ago 9999 5 204 Standard 0 0 Production/Farming Animal Production - Dairy 0 1 549115 2016-09-24 09:59:00.0 96075 0 7 0 ID 0 Key Account Sales Rep – Pacific Northwest Region (11990) 4 532 2016
CACHED false
EXECUTIONTIME 52
SQL /*Arguments EMPREC:1~ FLAGSHIP:0~ FEATURED:~ FRONTPAGE:~ JOBTYPE:~ INDUSTRYSECTOR:~ ITYPE:~ CTYPE:~ EXPERIENCE:~ NONINTCOUNTRY:~ COUNTRYID:0~ REGION:~ STATE:15~ KEYWORDS:~ EXACTPHRASE:~ EXCLUDEWORDS:~ FJOBS:0~ ISOTHERSBLANK:0~ MAXGROUP:2~ COUNTRY:2~ LOCATION:~ ORDERBY:~ ANYOFTHESEWORDS:~ ALLWORDS:~ MEMBERIDS:~ OVERRIDEPARTNERJOBS:false~ OVERRIDEMPEJOBS:false~ *Parsed Location STATEID:15~ COUNTRYID:2~ STATE:~ AREASTRICT:false~ COUNTRYSTRICT:true~ CITY:~ AREAID:~ STATESTRICT:true~ STATEABBREV:~ */ SET NOCOUNT ON DECLARE @City varchar(50), @State varchar(2), @Lat float, @lng float /**/ SELECT @lat = Lat, @lng = Long FROM CityData WHERE IsNull(City, '') = ? AND State = ? SET NOCOUNT OFF SELECT job_flat_table.JobID ,job_flat_table.MemberID ,job_flat_table.ContactID ,Case job_flat_table.isConfidential WHEN 1 THEN 'Confidential Company' ELSE Company END AS Company ,job_flat_table.Title ,job_flat_table.City ,[job_flat_table].StateSmall as [State] ,job_flat_table.arealong as Arealong ,job_flat_table.countryName as Country ,dbo.Distance(@lat, @lng, job_flat_table.lat, job_flat_table.long) as Distance ,job_flat_table.CountryID ,CASE WHEN dbo.Distance(@lat, @lng, job_flat_table.lat, job_flat_table.long) < 25 then 1 WHEN dbo.Distance(@lat, @lng, job_flat_table.lat, job_flat_table.long) < 50 then 2 WHEN dbo.Distance(@lat, @lng, job_flat_table.lat, job_flat_table.long) < 100 then 3 WHEN dbo.Distance(@lat, @lng, job_flat_table.lat, job_flat_table.long) < 250 then 4 WHEN dbo.Distance(@lat, @lng, job_flat_table.lat, job_flat_table.long) >= 250 then 5 END as DistGroup ,CASE WHEN job_flat_table.city = ? AND job_flat_table.city <> '' THEN 1 ELSE 0 End as CityMatch ,CASE WHEN job_flat_table.state = ? OR job_flat_table.statesmall = ? THEN 1 ELSE 0 End as StateMatch ,CASE WHEN job_flat_table.areaname = ? THEN 1 ELSE 0 End as AreaMatch ,CASE WHEN job_flat_table.countryName = ? THEN 1 ELSE 0 End as CountryMatch ,job_flat_table.Category as IndustrySector ,job_flat_table.cCategory as CareerType ,job_flat_table.iCategory as IndustryType ,job_flat_table.DateAdded ,job_flat_table.DateActive ,job_flat_table.LastUpdated ,YEAR(job_flat_table.dateadded) as yearupdated ,datepart(dy, job_flat_table.dateadded) as doy ,CASE DateDiff(d, job_flat_table.DateActive, GetDate()) WHEN 0 THEN CASE WHEN DateDiff(hh, job_flat_table.DateActive, GetDate()) < 0 THEN 'Just Now' WHEN DateDiff(hh, job_flat_table.DateActive, GetDate()) = 0 THEN 'Just Now' WHEN DateDiff(hh, job_flat_table.DateActive, GetDate()) = 1 THEN '1 hour ago' ELSE CAST(DateDiff(hh, job_flat_table.DateActive, GetDate()) as varchar(3)) + ' hours ago' END WHEN 1 THEN '1 day ago' ELSE CASE WHEN DateDiff(d, job_flat_table.DateActive, GetDate()) > 30 THEN '30+ days ago' ELSE CAST(DateDiff(d, job_flat_table.DateActive, GetDate()) as varchar(4)) + ' days ago' END END as DateAddedDisplay ,CASE DateDiff(d, job_flat_table.LastUpdated, GetDate()) WHEN 0 THEN CASE WHEN DateDiff(hh, job_flat_table.LastUpdated, GetDate()) < 0 THEN 'Just Now' WHEN DateDiff(hh, job_flat_table.LastUpdated, GetDate()) = 0 THEN 'Just Now' WHEN DateDiff(hh, job_flat_table.LastUpdated, GetDate()) = 1 THEN '1 hour ago' ELSE CAST(DateDiff(hh, job_flat_table.LastUpdated, GetDate()) as varchar(3)) + ' hours ago' END WHEN 1 THEN '1 day ago' ELSE CASE WHEN DateDiff(d, job_flat_table.LastUpdated, GetDate()) > 30 THEN '30+ days ago' ELSE CAST(DateDiff(d, job_flat_table.LastUpdated, GetDate()) as varchar(4)) + ' days ago' END END as DateUpdatedDisplay ,CASE job_flat_table.Featured WHEN 1 THEN 'Featured' ELSE 'Standard' END as Featured ,job_flat_table.Mass as IsRecruiter ,job_flat_table.Flagship ,job_flat_table.FrontPage ,job_flat_table.JobViewCount as [Views] ,[job_flat_table].MPE ,[job_flat_table].PartnerPage AS Partner ,[job_flat_table].NoofApplications ,[job_flat_table].isConfidential ,count(*) over() as TotalJobs FROM job_flat_table WITH(NOLOCK) WHERE job_flat_table.Active = 1 AND job_flat_table.Approved = 1 AND job_flat_table.MemberID NOT IN (124942,163953,169942) AND job_flat_table.DateActive < GetDate() AND job_flat_table.DateExpire > GetDate() AND job_flat_table.Mass IN (?) AND CountryID IN (?) AND (job_flat_table.StateID IN (?) OR (job_flat_table.AreaID IN (?) AND (job_flat_table.StateID IS NULL OR job_flat_table.StateID = 0))) ORDER BY yearupdated desc, doy desc, job_flat_table.jobid desc
SQLPARAMETERS
array
1 [empty string]
2 [empty string]
3 [empty string]
4 [empty string]
5 [empty string]
6 [empty string]
7 [empty string]
8 1
9 2
10 15
11 15