(DEV) List Future Events

get_field_labels:Table: event, Cullme: event

Language: US_English

get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'event' AND message_type = 'Field Label' AND language = 'US_English'

Row Count: 19

From get_fields_label Output from Message

Array
(
    [access_type] => Access Type
    [band_id] => Band
    [brochure_url] => Brochure Url
    [register_url] => Register Url
    [captain_id] => Captain Id
    [close_date] => Close Date
    [end_time] => End Time
    [event_date] => Event Date
    [event_details] => Event Details
    [event_id] => Event Id
    [event_keywords] => Event Keywords
    [event_name] => Event Name
    [event_type] => Event Type
    [guest_cost] => Guest Cost
    [hostgroup_id] => Host Group
    [location_id] => Where
    [member_cost] => Member Cost
    [photo_url] => Photo Url
    [start_time] => Start Time
)

get_field_labels:Table: event, Cullme: event

Language: US_English

get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'event' AND message_type = 'Field Label' AND language = 'US_English'

Row Count: 19

From get_fields_label Output from Message

Array
(
    [access_type] => Access Type
    [band_id] => Band
    [brochure_url] => Brochure Url
    [register_url] => Register Url
    [captain_id] => Captain Id
    [close_date] => Close Date
    [end_time] => End Time
    [event_date] => Event Date
    [event_details] => Event Details
    [event_id] => Event Id
    [event_keywords] => Event Keywords
    [event_name] => Event Name
    [event_type] => Event Type
    [guest_cost] => Guest Cost
    [hostgroup_id] => Host Group
    [location_id] => Where
    [member_cost] => Member Cost
    [photo_url] => Photo Url
    [start_time] => Start Time
)

(DEV) List Future Events

Entering List Future

Array
(
    [Action] => List Future
    [start_time] => 18:00
    [weekday] => Tue
)

Help and explanations available at Overview.

Select filters and click one of the green buttons below to see calendar events.

Weekday	Host Group	Date	Type	Sort By

get_field_labels:Table: event, Cullme: event

Language: US_English

get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'event' AND message_type = 'Field Label' AND language = 'US_English'

Row Count: 19

From get_fields_label Output from Message

Array
(
    [access_type] => Access Type
    [band_id] => Band
    [brochure_url] => Brochure Url
    [register_url] => Register Url
    [captain_id] => Captain Id
    [close_date] => Close Date
    [end_time] => End Time
    [event_date] => Event Date
    [event_details] => Event Details
    [event_id] => Event Id
    [event_keywords] => Event Keywords
    [event_name] => Event Name
    [event_type] => Event Type
    [guest_cost] => Guest Cost
    [hostgroup_id] => Host Group
    [location_id] => Where
    [member_cost] => Member Cost
    [photo_url] => Photo Url
    [start_time] => Start Time
)

SELECT DISTINCT e.*,v.location_name,a.weekday,h.hostgroup_name FROM event e, location v, allcal a, hostgroup h WHERE e.location_id = v.location_id AND e.event_date = a.calendar_date AND e.hostgroup_id = h.hostgroup_id AND e.event_date >= '2025-12-29' AND e.start_time='18:00' AND a.weekday = 'Tue' ORDER BY e.event_date, e.event_name

get_field_labels:Table: event, Cullme: event

Language: US_English

get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'event' AND message_type = 'Field Label' AND language = 'US_English'

Row Count: 19

From get_fields_label Output from Message

Array
(
    [access_type] => Access Type
    [band_id] => Band
    [brochure_url] => Brochure Url
    [register_url] => Register Url
    [captain_id] => Captain Id
    [close_date] => Close Date
    [end_time] => End Time
    [event_date] => Event Date
    [event_details] => Event Details
    [event_id] => Event Id
    [event_keywords] => Event Keywords
    [event_name] => Event Name
    [event_type] => Event Type
    [guest_cost] => Guest Cost
    [hostgroup_id] => Host Group
    [location_id] => Where
    [member_cost] => Member Cost
    [photo_url] => Photo Url
    [start_time] => Start Time
)

Column entries that are links will "drill down" to refine your query. Event name links will display event details.
Clicking on small blue icon after event name will take you to brochure.
Drill Down Query: Start Time is 18:00, Weekday is Tue
Query returned 13 entries.

SELECT * from allcal where calendar_date = '2026-01-13'

SELECT * from allcal where calendar_date = '2026-01-20'

SELECT * from allcal where calendar_date = '2026-01-27'

SELECT * from allcal where calendar_date = '2026-02-03'

SELECT * from allcal where calendar_date = '2026-02-10'

SELECT * from allcal where calendar_date = '2026-02-17'

SELECT * from allcal where calendar_date = '2026-02-24'

SELECT * from allcal where calendar_date = '2026-03-03'

SELECT * from allcal where calendar_date = '2026-03-10'

SELECT * from allcal where calendar_date = '2026-03-24'

SELECT * from allcal where calendar_date = '2026-03-31'

Day	Event Date	Event Name	Host Group	Start Time
Tue	Jan 13, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Jan 20, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Jan 27, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Feb 3, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Feb 10, 2026	Board Nomination Mtg	Exec Board	18:00 (6:00 PM)
Tue	Feb 10, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Feb 17, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Feb 24, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Mar 3, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Mar 10, 2026	Board Nomination Mtg	Exec Board	18:00 (6:00 PM)
Tue	Mar 10, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Mar 24, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)
Tue	Mar 31, 2026	Snack Bar	Social Quarters	18:00 (6:00 PM)

Entering spew_footer

Questions, feedback, or website issues; please let us know by filling out the feedback form or emailing Webmaster.
Last Modified: December 29 2025 @ 10:57 PST
Stats

From get_fields_label Output from Message

From get_fields_label Output from Message

Sunnyvale Moose Event Calendar
DEVELOPMENT

List Future Events

(Where Start Time is 18:00, Weekday is Tue)

From get_fields_label Output from Message

From get_fields_label Output from Message

From get_fields_label Output from Message

From get_fields_label Output from Message

Sunnyvale Moose Event CalendarDEVELOPMENT

List Future Events

(Where Start Time is 18:00, Weekday is Tue)

From get_fields_label Output from Message

From get_fields_label Output from Message

Sunnyvale Moose Event Calendar
DEVELOPMENT