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
)

Sunnyvale Moose 2049	Sunnyvale Moose Event Calendar DEVELOPMENT List Future Events (Where Host Group is Dance Events, Weekday is Sun) [ Production Site ] Event Calendar  |  Facebook  |  Feedback  |  Home  |  Login  |  Newsletters  |  Roles

Entering List Future

Array
(
    [Action] => List Future
    [hostgroup_id] => 19
    [weekday] => Sun
)

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] => 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' AND a.weekday = 'Sun' 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, Weekday is Sun
Query returned 2 entries.

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-08-09'

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

Day	Event Date	Event Name		Host Group	Member Cost	Guest Cost	Start Time
Sun	Jul 12, 2026	TCB Band		Dance Events		$ 10	14:00 (2:00 PM)
Sun	Aug 9, 2026	TCB Band		Dance Events		$ 10	14:00 (2:00 PM)

Entering spew_footer