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 |
|
Please apply by clicking on the link below via LinkedIn for consideration.
Our client, specializing in residential properties(Tax Credit/HUD/Section 8/LIHTC/Permanent Supportive/HUD), is seeking a Community Manager to join their successful team. This is an excellent opportunity to join a positive and supportive company culture with a team of passionate individuals who are tied together by their unified mission of providing their residents with extraordinary experiences. They offer competitive compensation, benefits, and growth opportunities. Apply today to join this team of industry leaders!
Pay: $21.00/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.