Hoofer Outing Club Events

Events for March 2010

14 events found.

March 2010
	1	2 19:00 HOC Spring Kickoff & Club Social! Please volunteer!	3	4	5 00:00 Aldo Leopold Weekend March 5-7	6 Aldo Leopold Weekend March 5-7 08:00 Saturday morning cycling 09:00 Volunteer Work Party at the UW-Arboretum
7 Aldo Leopold Weekend March 5-7	8 18:30 Samantha Reuter	9 15:00 Lady Liberty -- platform and torch need to be taken off the ice! 20:00 Let's talk about bikes!	10	11	12	13 08:00 Spring Fever Backpacking 12:00 Lady Liberty needs to be taken back to the farm 15:00 Feuerzangenbowle camping trip
14 Feuerzangenbowle camping trip Spring Fever Backpacking 12:00 Lady Liberty needs to be taken back to the farm II 13:30 Signs of spring bike ride (PLAY WITH BABY SHEEEEP!!!) 17:00 Canoecopia volunteers needed--free pass to the expo!	15	16	17	18	19	20
21	22	23	24	25	26 18:00 Utah Spring Break!!!	27 Utah Spring Break!!!
28 Utah Spring Break!!!	29 Utah Spring Break!!!	30 Utah Spring Break!!!	31 Utah Spring Break!!!

Filter events

Category

Subcategory

	Query	Time (ms)
1.	SELECT DISTINCT lessons.lesson_ID FROM lessons, lessonSchedules WHERE lessons.lesson_ID = lessonSchedules.lesson_ID AND lessons.visibility_ID IN (2,3,4,6,8) AND DATE(lessonSchedules.start) >= '2010-03-01' AND DATE(lessonSchedules.start) <= '2010-04-01' AND lessons.club_ID = 2 ORDER BY lessonSchedules.start ASC	0.77 ms
2.	SELECT lesson_ID, subcategory_ID, club_ID, template_ID, name, visibility_ID, numParticipants, numAlternates FROM lessons WHERE lesson_ID IN (20097,20095,20104,20107,20121,20147,20108,20106,20148,20216,20149,20217,20109,20102)	0.08 ms
3.	SELECT lesson_ID, firstName, lastName, inst_ID as id FROM users INNER JOIN lessonInst ON user_ID = inst_ID WHERE lesson_ID IN (20097,20095,20104,20107,20121,20147,20108,20106,20148,20216,20149,20217,20109,20102)	0.41 ms
4.	SELECT lesson_ID, start, end FROM lessonSchedules WHERE lesson_ID IN (20097,20095,20104,20107,20121,20147,20108,20106,20148,20216,20149,20217,20109,20102)	0.82 ms
5.	SELECT lesson_ID, alternate FROM userLessons WHERE lesson_ID IN (20097,20095,20104,20107,20121,20147,20108,20106,20148,20216,20149,20217,20109,20102)	0.07 ms
6.	SELECT l.subcategory_ID, l.name, l.group_ID FROM lessonSubCategories l INNER JOIN lessonGroups USING(group_ID) WHERE club_ID = 2 ORDER BY l.group_ID, l.name	0.07 ms
7.	SELECT group_ID, club_ID, name, isPublic, requires_auth FROM lessonGroups ORDER BY name	0.10 ms
8.	SELECT * FROM clubs	0.07 ms
9.	SELECT template_ID, subcategory_ID, shortCode, name, numDays, daysBetween, duration, numParticipants, numAlternates, description FROM lessonTemplates ORDER BY name	0.62 ms
10.	SELECT visibility_ID AS id, name, code, is_open FROM visibility ORDER BY visibility_ID;	0.07 ms

Query

Time (ms)

SELECT DISTINCT lessons.lesson_ID FROM lessons, lessonSchedules WHERE lessons.lesson_ID = lessonSchedules.lesson_ID AND lessons.visibility_ID IN (2,3,4,6,8) AND DATE(lessonSchedules.start) >= '2010-03-01' AND DATE(lessonSchedules.start) <= '2010-04-01' AND lessons.club_ID = 2 ORDER BY lessonSchedules.start ASC

0.77 ms

SELECT lesson_ID, subcategory_ID, club_ID, template_ID, name, visibility_ID, numParticipants, numAlternates FROM lessons WHERE lesson_ID IN (20097,20095,20104,20107,20121,20147,20108,20106,20148,20216,20149,20217,20109,20102)

0.08 ms

SELECT lesson_ID, firstName, lastName, inst_ID as id FROM users INNER JOIN lessonInst ON user_ID = inst_ID WHERE lesson_ID IN (20097,20095,20104,20107,20121,20147,20108,20106,20148,20216,20149,20217,20109,20102)

0.41 ms

SELECT lesson_ID, start, end FROM lessonSchedules WHERE lesson_ID IN (20097,20095,20104,20107,20121,20147,20108,20106,20148,20216,20149,20217,20109,20102)

0.82 ms

SELECT lesson_ID, alternate FROM userLessons WHERE lesson_ID IN (20097,20095,20104,20107,20121,20147,20108,20106,20148,20216,20149,20217,20109,20102)

0.07 ms

SELECT l.subcategory_ID, l.name, l.group_ID FROM lessonSubCategories l INNER JOIN lessonGroups USING(group_ID) WHERE club_ID = 2 ORDER BY l.group_ID, l.name

0.07 ms

SELECT group_ID, club_ID, name, isPublic, requires_auth FROM lessonGroups ORDER BY name

0.10 ms

SELECT * FROM clubs

0.07 ms

SELECT template_ID, subcategory_ID, shortCode, name, numDays, daysBetween, duration, numParticipants, numAlternates, description FROM lessonTemplates ORDER BY name

0.62 ms

10.

SELECT visibility_ID AS id, name, code, is_open FROM visibility ORDER BY visibility_ID;

0.07 ms

Hoofer Outing Club Events

User Login

Events

Events for March 2010

14 events found.