Query
Template: C:\backatyou\code\sites\iqquery.cfc:247
Execution Time: 1.29 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
SELECT IS_COMPANY_LISTING = (
CASE
WHEN (companyid = 'bay_staging') THEN (1)
ELSE (0)
END
)
,IS_OFFICE_LISTING = CASE WHEN (A.OfficeID in ('CBSC25','CBSC27','CBSC26','298287','000023','Josh01','144183','311685','morg001','CBAQ01','64286','TestEPS3','TestEPS1','TestEPS2','gb001','Green001','Hen001','14624','KS','mon001','NLV01','jrtre','1073822','ren001','ross001','CBAQ02','SUT195')) THEN (1) ELSE (0) END
,IS_AGENT_LISTING = (
CASE
WHEN (
LEN('1073822') > 0
AND (
L.PublicID IN ('1073822')
OR
L.SecondPublicID IN ('1073822')
)
) THEN (1)
ELSE (0)
END
)
,l.id
,0 AS Distance
FROM Listings l WITH (NOLOCK)
LEFT JOIN Agents A WITH (NOLOCK)
ON A.PublicID = L.PublicID AND A.[Status] = 'A'
WHERE
l.id IN (198339)
ORDER BY
IS_OFFICE_LISTING DESC,
l.list_price desc,
ml_number ASC
IS_COMPANY_LISTINGIS_OFFICE_LISTINGIS_AGENT_LISTINGidDistance
11101983390