SQL:select ID,GoodsBriefIntroduction,GoodsGive,GoodsDeduct,GoodsName from [lodo_Goods] where (GoodsLookOverAuthority='All' Or (GoodsLookOverAuthority='nouser' And 0=0) Or (GoodsLookOverAuthority='AllUser' And 0<>0) Or ( GoodsLookOverAuthority<>'All' And GoodsLookOverAuthority<>'AllUser' And GoodsLookOverAuthority<>'nouser' And (Not GoodsLookOverAuthority like '%,0,%') And (0<>0))) and goodsType<>'|0|0|0|0|0|' and Issueno=1 and (AutomaticLowerShelfno=0 or ( AutomaticLowerShelfno=1 and ExpiryDate>=#2026-4-6# ) )  and GoodsName like '%摄影技æ³%' Order By  Preface ,ID Desc<br />Sql³ö´í£ºÄÚ´æÒç³ö<br />²éѯÊý¾ÝµÄʱºò·¢ÏÖ´íÎó£¬Çë¼ì²éÄúµÄ²éѯ´úÂëÊÇ·ñÕýÈ·¡£