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] => Contact
    [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] => Contact
    [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] => 23
    [member_cost] => 0
)

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] => Contact
    [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 >= '2026-06-29' AND e.hostgroup_id='23' AND e.member_cost='0' 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] => Contact
    [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 yellow icon will display brochure.
Drill Down Query: Host Group is Exec Board
Query returned 21 entries.

SELECT * from allcal where calendar_date = '2026-06-29'

SELECT * from allcal where calendar_date = '2026-06-29'

SELECT * from allcal where calendar_date = '2026-07-06'

SELECT * from allcal where calendar_date = '2026-07-06'

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

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

SELECT * from allcal where calendar_date = '2026-07-14'

SELECT * from allcal where calendar_date = '2026-07-14'

SELECT * from allcal where calendar_date = '2026-07-14'

SELECT * from allcal where calendar_date = '2026-07-14'

SELECT * from allcal where calendar_date = '2026-07-18'

SELECT * from allcal where calendar_date = '2026-07-18'

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

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

SELECT * from allcal where calendar_date = '2026-07-25'

SELECT * from allcal where calendar_date = '2026-07-25'

SELECT * from allcal where calendar_date = '2026-07-28'

SELECT * from allcal where calendar_date = '2026-07-28'

SELECT * from allcal where calendar_date = '2026-07-28'

SELECT * from allcal where calendar_date = '2026-07-28'

SELECT * from allcal where calendar_date = '2026-07-28'

SELECT * from allcal where calendar_date = '2026-07-28'

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

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

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

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

SELECT * from allcal where calendar_date = '2026-08-11'

SELECT * from allcal where calendar_date = '2026-08-11'

SELECT * from allcal where calendar_date = '2026-08-11'

SELECT * from allcal where calendar_date = '2026-08-11'

SELECT * from allcal where calendar_date = '2026-08-15'

SELECT * from allcal where calendar_date = '2026-08-15'

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

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

SELECT * from allcal where calendar_date = '2026-08-25'

SELECT * from allcal where calendar_date = '2026-08-25'

SELECT * from allcal where calendar_date = '2026-08-25'

SELECT * from allcal where calendar_date = '2026-08-25'

SELECT * from allcal where calendar_date = '2026-08-25'

SELECT * from allcal where calendar_date = '2026-08-25'

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

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

Day Event Date Event Name Host Group Member
Cost
Guest
Cost
Start Time
Mon
Jun 29, 2026
Lodge Closed

Exec Board



Mon
Jul 6, 2026
Lodge Closed

Exec Board



Mon
Jul 13, 2026
Lodge Closed

Exec Board



Tue
Jul 14, 2026
Board Mtg

Exec Board


19:00 (7:00 PM)
Tue
Jul 14, 2026
General Mtg

Exec Board


20:00 (8:00 PM)
Sat
Jul 18, 2026
Lodge Closed

Exec Board



Mon
Jul 20, 2026
Lodge Closed

Exec Board



Sat
Jul 25, 2026
Lodge Closed

Exec Board



Tue
Jul 28, 2026
Board Mtg

Exec Board


19:00 (7:00 PM)
Tue
Jul 28, 2026
General Mtg

Exec Board


20:00 (8:00 PM)
Tue
Jul 28, 2026
Joint Planning Mtg

Exec Board


18:30 (6:30 PM)
Mon
Aug 3, 2026
Lodge Closed

Exec Board



Mon
Aug 10, 2026
Lodge Closed

Exec Board



Tue
Aug 11, 2026
Board Mtg

Exec Board


19:00 (7:00 PM)
Tue
Aug 11, 2026
General Mtg

Exec Board


20:00 (8:00 PM)
Sat
Aug 15, 2026
Lodge Closed

Exec Board



Mon
Aug 17, 2026
Lodge Closed

Exec Board



Tue
Aug 25, 2026
Board Mtg

Exec Board


19:00 (7:00 PM)
Tue
Aug 25, 2026
General Mtg

Exec Board


20:00 (8:00 PM)
Tue
Aug 25, 2026
Joint Planning Mtg

Exec Board


18:30 (6:30 PM)
Mon
Aug 31, 2026
Lodge Closed

Exec Board



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.
Moose Lodge 2049, 922 Weddell Court, Sunnyvale, CA. 94089 USA
Last Modified: May 14 2026 @ 11:29 PDT
Stats