Search
Venues, events, and guides. Filters apply to venues and to events (via the host venue). Guides require a text query.
Failed query: select "events"."id", "events"."slug", "events"."venue_id", "events"."title", "events"."start_at", "events"."end_at", "events"."category_id", "events"."description", "events"."image_url", "events"."recurrence_rule", "events"."created_at", "events"."updated_at", "events_venue"."data" as "venue", "events_category"."data" as "category" from "events" "events" left join lateral (select json_build_array("events_venue"."id", "events_venue"."slug", "events_venue"."name", "events_venue"."primary_type_term_id", "events_venue"."neighborhood_id", "events_venue"."hours_json", "events_venue"."price", "events_venue"."listing_status", "events_venue"."price_tier", "events_venue"."amenities", "events_venue"."vibe", "events_venue"."lat", "events_venue"."lng", "events_venue"."short_description", "events_venue"."description", "events_venue"."image_url", "events_venue"."website_url", "events_venue"."city", "events_venue"."subarea", "events_venue"."venue_address", "events_venue"."nearby_landmark", "events_venue"."walkability_note", "events_venue"."parking_difficulty", "events_venue"."closest_entertainment_area", "events_venue"."view_score", "events_venue"."patio_score", "events_venue"."phone", "events_venue"."facebook_url", "events_venue"."instagram_url", "events_venue"."noise_level", "events_venue"."service_style", "events_venue"."indoor_outdoor", "events_venue"."happy_hour_offered", "events_venue"."takes_reservations", "events_venue"."walk_ins_welcome", "events_venue"."parking_notes", "events_venue"."wheelchair_accessible", "events_venue"."restroom_available", "events_venue"."gender_neutral_restroom", "events_venue"."dog_friendly", "events_venue"."kid_friendly", "events_venue"."twenty_one_plus_only", "events_venue"."private_event_space", "events_venue"."wifi", "events_venue"."tv_sports", "events_venue"."live_music_flag", "events_venue"."trivia_flag", "events_venue"."karaoke", "events_venue"."pool_tables", "events_venue"."firepits", "events_venue"."covered_patio", "events_venue"."tap_count", "events_venue"."local_taps_count", "events_venue"."flights_available", "events_venue"."wine_flights_available", "events_venue"."na_beer_available", "events_venue"."mocktails_available", "events_venue"."food_available", "events_venue"."food_model", "events_venue"."signature_pours", "events_venue"."editor_pick", "events_venue"."editor_notes", "events_venue"."why_it_stands_out", "events_venue"."best_seat_in_the_house", "events_venue"."what_to_order_first", "events_venue"."ideal_visit_time", "events_venue"."seasonal_note", "events_venue"."featured_in_guide_ids", "events_venue"."photo_priority_notes", "events_venue"."house_rules_or_gotchas", "events_venue"."last_verified_at", "events_venue"."verified_status", "events_venue"."claimed_by_owner", "events_venue"."last_contacted_at", "events_venue"."data_source", "events_venue"."temporary_closure_status", "events_venue"."permanently_closed", "events_venue"."opening_date", "events_venue"."last_menu_check_at", "events_venue"."last_specials_check_at", "events_venue"."sponsorship_status", "events_venue"."sponsorship_tier", "events_venue"."featured_placement_eligible", "events_venue"."sponsor_start_date", "events_venue"."sponsor_end_date", "events_venue"."ad_creative_status", "events_venue"."owner_contact_name", "events_venue"."owner_contact_email", "events_venue"."manager_contact", "events_venue"."invoice_notes", "events_venue"."partnership_notes", "events_venue"."featured_status", "events_venue"."video_reel_url", "events_venue"."hero_media_id", "events_venue"."created_at", "events_venue"."updated_at", "events_venue"."verified_at", "events_venue_neighborhood"."data", "events_venue_primaryTypeTerm"."data", "events_venue_termLinks"."data", "events_venue_highlightLinks"."data") as "data" from (select * from "venues" "events_venue" where "events_venue"."id" = "events"."venue_id" limit $1) "events_venue" left join lateral (select json_build_array("events_venue_neighborhood"."id", "events_venue_neighborhood"."slug", "events_venue_neighborhood"."name", "events_venue_neighborhood"."created_at", "events_venue_neighborhood"."updated_at") as "data" from (select * from "neighborhoods" "events_venue_neighborhood" where "events_venue_neighborhood"."id" = "events_venue"."neighborhood_id" limit $2) "events_venue_neighborhood") "events_venue_neighborhood" on true left join lateral (select json_build_array("events_venue_primaryTypeTerm"."id", "events_venue_primaryTypeTerm"."group_id", "events_venue_primaryTypeTerm"."slug", "events_venue_primaryTypeTerm"."label", "events_venue_primaryTypeTerm"."sort_order", "events_venue_primaryTypeTerm"."created_at") as "data" from (select * from "taxonomy_terms" "events_venue_primaryTypeTerm" where "events_venue_primaryTypeTerm"."id" = "events_venue"."primary_type_term_id" limit $3) "events_venue_primaryTypeTerm") "events_venue_primaryTypeTerm" on true left join lateral (select coalesce(json_agg(json_build_array("events_venue_termLinks"."venue_id", "events_venue_termLinks"."term_id", "events_venue_termLinks_term"."data")), '[]'::json) as "data" from "venue_term_links" "events_venue_termLinks" left join lateral (select json_build_array("events_venue_termLinks_term"."id", "events_venue_termLinks_term"."group_id", "events_venue_termLinks_term"."slug", "events_venue_termLinks_term"."label", "events_venue_termLinks_term"."sort_order", "events_venue_termLinks_term"."created_at") as "data" from (select * from "taxonomy_terms" "events_venue_termLinks_term" where "events_venue_termLinks_term"."id" = "events_venue_termLinks"."term_id" limit $4) "events_venue_termLinks_term") "events_venue_termLinks_term" on true where "events_venue_termLinks"."venue_id" = "events_venue"."id") "events_venue_termLinks" on true left join lateral (select coalesce(json_agg(json_build_array("events_venue_highlightLinks"."venue_id", "events_venue_highlightLinks"."term_id", "events_venue_highlightLinks_term"."data")), '[]'::json) as "data" from "venue_highlight_links" "events_venue_highlightLinks" left join lateral (select json_build_array("events_venue_highlightLinks_term"."id", "events_venue_highlightLinks_term"."group_id", "events_venue_highlightLinks_term"."slug", "events_venue_highlightLinks_term"."label", "events_venue_highlightLinks_term"."sort_order", "events_venue_highlightLinks_term"."created_at") as "data" from (select * from "taxonomy_terms" "events_venue_highlightLinks_term" where "events_venue_highlightLinks_term"."id" = "events_venue_highlightLinks"."term_id" limit $5) "events_venue_highlightLinks_term") "events_venue_highlightLinks_term" on true where "events_venue_highlightLinks"."venue_id" = "events_venue"."id") "events_venue_highlightLinks" on true) "events_venue" on true left join lateral (select json_build_array("events_category"."id", "events_category"."slug", "events_category"."name", "events_category"."created_at", "events_category"."updated_at") as "data" from (select * from "categories" "events_category" where "events_category"."id" = "events"."category_id" limit $6) "events_category") "events_category" on true order by "events"."start_at" asc limit $7
params: 1,1,1,1,1,1,400
Enter a search term or pick a filter to begin. Popular starters:
trivia,
patio,
IPA.