DataClient : FalseSELECT TOP 60 * FROM vwVeStock v WITH (NOLOCK) inner 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 [date], make, model, grade, v.stockID Stock  -  Enhance Auto

*** DEV ***

Sign In
or
Click Here to Join! 		         user name:
password:
           English   Русский Home Stock
(i)About This Page   
Japan: Sat, Dec 6, 14:48           ¥ 

                             
Stock Search > Results
No favourites .

To add favourites, click anywhere in a car row or car box.
A favourites list is an easy way to remember cars, or to create a customized list of cars.
It is similar to a shopping list or a wish list.







  Enhance-Auto.net        Contact         Report problem         Hide Help