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 |
|
Job Title | Location | Job Type | Category |
---|---|---|---|
Administrative Assistant Residential
Sacramento, California - Northern
|
Sacramento, California - Northern | Full-Time | Corporate Staffing |
Front Desk Clerk
Sacramento, California - Northern
|
Sacramento, California - Northern | Full-Time | Corporate Staffing |
Leasing Consultant - Hospitality Professional
Sacramento, California - Northern
|
Sacramento, California - Northern | Part-Time, Temporary | Multi-Family |
Licensed Real Estate Agent - New Home Sales Assistant
Sacramento, California - Northern
|
Sacramento, California - Northern | Part-Time, Temporary | New Home Sales |
Maintenance Tech - Apartment Turns & Work Orders
Sacramento, California - Northern
|
Sacramento, California - Northern | Full-Time, Temporary | Maintenance |