日期:2014-05-16 浏览次数:20405 次
select user_id, count(new_user_id) from award_reg_record arr where not exists (select user_id from award_get_record agr where agr.user_id=arr.user_id and agr.item_id=101) group by user_id having count(*) > 5
select user_id, count(new_user_id) from award_reg_record arr where user_id not in (select user_id from award_get_record agr where agr.item_id=101) group by user_id having count(*) > 5