i want list users have particular event count i'm confused on approach take. this database table: create table `event` ( `event_id` int(11) unsigned not null auto_increment, `visitor_id` int(11) default null, `key` varchar(200) default null, `value` text, `label` varchar(200) default '', `datetime` datetime default null, primary key (`event_id`) ) engine=innodb auto_increment=6 default charset=utf8; insert `event` (`event_id`, `visitor_id`, `key`, `value`, `label`, `datetime`) values (1, 1, 'login', null, '', null), (2, 2, 'login', null, '', null), (3, 1, 'view_page', 'hotel', '', null), (4, 2, 'view_page', 'hotel', '', null), (5, 1, 'purchase_hotel', null, '', null); create table `visitor` ( `visitor_id` int(11) unsigned not null auto_increment, `datetime` datetime default null, primary key (`visitor_id`) ) engine=innodb auto_...