查询用户活跃度表登录间隔30天的用户

活跃度表：kb_user_view

CREATE TABLE `kb_user_view` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长ID',
  `cid` char(12) NOT NULL COMMENT '用户客户端ID',
  `is_del` tinyint(1) NOT NULL COMMENT '数据状态：0正常 1冻结',
  `add_time` int(10) NOT NULL COMMENT '数据写入时间',
  `add_ip` varchar(48) NOT NULL COMMENT '数据写入IP集',
  `up_time` int(10) NOT NULL COMMENT '数据更新时间',
  `up_ip` varchar(48) NOT NULL COMMENT '数据更新IP集',
  `view_date` varchar(255) NOT NULL COMMENT '日期字段   yyyy-mm-dd',
  `user_id` char(12) NOT NULL COMMENT '用户ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `view_date_user_id` (`view_date`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=412 DEFAULT CHARSET=utf8 COMMENT='';

SQL:

SELECT
	a.user_id,
	a.view_date,
	b.view_date 
FROM
	kb_user_view AS a
	INNER JOIN kb_user_view AS b ON a.user_id = b.user_id 
WHERE
	b.add_time = ( SELECT MIN( add_time ) FROM kb_user_view WHERE user_id = a.user_id 
                                                           AND add_time > a.add_time ) 
	AND b.view_date >= date_add( a.view_date, INTERVAL 30 DAY )