Events Calendar

(default) 250 queries took 104 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous' AND `Event`.`Types` IS NOT NULL	1	1	1
2	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
3	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Longmire Days' AND `Event`.`Types` IS NOT NULL	1	1	0
4	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
5	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bighorn Mountain Festival' AND `Event`.`Types` IS NOT NULL	1	1	1
6	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
7	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Longmire Days 5K & Fun Run!' AND `Event`.`Types` IS NOT NULL	1	1	0
8	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
9	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Lovin Junkin' AND `Event`.`Types` IS NOT NULL	1	1	0
10	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
11	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL	1	1	1
12	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
13	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kiwanis Pancake Breakfast' AND `Event`.`Types` IS NOT NULL	1	1	0
14	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
15	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Quilting Gals' AND `Event`.`Types` IS NOT NULL	1	1	1
16	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
17	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Lovin Junkin' AND `Event`.`Types` IS NOT NULL	1	1	0
18	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
19	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL	1	1	1
20	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
21	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Dale Ann Bradley @ the Historic Occidental Saloon' AND `Event`.`Types` IS NOT NULL	1	1	0
22	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
23	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Moose Lodge #2675 Breakfast' AND `Event`.`Types` IS NOT NULL	1	1	0
24	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
25	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'American Legion & Auxiliary Breakfast' AND `Event`.`Types` IS NOT NULL	1	1	1
26	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
27	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Lovin Junkin' AND `Event`.`Types` IS NOT NULL	1	1	0
28	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
29	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Live Music by Dale Ann Bradley' AND `Event`.`Types` IS NOT NULL	1	1	0
30	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
31	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Free Haircuts for Hope' AND `Event`.`Types` IS NOT NULL	1	1	0
32	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
33	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kiwanis Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
34	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
35	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kickboxing Cardio Class' AND `Event`.`Types` IS NOT NULL	1	1	1
36	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
37	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous & Al-Anon Family Group' AND `Event`.`Types` IS NOT NULL	1	1	1
38	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
39	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Lions Club' AND `Event`.`Types` IS NOT NULL	1	1	1
40	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
41	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Hospital Auxiliary' AND `Event`.`Types` IS NOT NULL	0	0	1
42	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IS NULL	0	0	0
43	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Rotary Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
44	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
45	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Public Tours- Mountain Meadow Wool' AND `Event`.`Types` IS NOT NULL	1	1	1
46	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
47	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Planning Commission Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
48	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (4)	1	1	0
49	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Club Read' AND `Event`.`Types` IS NOT NULL	1	1	0
50	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
51	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Cowgirls Tuesday Night Rodeos' AND `Event`.`Types` IS NOT NULL	1	1	0
52	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
53	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'American Legion & Auxiliary Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
54	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
55	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Featured Music and Open Mic Night' AND `Event`.`Types` IS NOT NULL	1	1	1
56	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
57	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Wednesday Night Rodeo' AND `Event`.`Types` IS NOT NULL	1	1	0
58	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (10)	1	1	0
59	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Yoga Class' AND `Event`.`Types` IS NOT NULL	1	1	1
60	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
61	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Hot Rodders & Bikers Gathering' AND `Event`.`Types` IS NOT NULL	1	1	1
62	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
63	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Evening Meditations' AND `Event`.`Types` IS NOT NULL	1	1	1
64	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
65	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Story Hour' AND `Event`.`Types` IS NOT NULL	1	1	1
66	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
67	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Caregiver Support Group' AND `Event`.`Types` IS NOT NULL	1	1	1
68	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
69	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Public Tours- Mountain Meadow Wool' AND `Event`.`Types` IS NOT NULL	1	1	1
70	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
71	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'BINGO' AND `Event`.`Types` IS NOT NULL	1	1	1
72	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
73	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Understanding Grief Support Group' AND `Event`.`Types` IS NOT NULL	1	1	1
74	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
75	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Jaycees - Monthly Meetings' AND `Event`.`Types` IS NOT NULL	2	2	0
76	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (12, 9)	2	2	0
77	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Jaycees - Monthly Meetings' AND `Event`.`Types` IS NOT NULL	2	2	0
78	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (12, 9)	2	2	0
79	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Jam Session ' AND `Event`.`Types` IS NOT NULL	2	2	1
80	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (3, 2)	2	2	0
81	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Buffalo Military Support Group' AND `Event`.`Types` IS NOT NULL	1	1	0
82	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
83	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous' AND `Event`.`Types` IS NOT NULL	1	1	1
84	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
85	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Jaycees - Kaycee Ranch Rodeo ' AND `Event`.`Types` IS NOT NULL	1	1	0
86	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
87	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL	1	1	1
88	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
89	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Cowboy Tough Adventure Races' AND `Event`.`Types` IS NOT NULL	1	1	0
90	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
91	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Community All Day Sew' AND `Event`.`Types` IS NOT NULL	1	1	0
92	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
93	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL	1	1	1
94	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
95	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Moose Lodge #2675 Breakfast' AND `Event`.`Types` IS NOT NULL	1	1	0
96	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
97	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kiwanis Meeting' AND `Event`.`Types` IS NOT NULL	1	1	2
98	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
99	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kickboxing Cardio Class' AND `Event`.`Types` IS NOT NULL	1	1	1
100	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
101	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous & Al-Anon Family Group' AND `Event`.`Types` IS NOT NULL	1	1	1
102	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
103	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Anchor Masonic Lodge' AND `Event`.`Types` IS NOT NULL	1	1	1
104	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
105	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'County Commissioners Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
106	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (4)	1	1	0
107	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Rotary Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
108	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
109	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Public Tours- Mountain Meadow Wool' AND `Event`.`Types` IS NOT NULL	1	1	1
110	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
111	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'City Council Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
112	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (4)	1	1	0
113	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Visual Artists Jam' AND `Event`.`Types` IS NOT NULL	1	1	1
114	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
115	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Featured Music and Open Mic Night' AND `Event`.`Types` IS NOT NULL	1	1	1
116	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
117	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Wednesday Night Rodeo' AND `Event`.`Types` IS NOT NULL	1	1	0
118	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (10)	1	1	0
119	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Writers Ink' AND `Event`.`Types` IS NOT NULL	2	2	1
120	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (9, NULL)	1	1	0
121	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Yoga Class' AND `Event`.`Types` IS NOT NULL	1	1	1
122	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
123	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Evening Meditations' AND `Event`.`Types` IS NOT NULL	1	1	1
124	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	1
125	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Story Hour' AND `Event`.`Types` IS NOT NULL	1	1	1
126	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
127	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Caregiver Support Group' AND `Event`.`Types` IS NOT NULL	1	1	1
128	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
129	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Public Tours- Mountain Meadow Wool' AND `Event`.`Types` IS NOT NULL	1	1	1
130	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
131	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'BINGO' AND `Event`.`Types` IS NOT NULL	1	1	1
132	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
133	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Understanding Grief Support Group' AND `Event`.`Types` IS NOT NULL	1	1	1
134	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
135	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Jam Session ' AND `Event`.`Types` IS NOT NULL	2	2	1
136	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (3, 2)	2	2	0
137	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous' AND `Event`.`Types` IS NOT NULL	1	1	1
138	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
139	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Basque Festival: NABO' AND `Event`.`Types` IS NOT NULL	1	1	0
140	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
141	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL	1	1	1
142	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
143	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL	1	1	1
144	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
145	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Moose Lodge #2675 Breakfast' AND `Event`.`Types` IS NOT NULL	1	1	0
146	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
147	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kiwanis Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
148	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
149	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kickboxing Cardio Class' AND `Event`.`Types` IS NOT NULL	1	1	1
150	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
151	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous & Al-Anon Family Group' AND `Event`.`Types` IS NOT NULL	1	1	1
152	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
153	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Lions Club' AND `Event`.`Types` IS NOT NULL	1	1	1
154	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
155	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Rotary Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
156	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
157	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Public Tours- Mountain Meadow Wool' AND `Event`.`Types` IS NOT NULL	1	1	1
158	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
159	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'JCAHC Meeting' AND `Event`.`Types` IS NOT NULL	1	1	1
160	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
161	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Cowgirls Tuesday Night Rodeos' AND `Event`.`Types` IS NOT NULL	1	1	0
162	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
163	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Featured Music and Open Mic Night' AND `Event`.`Types` IS NOT NULL	1	1	1
164	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
165	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Wednesday Night Rodeo' AND `Event`.`Types` IS NOT NULL	1	1	0
166	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (10)	1	1	0
167	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Yoga Class' AND `Event`.`Types` IS NOT NULL	1	1	1
168	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0
169	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Hot Rodders & Bikers Gathering' AND `Event`.`Types` IS NOT NULL	1	1	1
170	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
171	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Evening Meditations' AND `Event`.`Types` IS NOT NULL	1	1	1
172	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
173	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Story Hour' AND `Event`.`Types` IS NOT NULL	1	1	1
174	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
175	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Caregiver Support Group' AND `Event`.`Types` IS NOT NULL	1	1	1
176	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
177	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Public Tours- Mountain Meadow Wool' AND `Event`.`Types` IS NOT NULL	1	1	1
178	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
179	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'BINGO' AND `Event`.`Types` IS NOT NULL	1	1	1
180	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)	1	1	0
181	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Understanding Grief Support Group' AND `Event`.`Types` IS NOT NULL	1	1	1
182	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
183	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Jam Session ' AND `Event`.`Types` IS NOT NULL	2	2	1
184	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (3, 2)	2	2	0
185	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Cowgirls Tuesday Night Rodeos' AND `Event`.`Types` IS NOT NULL	1	1	0
186	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)	1	1	0
187	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous' AND `Event`.`Types` IS NOT NULL	1	1	1
188	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)	1	1	0
189	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Chamber Coffee' AND `Event`.`Types` IS NOT NULL	2	2	1
190	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (3, NULL)	1	1	0
191	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Crazy Days' AND `Event`.`Types` IS NOT NULL	2	2	0
192	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (1, 3)	2	2	0
193	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL	1	1	1
194	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
195	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = '8th Annual Poker/Bug Run' AND `Event`.`Types` IS NOT NULL	1	1	0
196	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (10)	1	1	0
197	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL	1	1	1
198	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)	1	1	0
199	SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Moose Lodge #2675 Breakfast' AND `Event`.`Types` IS NOT NULL	1	1	0
200	SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)	1	1	0

(default) 250 queries took 104 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Longmire Days' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bighorn Mountain Festival' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Longmire Days 5K & Fun Run!' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Lovin Junkin' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kiwanis Pancake Breakfast' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Quilting Gals' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Lovin Junkin' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Dale Ann Bradley @ the Historic Occidental Saloon' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Moose Lodge #2675 Breakfast' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'American Legion & Auxiliary Breakfast' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Lovin Junkin' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Live Music by Dale Ann Bradley' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Free Haircuts for Hope' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kiwanis Meeting' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Kickboxing Cardio Class' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous & Al-Anon Family Group' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Lions Club' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Hospital Auxiliary' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IS NULL

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Rotary Meeting' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Public Tours- Mountain Meadow Wool' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Planning Commission Meeting' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (4)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Club Read' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Cowgirls Tuesday Night Rodeos' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'American Legion & Auxiliary Meeting' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Featured Music and Open Mic Night' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Wednesday Night Rodeo' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (10)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Yoga Class' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Hot Rodders & Bikers Gathering' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Evening Meditations' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Story Hour' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Caregiver Support Group' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Public Tours- Mountain Meadow Wool' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'BINGO' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (3)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Understanding Grief Support Group' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Jaycees - Monthly Meetings' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (12, 9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Jaycees - Monthly Meetings' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (12, 9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Jam Session ' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` IN (3, 2)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Buffalo Military Support Group' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Alcoholics Anonymous' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (12)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Johnson County Jaycees - Kaycee Ranch Rodeo ' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (9)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Bittercreek Band' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (2)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Cowboy Tough Adventure Races' AND `Event`.`Types` IS NOT NULL

SELECT `Type`.`Id`, `Type`.`flag`, `Type`.`Name` FROM `bufchamber_live`.`types` AS `Type` WHERE `Type`.`Id` = (1)

SELECT DISTINCT `Event`.`Types` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`Name` = 'Community All Day Sew' AND `Event`.`Types` IS NOT NULL