Central Team Doorknocks

Liquid error: PG::UndefinedColumn: ERROR: column sites.require_analytics_consent does not exist LINE 1: ...t1_r81, "sites"."opt_in_default_value" AS t1_r82, "sites"."r... ^ : SELECT "pages"."id" AS t0_r0, "pages"."site_id" AS t0_r1, "pages"."status_id" AS t0_r2, "pages"."page_type_id" AS t0_r3, "pages"."title" AS t0_r4, "pages"."slug" AS t0_r5, "pages"."headline" AS t0_r6, "pages"."created_at" AS t0_r7, "pages"."updated_at" AS t0_r8, "pages"."bundle_file_name" AS t0_r9, "pages"."bundle_content_type" AS t0_r10, "pages"."bundle_file_size" AS t0_r11, "pages"."bundle_updated_at" AS t0_r12, "pages"."content" AS t0_r13, "pages"."content_parsed" AS t0_r14, "pages"."content_published" AS t0_r15, "pages"."content_published_parsed" AS t0_r16, "pages"."published_at" AS t0_r17, "pages"."parent_id" AS t0_r18, "pages"."lft" AS t0_r19, "pages"."rgt" AS t0_r20, "pages"."excerpt" AS t0_r21, "pages"."default_tweet_text" AS t0_r22, "pages"."short_url" AS t0_r23, "pages"."show_stream" AS t0_r24, "pages"."name" AS t0_r25, "pages"."template_published_at" AS t0_r26, "pages"."meta_image_file_name" AS t0_r27, "pages"."meta_image_content_type" AS t0_r28, "pages"."meta_image_file_size" AS t0_r29, "pages"."meta_image_updated_at" AS t0_r30, "pages"."author_id" AS t0_r31, "pages"."is_commentable" AS t0_r32, "pages"."flags_count" AS t0_r33, "pages"."is_nav" AS t0_r34, "pages"."position" AS t0_r35, "pages"."is_supporter_nav" AS t0_r36, "pages"."recruiter_id" AS t0_r37, "pages"."ignore_layout" AS t0_r38, "pages"."is_user_submitted" AS t0_r39, "pages"."likes_count" AS t0_r40, "pages"."comments_count" AS t0_r41, "pages"."author_username" AS t0_r42, "pages"."children_count" AS t0_r43, "pages"."rule_violation_id" AS t0_r44, "pages"."permission_level_id" AS t0_r45, "pages"."is_sidebar" AS t0_r46, "pages"."features_count" AS t0_r47, "pages"."external_id" AS t0_r48, "pages"."show_facetweet" AS t0_r49, "pages"."success_message" AS t0_r50, "pages"."supporter_nav_position" AS t0_r51, "pages"."live_at" AS t0_r52, "pages"."page_type_array" AS t0_r53, "pages"."show_social_slider" AS t0_r54, "pages"."background_image_file_name" AS t0_r55, "pages"."background_image_content_type" AS t0_r56, "pages"."background_image_file_size" AS t0_r57, "pages"."background_image_updated_at" AS t0_r58, "pages"."consent_form_id" AS t0_r59, "sites"."id" AS t1_r0, "sites"."name" AS t1_r1, "sites"."slug" AS t1_r2, "sites"."created_at" AS t1_r3, "sites"."updated_at" AS t1_r4, "sites"."homepage_id" AS t1_r5, "sites"."meta_image_file_name" AS t1_r6, "sites"."meta_image_content_type" AS t1_r7, "sites"."meta_image_file_size" AS t1_r8, "sites"."meta_image_updated_at" AS t1_r9, "sites"."domain" AS t1_r10, "sites"."google_analytics_code" AS t1_r11, "sites"."title" AS t1_r12, "sites"."headline" AS t1_r13, "sites"."subheadline" AS t1_r14, "sites"."splash_page_id" AS t1_r15, "sites"."friends_page_id" AS t1_r16, "sites"."donation_page_id" AS t1_r17, "sites"."volunteer_page_id" AS t1_r18, "sites"."broadcaster_id" AS t1_r19, "sites"."google_application_id" AS t1_r20, "sites"."theme_updated_at" AS t1_r21, "sites"."theme_variation" AS t1_r22, "sites"."theme_variation_advanced" AS t1_r23, "sites"."long_name" AS t1_r24, "sites"."rule_page_id" AS t1_r25, "sites"."permission_level_id" AS t1_r26, "sites"."footer_content" AS t1_r27, "sites"."footer_content_html" AS t1_r28, "sites"."chartbeat_api_key" AS t1_r29, "sites"."chartbeat_uid" AS t1_r30, "sites"."signup_page_id" AS t1_r31, "sites"."twitter_api_key" AS t1_r32, "sites"."ask_for_mobiles" AS t1_r33, "sites"."ask_for_volunteers" AS t1_r34, "sites"."show_stream" AS t1_r35, "sites"."allow_comments" AS t1_r36, "sites"."google_verification_key" AS t1_r37, "sites"."invoice_page_id" AS t1_r38, "sites"."is_facebook_like_dark" AS t1_r39, "sites"."nation_signup_page_id" AS t1_r40, "sites"."quantcast_code" AS t1_r41, "sites"."show_public_profiles" AS t1_r42, "sites"."ask_to_publish_to_stream" AS t1_r43, "sites"."button1_text" AS t1_r44, "sites"."button1_page_id" AS t1_r45, "sites"."button2_text" AS t1_r46, "sites"."button2_page_id" AS t1_r47, "sites"."button3_text" AS t1_r48, "sites"."button3_page_id" AS t1_r49, "sites"."show_parent_in_nav_dropdown" AS t1_r50, "sites"."membership_page_id" AS t1_r51, "sites"."theme_id" AS t1_r52, "sites"."background_image_file_name" AS t1_r53, "sites"."background_image_content_type" AS t1_r54, "sites"."background_image_file_size" AS t1_r55, "sites"."background_image_updated_at" AS t1_r56, "sites"."background_image_height" AS t1_r57, "sites"."background_image_width" AS t1_r58, "sites"."header_image_file_name" AS t1_r59, "sites"."header_image_content_type" AS t1_r60, "sites"."header_image_file_size" AS t1_r61, "sites"."header_image_updated_at" AS t1_r62, "sites"."header_image_height" AS t1_r63, "sites"."header_image_width" AS t1_r64, "sites"."allow_search" AS t1_r65, "sites"."is_domain_active" AS t1_r66, "sites"."email_provider_id" AS t1_r67, "sites"."email_provider_ip_address" AS t1_r68, "sites"."host" AS t1_r69, "sites"."add_to_dme" AS t1_r70, "sites"."is_profile_wide" AS t1_r71, "sites"."favicon_image_file_name" AS t1_r72, "sites"."favicon_image_content_type" AS t1_r73, "sites"."favicon_image_file_size" AS t1_r74, "sites"."favicon_image_updated_at" AS t1_r75, "sites"."favicon_image_height" AS t1_r76, "sites"."favicon_image_width" AS t1_r77, "sites"."site_type_id" AS t1_r78, "sites"."locale" AS t1_r79, "sites"."show_social_slider" AS t1_r80, "sites"."page_comment_notifications" AS t1_r81, "sites"."opt_in_default_value" AS t1_r82, "sites"."require_analytics_consent" AS t1_r83, "sites"."cookies_consent_option_id" AS t1_r84, "sites"."ask_for_consent" AS t1_r85, "sites"."consent_form_id" AS t1_r86, "sites"."edge_caching_enabled" AS t1_r87, "sites"."allow_iframe" AS t1_r88, "event_pages"."id" AS t2_r0, "event_pages"."page_id" AS t2_r1, "event_pages"."next_page_id" AS t2_r2, "event_pages"."allow_guests" AS t2_r3, "event_pages"."is_private" AS t2_r4, "event_pages"."show_guests" AS t2_r5, "event_pages"."is_facebook" AS t2_r6, "event_pages"."ticket_price_in_cents" AS t2_r7, "event_pages"."facebook_uid" AS t2_r8, "event_pages"."venue_name" AS t2_r9, "event_pages"."attending_count" AS t2_r10, "event_pages"."capacity_count" AS t2_r11, "event_pages"."start_at" AS t2_r12, "event_pages"."end_at" AS t2_r13, "event_pages"."created_at" AS t2_r14, "event_pages"."updated_at" AS t2_r15, "event_pages"."content" AS t2_r16, "event_pages"."time_zone" AS t2_r17, "event_pages"."duration" AS t2_r18, "event_pages"."venue_address_id" AS t2_r19, "event_pages"."donation_page_id" AS t2_r20, "event_pages"."is_tickets" AS t2_r21, "event_pages"."is_volunteers" AS t2_r22, "event_pages"."donation_tracking_code_id" AS t2_r23, "event_pages"."require_phone" AS t2_r24, "event_pages"."facebook_owner_id" AS t2_r25, "event_pages"."facebook_privacy" AS t2_r26, "event_pages"."is_shifts" AS t2_r27, "event_pages"."require_address" AS t2_r28, "event_pages"."contact_name" AS t2_r29, "event_pages"."contact_phone" AS t2_r30, "event_pages"."contact_email" AS t2_r31, "event_pages"."is_contact_phone_private" AS t2_r32, "event_pages"."is_contact_email_private" AS t2_r33, "event_pages"."user_ticket_price_in_cents" AS t2_r34, "event_pages"."user_ticket_currency" AS t2_r35, "event_pages"."user_ticket_purchase_url" AS t2_r36, "event_pages"."additional_rsvps_count" AS t2_r37, "event_pages"."post_to_facebook" AS t2_r38, "event_pages"."send_notifications_for_facebook_rsvps" AS t2_r39, "event_pages"."content_html" AS t2_r40, "event_pages"."auto_response_broadcaster_id" AS t2_r41, "event_pages"."auto_response_subject" AS t2_r42, "event_pages"."auto_response_content" AS t2_r43, "event_pages"."is_auto_response" AS t2_r44, "event_pages"."contact_phone_number" AS t2_r45, "event_pages"."contact_phone_country_code" AS t2_r46, "event_pages"."meetup_id" AS t2_r47, "event_pages"."meetup_url" AS t2_r48, "event_pages"."meetup_updated_at" AS t2_r49, "event_pages"."meetup_owner_id" AS t2_r50, "event_pages"."point_person_id" AS t2_r51, "event_pages"."is_geocode_override" AS t2_r52, "event_pages"."accept_rsvps" AS t2_r53, "event_pages"."is_phone" AS t2_r54, "event_pages"."is_address" AS t2_r55, "event_pages"."ip_address" AS t2_r56, "event_pages"."user_agent" AS t2_r57, "addresses"."id" AS t3_r0, "addresses"."address1" AS t3_r1, "addresses"."address2" AS t3_r2, "addresses"."city" AS t3_r3, "addresses"."state" AS t3_r4, "addresses"."country_code" AS t3_r5, "addresses"."zip" AS t3_r6, "addresses"."lat" AS t3_r7, "addresses"."lng" AS t3_r8, "addresses"."geocode_accuracy" AS t3_r9, "addresses"."geocode_address1" AS t3_r10, "addresses"."geocode_city" AS t3_r11, "addresses"."geocode_state" AS t3_r12, "addresses"."geocode_country_code" AS t3_r13, "addresses"."geocode_zip" AS t3_r14, "addresses"."geocode_error_count" AS t3_r15, "addresses"."created_at" AS t3_r16, "addresses"."updated_at" AS t3_r17, "addresses"."phone" AS t3_r18, "addresses"."signup_id" AS t3_r19, "addresses"."address_type_id" AS t3_r20, "addresses"."submitted_address" AS t3_r21, "addresses"."work_phone" AS t3_r22, "addresses"."county" AS t3_r23, "addresses"."fips" AS t3_r24, "addresses"."distance" AS t3_r25, "addresses"."ip_address" AS t3_r26, "addresses"."phone_number" AS t3_r27, "addresses"."phone_country_code" AS t3_r28, "addresses"."work_phone_number" AS t3_r29, "addresses"."work_phone_country_code" AS t3_r30, "addresses"."address3" AS t3_r31, "addresses"."sort_sequence" AS t3_r32, "addresses"."delivery_point" AS t3_r33, "addresses"."lot" AS t3_r34, "addresses"."carrier_route" AS t3_r35, "addresses"."street_number" AS t3_r36, "addresses"."street_prefix" AS t3_r37, "addresses"."street_suffix" AS t3_r38, "addresses"."street_type" AS t3_r39, "addresses"."street_name" AS t3_r40, "addresses"."unit_number" AS t3_r41, "addresses"."unit_number_integer" AS t3_r42, "addresses"."street_number_integer" AS t3_r43, "addresses"."import_id" AS t3_r44, "addresses"."identity_hash" AS t3_r45, "addresses"."geocode_source" AS t3_r46, "addresses"."geocode_county" AS t3_r47, "addresses"."geocode_street_number" AS t3_r48, "addresses"."geocode_street_name" AS t3_r49, "addresses"."geocode_formatted_address" AS t3_r50, "addresses"."geocode_subpremise" AS t3_r51, "addresses"."unique_identifier" AS t3_r52 FROM "pages" LEFT OUTER JOIN "sites" ON "sites"."id" = "pages"."site_id" LEFT OUTER JOIN "event_pages" ON "event_pages"."page_id" = "pages"."id" LEFT OUTER JOIN "addresses" ON "addresses"."id" = "event_pages"."venue_address_id" WHERE (event_pages.is_private = false AND site_id = 2 AND page_type_id = 9 AND parent_id = 61 AND status_id = 2) ORDER BY event_pages.start_at asc, pages.id asc LIMIT 10 OFFSET 0 Liquid error: PG::UndefinedColumn: ERROR: column sites.require_analytics_consent does not exist LINE 1: ...t1_r81, "sites"."opt_in_default_value" AS t1_r82, "sites"."r... ^ : SELECT "pages"."id" AS t0_r0, "pages"."site_id" AS t0_r1, "pages"."status_id" AS t0_r2, "pages"."page_type_id" AS t0_r3, "pages"."title" AS t0_r4, "pages"."slug" AS t0_r5, "pages"."headline" AS t0_r6, "pages"."created_at" AS t0_r7, "pages"."updated_at" AS t0_r8, "pages"."bundle_file_name" AS t0_r9, "pages"."bundle_content_type" AS t0_r10, "pages"."bundle_file_size" AS t0_r11, "pages"."bundle_updated_at" AS t0_r12, "pages"."content" AS t0_r13, "pages"."content_parsed" AS t0_r14, "pages"."content_published" AS t0_r15, "pages"."content_published_parsed" AS t0_r16, "pages"."published_at" AS t0_r17, "pages"."parent_id" AS t0_r18, "pages"."lft" AS t0_r19, "pages"."rgt" AS t0_r20, "pages"."excerpt" AS t0_r21, "pages"."default_tweet_text" AS t0_r22, "pages"."short_url" AS t0_r23, "pages"."show_stream" AS t0_r24, "pages"."name" AS t0_r25, "pages"."template_published_at" AS t0_r26, "pages"."meta_image_file_name" AS t0_r27, "pages"."meta_image_content_type" AS t0_r28, "pages"."meta_image_file_size" AS t0_r29, "pages"."meta_image_updated_at" AS t0_r30, "pages"."author_id" AS t0_r31, "pages"."is_commentable" AS t0_r32, "pages"."flags_count" AS t0_r33, "pages"."is_nav" AS t0_r34, "pages"."position" AS t0_r35, "pages"."is_supporter_nav" AS t0_r36, "pages"."recruiter_id" AS t0_r37, "pages"."ignore_layout" AS t0_r38, "pages"."is_user_submitted" AS t0_r39, "pages"."likes_count" AS t0_r40, "pages"."comments_count" AS t0_r41, "pages"."author_username" AS t0_r42, "pages"."children_count" AS t0_r43, "pages"."rule_violation_id" AS t0_r44, "pages"."permission_level_id" AS t0_r45, "pages"."is_sidebar" AS t0_r46, "pages"."features_count" AS t0_r47, "pages"."external_id" AS t0_r48, "pages"."show_facetweet" AS t0_r49, "pages"."success_message" AS t0_r50, "pages"."supporter_nav_position" AS t0_r51, "pages"."live_at" AS t0_r52, "pages"."page_type_array" AS t0_r53, "pages"."show_social_slider" AS t0_r54, "pages"."background_image_file_name" AS t0_r55, "pages"."background_image_content_type" AS t0_r56, "pages"."background_image_file_size" AS t0_r57, "pages"."background_image_updated_at" AS t0_r58, "pages"."consent_form_id" AS t0_r59, "sites"."id" AS t1_r0, "sites"."name" AS t1_r1, "sites"."slug" AS t1_r2, "sites"."created_at" AS t1_r3, "sites"."updated_at" AS t1_r4, "sites"."homepage_id" AS t1_r5, "sites"."meta_image_file_name" AS t1_r6, "sites"."meta_image_content_type" AS t1_r7, "sites"."meta_image_file_size" AS t1_r8, "sites"."meta_image_updated_at" AS t1_r9, "sites"."domain" AS t1_r10, "sites"."google_analytics_code" AS t1_r11, "sites"."title" AS t1_r12, "sites"."headline" AS t1_r13, "sites"."subheadline" AS t1_r14, "sites"."splash_page_id" AS t1_r15, "sites"."friends_page_id" AS t1_r16, "sites"."donation_page_id" AS t1_r17, "sites"."volunteer_page_id" AS t1_r18, "sites"."broadcaster_id" AS t1_r19, "sites"."google_application_id" AS t1_r20, "sites"."theme_updated_at" AS t1_r21, "sites"."theme_variation" AS t1_r22, "sites"."theme_variation_advanced" AS t1_r23, "sites"."long_name" AS t1_r24, "sites"."rule_page_id" AS t1_r25, "sites"."permission_level_id" AS t1_r26, "sites"."footer_content" AS t1_r27, "sites"."footer_content_html" AS t1_r28, "sites"."chartbeat_api_key" AS t1_r29, "sites"."chartbeat_uid" AS t1_r30, "sites"."signup_page_id" AS t1_r31, "sites"."twitter_api_key" AS t1_r32, "sites"."ask_for_mobiles" AS t1_r33, "sites"."ask_for_volunteers" AS t1_r34, "sites"."show_stream" AS t1_r35, "sites"."allow_comments" AS t1_r36, "sites"."google_verification_key" AS t1_r37, "sites"."invoice_page_id" AS t1_r38, "sites"."is_facebook_like_dark" AS t1_r39, "sites"."nation_signup_page_id" AS t1_r40, "sites"."quantcast_code" AS t1_r41, "sites"."show_public_profiles" AS t1_r42, "sites"."ask_to_publish_to_stream" AS t1_r43, "sites"."button1_text" AS t1_r44, "sites"."button1_page_id" AS t1_r45, "sites"."button2_text" AS t1_r46, "sites"."button2_page_id" AS t1_r47, "sites"."button3_text" AS t1_r48, "sites"."button3_page_id" AS t1_r49, "sites"."show_parent_in_nav_dropdown" AS t1_r50, "sites"."membership_page_id" AS t1_r51, "sites"."theme_id" AS t1_r52, "sites"."background_image_file_name" AS t1_r53, "sites"."background_image_content_type" AS t1_r54, "sites"."background_image_file_size" AS t1_r55, "sites"."background_image_updated_at" AS t1_r56, "sites"."background_image_height" AS t1_r57, "sites"."background_image_width" AS t1_r58, "sites"."header_image_file_name" AS t1_r59, "sites"."header_image_content_type" AS t1_r60, "sites"."header_image_file_size" AS t1_r61, "sites"."header_image_updated_at" AS t1_r62, "sites"."header_image_height" AS t1_r63, "sites"."header_image_width" AS t1_r64, "sites"."allow_search" AS t1_r65, "sites"."is_domain_active" AS t1_r66, "sites"."email_provider_id" AS t1_r67, "sites"."email_provider_ip_address" AS t1_r68, "sites"."host" AS t1_r69, "sites"."add_to_dme" AS t1_r70, "sites"."is_profile_wide" AS t1_r71, "sites"."favicon_image_file_name" AS t1_r72, "sites"."favicon_image_content_type" AS t1_r73, "sites"."favicon_image_file_size" AS t1_r74, "sites"."favicon_image_updated_at" AS t1_r75, "sites"."favicon_image_height" AS t1_r76, "sites"."favicon_image_width" AS t1_r77, "sites"."site_type_id" AS t1_r78, "sites"."locale" AS t1_r79, "sites"."show_social_slider" AS t1_r80, "sites"."page_comment_notifications" AS t1_r81, "sites"."opt_in_default_value" AS t1_r82, "sites"."require_analytics_consent" AS t1_r83, "sites"."cookies_consent_option_id" AS t1_r84, "sites"."ask_for_consent" AS t1_r85, "sites"."consent_form_id" AS t1_r86, "sites"."edge_caching_enabled" AS t1_r87, "sites"."allow_iframe" AS t1_r88, "event_pages"."id" AS t2_r0, "event_pages"."page_id" AS t2_r1, "event_pages"."next_page_id" AS t2_r2, "event_pages"."allow_guests" AS t2_r3, "event_pages"."is_private" AS t2_r4, "event_pages"."show_guests" AS t2_r5, "event_pages"."is_facebook" AS t2_r6, "event_pages"."ticket_price_in_cents" AS t2_r7, "event_pages"."facebook_uid" AS t2_r8, "event_pages"."venue_name" AS t2_r9, "event_pages"."attending_count" AS t2_r10, "event_pages"."capacity_count" AS t2_r11, "event_pages"."start_at" AS t2_r12, "event_pages"."end_at" AS t2_r13, "event_pages"."created_at" AS t2_r14, "event_pages"."updated_at" AS t2_r15, "event_pages"."content" AS t2_r16, "event_pages"."time_zone" AS t2_r17, "event_pages"."duration" AS t2_r18, "event_pages"."venue_address_id" AS t2_r19, "event_pages"."donation_page_id" AS t2_r20, "event_pages"."is_tickets" AS t2_r21, "event_pages"."is_volunteers" AS t2_r22, "event_pages"."donation_tracking_code_id" AS t2_r23, "event_pages"."require_phone" AS t2_r24, "event_pages"."facebook_owner_id" AS t2_r25, "event_pages"."facebook_privacy" AS t2_r26, "event_pages"."is_shifts" AS t2_r27, "event_pages"."require_address" AS t2_r28, "event_pages"."contact_name" AS t2_r29, "event_pages"."contact_phone" AS t2_r30, "event_pages"."contact_email" AS t2_r31, "event_pages"."is_contact_phone_private" AS t2_r32, "event_pages"."is_contact_email_private" AS t2_r33, "event_pages"."user_ticket_price_in_cents" AS t2_r34, "event_pages"."user_ticket_currency" AS t2_r35, "event_pages"."user_ticket_purchase_url" AS t2_r36, "event_pages"."additional_rsvps_count" AS t2_r37, "event_pages"."post_to_facebook" AS t2_r38, "event_pages"."send_notifications_for_facebook_rsvps" AS t2_r39, "event_pages"."content_html" AS t2_r40, "event_pages"."auto_response_broadcaster_id" AS t2_r41, "event_pages"."auto_response_subject" AS t2_r42, "event_pages"."auto_response_content" AS t2_r43, "event_pages"."is_auto_response" AS t2_r44, "event_pages"."contact_phone_number" AS t2_r45, "event_pages"."contact_phone_country_code" AS t2_r46, "event_pages"."meetup_id" AS t2_r47, "event_pages"."meetup_url" AS t2_r48, "event_pages"."meetup_updated_at" AS t2_r49, "event_pages"."meetup_owner_id" AS t2_r50, "event_pages"."point_person_id" AS t2_r51, "event_pages"."is_geocode_override" AS t2_r52, "event_pages"."accept_rsvps" AS t2_r53, "event_pages"."is_phone" AS t2_r54, "event_pages"."is_address" AS t2_r55, "event_pages"."ip_address" AS t2_r56, "event_pages"."user_agent" AS t2_r57, "addresses"."id" AS t3_r0, "addresses"."address1" AS t3_r1, "addresses"."address2" AS t3_r2, "addresses"."city" AS t3_r3, "addresses"."state" AS t3_r4, "addresses"."country_code" AS t3_r5, "addresses"."zip" AS t3_r6, "addresses"."lat" AS t3_r7, "addresses"."lng" AS t3_r8, "addresses"."geocode_accuracy" AS t3_r9, "addresses"."geocode_address1" AS t3_r10, "addresses"."geocode_city" AS t3_r11, "addresses"."geocode_state" AS t3_r12, "addresses"."geocode_country_code" AS t3_r13, "addresses"."geocode_zip" AS t3_r14, "addresses"."geocode_error_count" AS t3_r15, "addresses"."created_at" AS t3_r16, "addresses"."updated_at" AS t3_r17, "addresses"."phone" AS t3_r18, "addresses"."signup_id" AS t3_r19, "addresses"."address_type_id" AS t3_r20, "addresses"."submitted_address" AS t3_r21, "addresses"."work_phone" AS t3_r22, "addresses"."county" AS t3_r23, "addresses"."fips" AS t3_r24, "addresses"."distance" AS t3_r25, "addresses"."ip_address" AS t3_r26, "addresses"."phone_number" AS t3_r27, "addresses"."phone_country_code" AS t3_r28, "addresses"."work_phone_number" AS t3_r29, "addresses"."work_phone_country_code" AS t3_r30, "addresses"."address3" AS t3_r31, "addresses"."sort_sequence" AS t3_r32, "addresses"."delivery_point" AS t3_r33, "addresses"."lot" AS t3_r34, "addresses"."carrier_route" AS t3_r35, "addresses"."street_number" AS t3_r36, "addresses"."street_prefix" AS t3_r37, "addresses"."street_suffix" AS t3_r38, "addresses"."street_type" AS t3_r39, "addresses"."street_name" AS t3_r40, "addresses"."unit_number" AS t3_r41, "addresses"."unit_number_integer" AS t3_r42, "addresses"."street_number_integer" AS t3_r43, "addresses"."import_id" AS t3_r44, "addresses"."identity_hash" AS t3_r45, "addresses"."geocode_source" AS t3_r46, "addresses"."geocode_county" AS t3_r47, "addresses"."geocode_street_number" AS t3_r48, "addresses"."geocode_street_name" AS t3_r49, "addresses"."geocode_formatted_address" AS t3_r50, "addresses"."geocode_subpremise" AS t3_r51, "addresses"."unique_identifier" AS t3_r52 FROM "pages" LEFT OUTER JOIN "sites" ON "sites"."id" = "pages"."site_id" LEFT OUTER JOIN "event_pages" ON "event_pages"."page_id" = "pages"."id" LEFT OUTER JOIN "addresses" ON "addresses"."id" = "event_pages"."venue_address_id" WHERE (event_pages.is_private = false AND site_id = 2 AND page_type_id = 9 AND parent_id = 61 AND status_id = 2) ORDER BY event_pages.start_at asc, pages.id asc LIMIT 10 OFFSET 0