query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
---|---|---|---|
New Home Sales Assistant
Avondale, Arizona
|
Avondale, Arizona | Full-Time | Corporate Staffing |
New Home Sales Assistant
Buckeye, Arizona
|
Buckeye, Arizona | Full-Time | Corporate Staffing |
New Home Sales Assistant
Chandler, Arizona
|
Chandler, Arizona | Part-Time, Temporary | New Home Sales |
Licensed Real Estate Agent - New Home Sales Assistant
Glendale, Arizona
|
Glendale, Arizona | Part-Time, Temporary | New Home Sales |
Real Estate Agent-New Home Sales (Licensed)
Glendale, Arizona
|
Glendale, Arizona | Full-Time | Corporate Staffing |
Apartment Handyman/Maintenance
Mesa, Arizona
|
Mesa, Arizona | Part-Time, Temporary | Maintenance |
Real Estate Agent-New Home Sales (Licensed)
Mesa, Arizona
|
Mesa, Arizona | Full-Time | Corporate Staffing |
New Home Sales Assistant
North Scottsdale, Arizona
|
North Scottsdale, Arizona | Part-Time, Temporary | New Home Sales |
Apartment Handyman/Maintenance
Phoenix, Arizona
|
Phoenix, Arizona | Part-Time, Temporary | Maintenance |
New Home Sales Assistant
Queen Creek, Arizona
|
Queen Creek, Arizona | Part-Time, Temporary | New Home Sales |
Real Estate Agent-New Home Sales (Licensed)
Queen Creek, Arizona
|
Queen Creek, Arizona | Part-Time, Temporary | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales
Scottsdale, Arizona
|
Scottsdale, Arizona | Part-Time, Temporary | New Home Sales |
Apartment Leasing Consultant (Experienced)
Tempe, Arizona
|
Tempe, Arizona | Full-Time | Multi-Family |
Licensed Real Estate Agent - New Home Sales Assistant
Tempe, Arizona
|
Tempe, Arizona | Part-Time, Temporary | New Home Sales |