22,209
社区成员
发帖
与我相关
我的任务
分享
exec AdvanceSearch ' where p.Status = 1 and ( ( p.ProductID like ''%护肤%''
or p.ProductName like ''%护肤%''
or p.ProductWebName like ''%护肤%''
or p.Keywords like ''%护肤%''
or m.BrandName like ''%护肤%''
or c3.C3Name like ''%护肤%'' ) or ( p.ProductID like ''%美白%''
or p.ProductName like ''%美白%''
or p.ProductWebName like ''%美白%''
or p.Keywords like ''%美白%''
or m.BrandName like ''%美白%''
or c3.C3Name like ''%美白%'' )) and 1 = 1 and 1 = 1 and c2.SysNo = 9',' Order by pe.isstockout',12,0
exec AdvanceSearch ' where p.Status = 1 and ( ( p.ProductID like ''%护肤%''
or p.ProductName like ''%护肤%''
or p.ProductWebName like ''%护肤%''
or p.Keywords like ''%护肤%''
or m.BrandName like ''%护肤%''
or c3.C3Name like ''%护肤%'' ) or ( p.ProductID like ''%美白%''
or p.ProductName like ''%美白%''
or p.ProductWebName like ''%美白%''
or p.Keywords like ''%美白%''
or m.BrandName like ''%美白%''
or c3.C3Name like ''%美白%'' )) and 1 = 1 and 1 = 1 and c2.SysNo = 9',' Order by pe.isstockout',12,0
exec AdvanceSearch
' where p.Status = 1 and
(
(
p.ProductID like ''%护肤%''
or p.ProductName like ''%护肤%''
or p.ProductWebName like ''%护肤%''
or p.Keywords like ''%护肤%''
or m.BrandName like ''%护肤%''
or c3.C3Name like ''%护肤%''
) or
(
p.ProductID like ''%美白%''
or p.ProductName like ''%美白%''
or p.ProductWebName like ''%美白%''
or p.Keywords like ''%美白%''
or m.BrandName like ''%美白%''
or c3.C3Name like ''%美白%'' )
)
)
and 1 = 1 and 1 = 1 and c2.SysNo = 9 ' ,
' Order by pe.isstockout',
12,
0
exec AdvanceSearch
' where p.Status = 1 and
(
(
p.ProductID like ''%护肤%''
or p.ProductName like ''%护肤%''
or p.ProductWebName like ''%护肤%''
or p.Keywords like ''%护肤%''
or m.BrandName like ''%护肤%''
or c3.C3Name like ''%护肤%''
) or
(
p.ProductID like ''%美白%''
or p.ProductName like ''%美白%''
or p.ProductWebName like ''%美白%''
or p.Keywords like ''%美白%''
or m.BrandName like ''%美白%''
or c3.C3Name like ''%美白%'' )
)
) --貌似这里少了个 )
and 1 = 1 and 1 = 1 and c2.SysNo = 9 ' ,
' Order by pe.isstockout',
12,
0