22,300
社区成员




加两个表:
黑店表(badshop): userid,shopid,crdate
黑货表(badprod): userid,prodid,crdate
示例:某用户查询他想看到的商品的关键语句:
select * from
(
select *,rn=row_number() over(order by xx)
from 你原来的结果集 a
left join badprod b on b.userid=@userid and a.prodid=b.prodid
where 你原来的条件集 and b.prodid is null
) t
where rn between 100 and 110