DataClient : FalseSELECT TOP 60 * FROM vwVeStock v WITH (NOLOCK)
LEFT join ( select VID as chk_VID, uid as chk_UID, listnum as chk_listnum from checklist WITH (NOLOCK) where uid = -1 ) PersonalChecklist on chk_VID = v.VID
LEFT JOIN ( select modelcode, make as mccs_make, low, avg, high from mCcsValue WITH (NOLOCK) ) mc ON (v.chassis = mc.modelcode OR v.chassis LIKE mc.modelcode + '-%') AND mc.mccs_make = v.make
inner join ( select rgnID, VID as rgnVID, price as rgnPrice, currency as rgnCurrency from regionConfig WITH (NOLOCK) where rgnID = 434) rc ON v.VID = rgnVID
INNER JOIN categoryConfig cat WITH (NOLOCK) on cat.VID = v.VID and cat.catID = 239
WHERE siteConfig_CID = 39
and v.aid = 39
and owner_UID = 0
and not ( v.chassis = 'UNKNOWN' and v.year = 0 )
order by [date], make, model, grade, v.stockID
Dealer Stock - Auto Portal
¥