SELECT GoodsType, DealerID, GoodsCode, Title, Title_CH, SubTitle, ImgB, ImgM, ImgS, DollarMoney, Price, BuyPrice, OriginalPrice, dbo.fnGetFinalPrice(MemberPrice, G.Uid, '') As GMemberPrice, MarketPrice, PriceSplit, CmsType, Margin, Cmoney, Stock, Product, PlaceOfOrigin, ContentFile, IsDelContentFile, DeliveryPolicy, DeliveryMethod, DeliveryFee, DeliveryLimit, OptionKind, OptionTxt, IsIconA, IsIconB, IsIconC, IsIconD, IsIconE, IsIconF, IsDisplay, IsSoldOut, State, OrgUid, Content_ch, DeliveryContent, dbo.fnCheckEventDiscount(G.SiteID, G.Uid, GETDATE()) AS EventDiscountPrice, ImgserverUrl, ImgserverFolder, (SELECT Name_en FROM T_BRAND WHERE SiteID=G.SiteID AND Uid=G.BrandUid) AS Brand, content, weight, isOver, (select shippingType from T_CATEGORY where CateCode=GT.CateCode) as shippingType , title_en, weightUnit, eaUnit, modelNo, spec, element, effect, purpose, weight2, deliveryType, branduid, GC.player , G.isCount, G.goodsCount , G.DeliveryEach, G.barcode, G.StoreName , GC.Content_STEXT, GC.Cs_use FROM V_GOODS AS G JOIN T_GOODS_CONTENT AS GC ON G.Uid=GC.Uid JOIN T_GOODS_CATEGORY AS GT ON G.uid=GT.goodsUid AND GT.sort=1 WHERE G.SiteID='hanguoshopping' AND G.Uid=? AND GT.CateCode NOT IN (SELECT CateCode FROM fnGetCateChild('hanguoshopping', 7743, 0)) AND GT.CateCode NOT IN (SELECT CateCode FROM fnGetCateChild('hanguoshopping', 7751, 0)) AND GT.CateCode NOT IN (SELECT CateCode FROM fnGetCateChild('hanguoshopping', 16736, 0)) AND GT.CateCode NOT IN (SELECT CateCode FROM fnGetCateChild('hanguoshopping', 7503, 0)) AND GT.CateCode NOT IN (SELECT CateCode FROM fnGetCateChild('hanguoshopping', 7634, 0)) AND GT.CateCode NOT IN (SELECT CateCode FROM fnGetCateChild('hanguoshopping', 16544, 0)) AND G.Uid NOT IN (select goods_uid from T_GIVEAWAY_LIST where guse='Y')