query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQL | SELECT A.ID, A.MetroAreaID, A.Title, A.Duties, A.Requirements, A.ExternalLink, A.ShortDescription, A.DateAdded, A.DateEnding, A.DutiesIntro, B.ID AS LocationID, B.Name AS LocationName, C.Name AS MetroAreaName, C.ID AS MetroAreaID, C.Zip, C.City, C.State, A.JobsTypeID, JobsType.Name AS JobsTypeName, c.address, c.zip FROM Jobs AS A INNER JOIN JobsType ON A.JobsTypeID = JobsType.ID LEFT OUTER JOIN MetroArea AS C ON A.MetroAreaID = C.ID LEFT OUTER JOIN Locations AS B ON C.LocationID = B.ID Where a.id = ? | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQLPARAMETERS |
|
Looking for your next Maintenance Tech position? We have multiple opportunities readily available!
We’re hiring Maintenance Techs with basic experience in plumbing, electrical, and general maintenance that can complete apartment turnovers/make-readies and work orders.
Full-time, temp-to-hire, and temporary opportunities with Property Management Companies looking for skilled, responsible, customer-service oriented, and dependable Maintenance Technicians like you!
Pay Rate: $25 - $26/hr
---------------------------------------
JWilliams Staffing, Inc. An Equal Opportunity Employer M/F/Disability/Veterans. Qualified applicants with criminal histories will be considered for employment in a manner consistent with Federal, state, and local laws, including but not limited to local Fair Chance Ordinances. JWilliams Staffing participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the US. JWilliams Staffing complies with all federal E-Verify rules and responsibilities, and provides required federal postings in an electronic format to all candidates and employees via the JWS online portal.