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
)

Sunnyvale Moose 2049	Sunnyvale Moose Event Calendar DEVELOPMENT List Future Events (Where Event Date is 2026-02-07, Weekday is Sat) [ Production Site ] Event Calendar  |  Facebook  |  Feedback  |  Home  |  Login  |  Newsletters  |  Roles

Entering List Future

Array
(
    [Action] => List Future
    [event_date] => 2026-02-07
    [weekday] => Sat
)

Help and explanations available at Overview.

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.event_date='2026-02-07' AND a.weekday = 'Sat' 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: Event Date is 2026-02-07, Weekday is Sat
Query returned 2 entries.

Entering spew_footer