 CREATE INDEX idx_user_info_kbase_internal_user ON user_info (kb_internal_user);
 
 CREATE INDEX idx_user_info_signup_date ON user_info (signup_date);
+
+CREATE INDEX idx_user_info_last_signin_date ON user_info (last_signin_date);
 
 CREATE INDEX idx_user_info_institution ON user_info (institution);
 

from user_system_summary_stats u_fdate
group by u_fdate.username) as user_date
where usss.username = user_date.username
and usss.record_date = user_date.mindate;
	institution VARCHAR(255),
	country VARCHAR(255), 
	signup_date TIMESTAMP NOT NULL,
	last_signin_date DATE,
	PRIMARY KEY ( username )) ENGINE=InnoDB  DEFAULT CHARSET=utf8; 


