(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] => 19: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 >= '2026-04-18' AND e.start_time='19: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: Start Time is 19:00
Query returned 22 entries.

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * from allcal where calendar_date = '2026-05-19'

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

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

SELECT * from allcal where calendar_date = '2026-05-22'

SELECT * from allcal where calendar_date = '2026-05-26'

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

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

Day	Event Date	Event Name	Host Group	Start Time
Tue	Apr 21, 2026	TNC line Dancing with Heide & Allen	Dance Events	19:00 (7:00 PM)
Wed	Apr 22, 2026	Rick's Variety Show	Entertainment	19:00 (7:00 PM)
Thu	Apr 23, 2026	Line Dance w/Nanci	Dance Events	19:00 (7:00 PM)
Tue	Apr 28, 2026	Board Mtg	Exec Board	19:00 (7:00 PM)
Wed	Apr 29, 2026	Rick's Variety Show	Entertainment	19:00 (7:00 PM)
Thu	Apr 30, 2026	Line Dance w/Nanci	Dance Events	19:00 (7:00 PM)
Tue	May 5, 2026	TNC line Dancing	Dance Events	19:00 (7:00 PM)
Wed	May 6, 2026	Rick's Variety Show	Entertainment	19:00 (7:00 PM)
Thu	May 7, 2026	Line Dance w/Nanci	Dance Events	19:00 (7:00 PM)
Fri	May 8, 2026	Line Dancing w/Mark	Dance Events	19:00 (7:00 PM)
Tue	May 12, 2026	Board Mtg	Exec Board	19:00 (7:00 PM)
Tue	May 12, 2026	TNC line Dancing	Dance Events	19:00 (7:00 PM)
Wed	May 13, 2026	Rick's Variety Show	Entertainment	19:00 (7:00 PM)
Thu	May 14, 2026	Line Dance w/Nanci	Dance Events	19:00 (7:00 PM)
Tue	May 19, 2026	TNC line Dancing	Dance Events	19:00 (7:00 PM)
Wed	May 20, 2026	Rick's Variety Show	Entertainment	19:00 (7:00 PM)
Thu	May 21, 2026	Line Dance w/Nanci	Dance Events	19:00 (7:00 PM)
Fri	May 22, 2026	Line Dancing w/Mark	Dance Events	19:00 (7:00 PM)
Tue	May 26, 2026	Board Mtg	Exec Board	19:00 (7:00 PM)
Tue	May 26, 2026	TNC line Dancing	Dance Events	19:00 (7:00 PM)
Wed	May 27, 2026	Rick's Variety Show	Entertainment	19:00 (7:00 PM)
Thu	May 28, 2026	Line Dance w/Nanci	Dance Events	19:00 (7: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: April 07 2026 @ 18:18 PDT
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 19:00)

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 19:00)

From get_fields_label Output from Message

From get_fields_label Output from Message

Sunnyvale Moose Event Calendar
DEVELOPMENT