select G.Uid, 69653 as CateCode, G.DealerID, G.Title, G.ImgS, G.Price, G.Cmoney, G.OptionKind, G.Stock, G.ReadCnt, G.OpinionRate, G.IsSoldOut, 0 AS ChkCoupon, G.DeliveryPolicy, G.DeliveryMethod, G.DeliveryFee, G.DeliveryLimit, G.IsIconA, G.IsIconB, G.IsIconC, G.IsIconD, G.IsIconE, G.IsIconF, 0 AS EventDiscountPrice, G.subtitle,G.staffprice,G.marketprice, '' as player,brandName, G.sort AS sort, row_number() OVER(ORDER BY G.sort DESC) AS rowNum, 0 AS P_IDX, G.GoodsCode,brandname_en,IsUnit, StockImminent , G.foreign_goods,G.IsClosing,G.IsMaxBuy,G.Md_score,G.SaleCnt from V_GOODS AS G LEFT OUTER JOIN ( select uid,name as brandName,name_en as brandname_en from t_brand(NOLOCK) ) TB ON TB.uid=G.brandUid where G.SiteID='mansaok365' AND G.GoodsType in ('N', 'C', 'B') AND ( G.State='100' )AND G.IsReturn='F' AND G.IsDisplay='T' AND G.IsOnlySearch = 'F' AND isnull(G.IsClosing,'F')<>'T' AND G.uid in(select goodsUid from T_goods_category where cateCode in(select cateCode from Fngetcatechild('mansaok365', 69653, 0) ))