3K5p3wF7

1SELECT COUNT( id ) AS count
2FROM members_customer_id_1
3WHERE id
4IN (
5
6SELECT members_in_group.member_id
7FROM members_in_group, member_groups
8WHERE members_in_group.member_group_id = member_groups.id
9AND member_groups.member_group_category_id =3
10GROUP BY members_in_group.member_id
11)
12	
13CREATE TABLE IF NOT EXISTS `members_customer_id_1` (
14  `id` int(10) NOT NULL AUTO_INCREMENT,
15  `name` varchar(100) COLLATE latin1_danish_ci NOT NULL DEFAULT '',
16  `email` varchar(100) COLLATE latin1_danish_ci NOT NULL DEFAULT '',
17  `mobile` bigint(16) NOT NULL,
18  `zipcode` varchar(10) COLLATE latin1_danish_ci NOT NULL DEFAULT '',
19  `sex` varchar(1) COLLATE latin1_danish_ci NOT NULL DEFAULT '',
20  `address` varchar(100) COLLATE latin1_danish_ci NOT NULL DEFAULT '',
21  `city` varchar(100) COLLATE latin1_danish_ci NOT NULL DEFAULT '',
22  `country_id` int(10) NOT NULL,
23  `birthday` date NOT NULL DEFAULT '0000-00-00',
24  `disable_welcome_message` int(1) NOT NULL,
25  `disable_birthday_message` int(1) NOT NULL,
26  `confirmed` int(1) NOT NULL,
27  `joined` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
28  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
29  `deleted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
30  `origin_type_id` int(10) NOT NULL,
31  PRIMARY KEY (`id`)
32) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci AUTO_INCREMENT=39 ;
33
34CREATE TABLE IF NOT EXISTS `member_groups` (
35  `id` int(10) NOT NULL AUTO_INCREMENT,
36  `customer_id` int(11) NOT NULL,
37  `name` varchar(100) COLLATE latin1_danish_ci NOT NULL,
38  `member_group_category_id` int(11) NOT NULL,
39  `hidden` int(1) NOT NULL,
40  PRIMARY KEY (`id`)
41) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci AUTO_INCREMENT=568 ;
42
43CREATE TABLE IF NOT EXISTS `members_in_group` (
44  `id` int(10) NOT NULL AUTO_INCREMENT,
45  `member_id` int(10) NOT NULL,
46  `member_group_id` int(10) NOT NULL,
47  PRIMARY KEY (`id`),
48  KEY `member_id` (`member_id`)
49) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci AUTO_INCREMENT=421609 ;
50	
51SELECT COUNT(*) AS count
52FROM members_customer_id_1
53JOIN members_in_group ON members_customer_id_1.id = members_in_group.member_id
54JOIN member_groups ON members_in_group.member_group_id = member_groups.id
55WHERE member_groups.member_group_category_id =3