select uid,s.pid,p.productname from t_product as p join (select uid,pid from t_search group by uid,pid having count(*)>=3)as s on s.pid=p.pid and uid not in(select uid from t_order as o);
点赞 评论

相关推荐

牛客网
牛客企业服务