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 |
---|---|---|---|
Apartment Leasing Consultant (Experienced)
Glendale, Arizona
|
Glendale, Arizona | Part-Time, Temporary | Corporate Staffing |
Custodian/Janitor Day Porter- Apartments
Glendale, Arizona
|
Glendale, Arizona | Part-Time, Temporary | Maintenance |
Maintenance Technician- Apartment Turns & Work Orders
Glendale, Arizona
|
Glendale, Arizona | Part-Time, Temporary | Corporate Staffing |
Model Home Sales Assistant
Glendale, Arizona
|
Glendale, Arizona | Part-Time, Temporary | Corporate Staffing |
Apartment Leasing Consultant (Experienced)
Mesa, Arizona
|
Mesa, Arizona | Part-Time, Temporary | Corporate Staffing |
Custodian/Janitor Day Porter- Apartments
Mesa, Arizona
|
Mesa, Arizona | Part-Time, Temporary | Maintenance |
Maintenance Technician- Apartment Turns & Work Orders
Mesa, Arizona
|
Mesa, Arizona | Part-Time, Temporary | Corporate Staffing |
Model Home Sales Assistant
Mesa, Arizona
|
Mesa, Arizona | Part-Time, Temporary | New Home Sales |
Apartment Leasing Consultant (Experienced)
North Scottsdale, Arizona
|
North Scottsdale, Arizona | Part-Time, Temporary | Corporate Staffing |
Custodian/Janitor Day Porter- Apartments
North Scottsdale, Arizona
|
North Scottsdale, Arizona | Part-Time, Temporary | Maintenance |
Maintenance Technician- Apartment Turns & Work Orders
North Scottsdale, Arizona
|
North Scottsdale, Arizona | Part-Time, Temporary | Corporate Staffing |
Model Home Sales Assistant
North Scottsdale, Arizona
|
North Scottsdale, Arizona | Part-Time, Temporary | New Home Sales |
Apartment Leasing Consultant (Experienced)
Phoenix, Arizona
|
Phoenix, Arizona | Part-Time, Temporary | Corporate Staffing |
Custodian/Janitor Day Porter- Apartments
Phoenix, Arizona
|
Phoenix, Arizona | Part-Time, Temporary | Multi-Family |
Maintenance Technician- Apartment Turns & Work Orders
Phoenix, Arizona
|
Phoenix, Arizona | Part-Time, Temporary | Corporate Staffing |
Model Home Sales Assistant
Phoenix, Arizona
|
Phoenix, Arizona | Part-Time, Temporary | Corporate Staffing |
Apartment Leasing Consultant (Experienced)
Queen Creek, Arizona
|
Queen Creek, Arizona | Part-Time, Temporary | Corporate Staffing |
Custodian/Janitor Day Porter- Apartments
Queen Creek, Arizona
|
Queen Creek, Arizona | Part-Time, Temporary | Multi-Family |
Maintenance Technician- Apartment Turns & Work Orders
Queen Creek, Arizona
|
Queen Creek, Arizona | Part-Time, Temporary | Corporate Staffing |
Model Home Sales Assistant
Queen Creek, Arizona
|
Queen Creek, Arizona | Part-Time, Temporary | New Home Sales |
Apartment Leasing Consultant (Experienced)
Scottsdale, Arizona
|
Scottsdale, Arizona | Part-Time, Temporary | Corporate Staffing |
Custodian/Janitor Day Porter- Apartments
Scottsdale, Arizona
|
Scottsdale, Arizona | Part-Time, Temporary | Corporate Staffing |
Maintenance Technician- Apartment Turns & Work Orders
Scottsdale, Arizona
|
Scottsdale, Arizona | Part-Time, Temporary | Corporate Staffing |
Model Home Sales Assistant
Scottsdale, Arizona
|
Scottsdale, Arizona | Part-Time, Temporary | New Home Sales |
Apartment Leasing Consultant (Experienced)
Surprise, Arizona
|
Surprise, Arizona | Full-Time | Multi-Family |
Custodian/Janitor Day Porter- Apartments
Surprise, Arizona
|
Surprise, Arizona | Part-Time, Temporary | Maintenance |
Maintenance Technician- Apartment Turns & Work Orders
Surprise, Arizona
|
Surprise, Arizona | Part-Time, Temporary | Corporate Staffing |
Model Home Sales Assistant
Surprise, Arizona
|
Surprise, Arizona | Full-Time, Temporary | New Home Sales |
Apartment Leasing Consultant (Experienced)
Tempe, Arizona
|
Tempe, Arizona | Part-Time, Temporary | Multi-Family |
Custodian/Janitor Day Porter- Apartments
Tempe, Arizona
|
Tempe, Arizona | Part-Time, Temporary | Maintenance |
Maintenance Technician- Apartment Turns & Work Orders
Tempe, Arizona
|
Tempe, Arizona | Part-Time, Temporary | Corporate Staffing |
Model Home Sales Assistant
Tempe, Arizona
|
Tempe, Arizona | Part-Time, Temporary | New Home Sales |