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 [ Production Site ] Event Calendar  |  Facebook  |  Feedback  |  Home  |  Login  |  Newsletters  |  Roles

Entering List Future

Array
(
    [Action] => List Future
    [guest_cost] => 15
    [member_cost] => 10
)

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.guest_cost='15' AND e.member_cost='10' 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.
Query returned 27 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-04'

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

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

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

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-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-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-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-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-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)
Sat	Jul 4, 2026	BBQ Potluck		Intra Chapter Activities	$ 10	$ 15	11:00 (11:00 AM)
Sat	Jul 4, 2026	Karaoke: KG Cowboy Steve		Entertainment	$ 10	$ 15	12:00 (12: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)
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)
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)
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)
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)
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