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
left join ( select vid as ofrvid, cost as ofrcost, [time] as ofrdt from bid WITH (NOLOCK) where uid = -1 ) ofr on v.vid = ofr.ofrvid
inner join ( select rgnID, VID as rgnVID, price as rgnPrice, currency as rgnCurrency from regionConfig WITH (NOLOCK) where rgnID = 253) rc ON v.VID = rgnVID
WHERE siteConfig_CID = 31
and v.aid = 31
and owner_UID = 0
and not ( v.chassis = 'UNKNOWN' and v.year = 0 )
order by dateInserted DESC, lotno DESC, v.stockID
Stock - Enhance Auto
