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] => 19
)

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='19' 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 Dance Events
Query returned 30 entries.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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-16'

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

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

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

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

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

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

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

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

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

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

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

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-30'

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

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

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

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

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

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

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

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

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

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

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

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-13'

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

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

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

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

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

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

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

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

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

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-27'

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

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

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

Day Event Date Event Name Host Group Member
Cost		 Guest
Cost		 Start Time
Tue
Jun 30, 2026
TNC line Dancing: Heide & Al

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Fri
Jul 3, 2026
Line Dancing w/Mark

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Tue
Jul 7, 2026
TNC line Dancing

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Tue
Jul 7, 2026
TNC line Dancing: Heide & Al

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Thu
Jul 9, 2026
Line Dance w/Nanci

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Fri
Jul 10, 2026
Dance: Moose Big Band

Dance Events
$ 10
$ 15
20:00 (8:00 PM)
Sun
Jul 12, 2026
TCB Band

Dance Events

$ 10
14:00 (2:00 PM)
Tue
Jul 14, 2026
TNC line Dancing

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Thu
Jul 16, 2026
Line Dance w/Nanci

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Fri
Jul 17, 2026
Line Dancing w/Mark

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Tue
Jul 21, 2026
TNC line Dancing

Dance Events


19:00 (7:00 PM)
Thu
Jul 23, 2026
Line Dance w/Nanci

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Fri
Jul 24, 2026
Dance: Moose Big Band

Dance Events
$ 10
$ 15
20:00 (8:00 PM)
Fri
Jul 24, 2026
Line Dancing w/Mark

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Tue
Jul 28, 2026
TNC line Dancing: Heide & Al

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Thu
Jul 30, 2026
Line Dance w/Nanci

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Sat
Aug 1, 2026
Karen Gentry Band

Dance Events

$ 10
12:45 (12:45 PM)
Tue
Aug 4, 2026
TNC line Dancing: Heide & Al

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Thu
Aug 6, 2026
Line Dance w/Nanci

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Fri
Aug 7, 2026
Line Dancing w/Mark

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Sun
Aug 9, 2026
TCB Band

Dance Events

$ 10
14:00 (2:00 PM)
Tue
Aug 11, 2026
TNC line Dancing

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Thu
Aug 13, 2026
Line Dance w/Nanci

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Fri
Aug 14, 2026
Dance: Moose Big Band

Dance Events
$ 10
$ 15
20:00 (8:00 PM)
Tue
Aug 18, 2026
TNC line Dancing

Dance Events


19:00 (7:00 PM)
Thu
Aug 20, 2026
Line Dance w/Nanci

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Fri
Aug 21, 2026
Line Dancing w/Mark

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Tue
Aug 25, 2026
TNC line Dancing: Heide & Al

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Thu
Aug 27, 2026
Line Dance w/Nanci

Dance Events
$ 10
$ 15
19:00 (7:00 PM)
Fri
Aug 28, 2026
Dance: Moose Big Band

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