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

Sunnyvale Moose 2049

Sunnyvale Moose Event Calendar
DEVELOPMENT

[ Production Site ]


Event Calendar  |  Facebook  |  Feedback  |  Home  |  Login  |  Newsletters  |  Roles

Entering List Future

Array
(
    [Action] => List Future
    [hostgroup_id] => 19
    [start_time] => 20:00
)

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-30' AND e.hostgroup_id='19' AND e.start_time='20:00' 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: Host Group is Dance Events, Start Time is 20:00
Query returned 6 entries.

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

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

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

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

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

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

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

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

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

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

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

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

Day Event Date Event Name Host Group Start Time
Fri
Jan 9, 2026
Dance: Moose Big Band
Dance Events
20:00 (8:00 PM)
Fri
Jan 23, 2026
Dance: Moose Big Band
Dance Events
20:00 (8:00 PM)
Fri
Feb 13, 2026
Dance: Moose Big Band
Dance Events
20:00 (8:00 PM)
Fri
Feb 27, 2026
Dance: Moose Big Band
Dance Events
20:00 (8:00 PM)
Fri
Mar 13, 2026
Dance: Moose Big Band
Dance Events
20:00 (8:00 PM)
Fri
Mar 27, 2026
Dance: Moose Big Band
Dance Events
20:00 (8:00 PM)

Entering spew_footer

Event Calendar  |  Facebook  |  Feedback  |  Home  |  Login  |  Newsletters  |  Roles
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