SELECT PartnerID ,QQ_LOGIN_APPID, QQ_LOGIN_APPKEY, WB_LOGIN_APPID, WB_LOGIN_APPKEY, WC_LOGIN_APPID, WC_LOGIN_APPKEY ,QQ_LOGIN_SECRET, WB_LOGIN_SECRET, WC_LOGIN_SECRET FROM T_CONFIG_DOMAIN WHERE DOMAIN='hizmall.com'

spGetConfig

SELECT USDExchange, CNYExchange, JPYExchange FROM T_CONFIG_EXCHANGE WHERE SiteID='hanguoshopping' ORDER BY UID DESC

SELECT LanguageCode FROM T_CONFIG_LANGUAGE WHERE Flag=?

SELECT AgencyID, AgencyUse FROM T_PARTNER WHERE PartnerID = 'hizmall'

SELECT Domain FROM T_PARTNER WHERE PartnerID = ''

SELECT SubDomain, BrowerTitle, Email, PartnerName, SiteName, EndDate, State,ServiceCode, IsFavicon, MetaTag, Description, Keyword, isGoodsWatermark, goodsWatermarkImg, IsSerial, SerialNum, IsAPP, googleTag FROM T_PARTNER WHERE SiteID='hanguoshopping' AND PartnerID=?

select CeoName, ChName, Email, PartnerName, Addr, AddrDetail, Tel, Fax, BizNo, MobileTopBgColor, MobileTopButtonColor, MobileTopTextColor ,joinType from T_PARTNER where siteID=? and partnerID=?

select CeoName, TongsinNo from T_CONFIG_COMPANY where siteID=?

select domain from T_CONFIG_DOMAIN where siteID='hanguoshopping' AND isBaseDomain='T'

SELECT ShippingPolicy FROM T_CONFIG_MANAGE WHERE SiteID = 'hanguoshopping'

SELECT goods_uid FROM T_GIVEID_LIST WHERE ( PartnerID is null OR PartnerID = 'hizmall' ) AND guse='Y' ORDER BY gwid ASC

SELECT goods_uid FROM T_GIVEAWAY_LIST WHERE guse='Y' ORDER BY gwid ASC

SELECT BankName, BankAccount, BankDepositary FROM T_CONFIG_PAY WHERE SiteID='hanguoshopping'

SELECT BoardType, IsDealerUse, Title, InfoText, PageSize, Width, SubjectLimit, IsSecret, IsComment, IsReply, IsReplyEmail, AmtByLine, ThumbWidth, ThumbHeight, IsUseGroup, IsUploadImg, IsUploadFile, UploadSizeLimit, PermList, PermListLevelUid, PermReg, PermRegLevelUid, PermView, PermViewLevelUid, PermComment, PermCommentLevelUid, TopMenu, CopyRight, Filtering FROM T_BOARD_CONFIG WHERE SiteID='hanguoshopping' AND BoardID=? AND IsTrash='F'

SELECT ISNULL(PageSeq, 0) FROM T_MAIN_PAGE WHERE SiteID = 'hanguoshopping' AND PageCode = 'MAIN' AND IsFix = 'Y'

select count(*) as cnt from T_GOODS_TAG_SEARCH where RegDate>DATEADD(MINUTE, -5, GETDATE())

select TOP 3 tagName from T_GOODS_TAG_SEARCH order by Tmuid asc

SELECT TOP 10 * FROM T_ISSUMER_RANK2 where PartnerID='hizmall' and Rnum=1 ORDER BY RANK asc

SELECT IsLeftMenu, Area, title FROM T_BOARD_CONFIG WHERE SiteID='hizmall' AND BoardID=?

SELECT GroupUid, Subject, WriterType, Writer, AdminID, UserID, DealerID, Email, Pass, Content, Gid, Depth, Thread, AttachImg, AttachPds, AttachPdsSize, AttachPdsDownCnt, IsNotice, IsSecret, ReadCnt, RegDate FROM T_BOARD WHERE SiteID='hanguoshopping' AND BoardID=? AND Uid=? AND IsTrash='F'