Your place to share thoughts, questions and ideas on child advocacy

You must be a member of Speak Now for Kids to submit questions or comments. Click here for forum rules

Liquid error: PG::UndefinedColumn: ERROR: column signups.rnc_id_old does not exist LINE 1: ... AS t3_r232, "signups"."party_member" AS t3_r233, "signups".... ^ : 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, "suggestion_pages"."id" AS t1_r0, "suggestion_pages"."page_id" AS t1_r1, "suggestion_pages"."content" AS t1_r2, "suggestion_pages"."created_at" AS t1_r3, "suggestion_pages"."updated_at" AS t1_r4, "suggestion_pages"."recruiter_id" AS t1_r5, "suggestion_pages"."content_html" AS t1_r6, "suggestion_pages"."answer" AS t1_r7, "suggestion_pages"."answer_html" AS t1_r8, "suggestion_pages"."answer_author_id" AS t1_r9, "suggestion_pages"."answered_at" AS t1_r10, "suggestion_pages"."answer_type_id" AS t1_r11, "suggestion_pages"."image_file_name" AS t1_r12, "suggestion_pages"."image_content_type" AS t1_r13, "suggestion_pages"."image_file_size" AS t1_r14, "suggestion_pages"."image_updated_at" AS t1_r15, "suggestion_pages"."image_height" AS t1_r16, "suggestion_pages"."image_width" AS t1_r17, "suggestion_pages"."ip_address" AS t1_r18, "suggestion_pages"."user_agent" AS t1_r19, "sites"."id" AS t2_r0, "sites"."name" AS t2_r1, "sites"."slug" AS t2_r2, "sites"."created_at" AS t2_r3, "sites"."updated_at" AS t2_r4, "sites"."homepage_id" AS t2_r5, "sites"."meta_image_file_name" AS t2_r6, "sites"."meta_image_content_type" AS t2_r7, "sites"."meta_image_file_size" AS t2_r8, "sites"."meta_image_updated_at" AS t2_r9, "sites"."domain" AS t2_r10, "sites"."google_analytics_code" AS t2_r11, "sites"."title" AS t2_r12, "sites"."headline" AS t2_r13, "sites"."subheadline" AS t2_r14, "sites"."splash_page_id" AS t2_r15, "sites"."friends_page_id" AS t2_r16, "sites"."donation_page_id" AS t2_r17, "sites"."volunteer_page_id" AS t2_r18, "sites"."broadcaster_id" AS t2_r19, "sites"."google_application_id" AS t2_r20, "sites"."theme_updated_at" AS t2_r21, "sites"."theme_variation" AS t2_r22, "sites"."theme_variation_advanced" AS t2_r23, "sites"."long_name" AS t2_r24, "sites"."rule_page_id" AS t2_r25, "sites"."permission_level_id" AS t2_r26, "sites"."footer_content" AS t2_r27, "sites"."footer_content_html" AS t2_r28, "sites"."chartbeat_api_key" AS t2_r29, "sites"."chartbeat_uid" AS t2_r30, "sites"."signup_page_id" AS t2_r31, "sites"."twitter_api_key" AS t2_r32, "sites"."ask_for_mobiles" AS t2_r33, "sites"."ask_for_volunteers" AS t2_r34, "sites"."show_stream" AS t2_r35, "sites"."allow_comments" AS t2_r36, "sites"."google_verification_key" AS t2_r37, "sites"."invoice_page_id" AS t2_r38, "sites"."is_facebook_like_dark" AS t2_r39, "sites"."nation_signup_page_id" AS t2_r40, "sites"."quantcast_code" AS t2_r41, "sites"."show_public_profiles" AS t2_r42, "sites"."ask_to_publish_to_stream" AS t2_r43, "sites"."button1_text" AS t2_r44, "sites"."button1_page_id" AS t2_r45, "sites"."button2_text" AS t2_r46, "sites"."button2_page_id" AS t2_r47, "sites"."button3_text" AS t2_r48, "sites"."button3_page_id" AS t2_r49, "sites"."show_parent_in_nav_dropdown" AS t2_r50, "sites"."membership_page_id" AS t2_r51, "sites"."theme_id" AS t2_r52, "sites"."background_image_file_name" AS t2_r53, "sites"."background_image_content_type" AS t2_r54, "sites"."background_image_file_size" AS t2_r55, "sites"."background_image_updated_at" AS t2_r56, "sites"."background_image_height" AS t2_r57, "sites"."background_image_width" AS t2_r58, "sites"."header_image_file_name" AS t2_r59, "sites"."header_image_content_type" AS t2_r60, "sites"."header_image_file_size" AS t2_r61, "sites"."header_image_updated_at" AS t2_r62, "sites"."header_image_height" AS t2_r63, "sites"."header_image_width" AS t2_r64, "sites"."allow_search" AS t2_r65, "sites"."is_domain_active" AS t2_r66, "sites"."email_provider_id" AS t2_r67, "sites"."email_provider_ip_address" AS t2_r68, "sites"."host" AS t2_r69, "sites"."add_to_dme" AS t2_r70, "sites"."is_profile_wide" AS t2_r71, "sites"."favicon_image_file_name" AS t2_r72, "sites"."favicon_image_content_type" AS t2_r73, "sites"."favicon_image_file_size" AS t2_r74, "sites"."favicon_image_updated_at" AS t2_r75, "sites"."favicon_image_height" AS t2_r76, "sites"."favicon_image_width" AS t2_r77, "sites"."site_type_id" AS t2_r78, "sites"."locale" AS t2_r79, "sites"."show_social_slider" AS t2_r80, "sites"."page_comment_notifications" AS t2_r81, "sites"."opt_in_default_value" AS t2_r82, "signups"."id" AS t3_r0, "signups"."first_name" AS t3_r1, "signups"."last_name" AS t3_r2, "signups"."email1" AS t3_r3, "signups"."email_opt_in" AS t3_r4, "signups"."submitted_address" AS t3_r5, "signups"."is_volunteer" AS t3_r6, "signups"."availability" AS t3_r7, "signups"."phone" AS t3_r8, "signups"."mobile" AS t3_r9, "signups"."mobile_opt_in" AS t3_r10, "signups"."phone_time" AS t3_r11, "signups"."created_at" AS t3_r12, "signups"."updated_at" AS t3_r13, "signups"."unsubscribed_at" AS t3_r14, "signups"."email1_spam_reported_at" AS t3_r15, "signups"."email1_bounced_at" AS t3_r16, "signups"."email1_bounce_count" AS t3_r17, "signups"."email1_bounce_status" AS t3_r18, "signups"."email1_bounce_reason" AS t3_r19, "signups"."email1_is_bad" AS t3_r20, "signups"."full_name" AS t3_r21, "signups"."ngp_id" AS t3_r22, "signups"."import_id" AS t3_r23, "signups"."page_id" AS t3_r24, "signups"."employer" AS t3_r25, "signups"."occupation" AS t3_r26, "signups"."donations_amount_in_cents" AS t3_r27, "signups"."donations_count" AS t3_r28, "signups"."email1_is_invalid" AS t3_r29, "signups"."email1_invalid_reason" AS t3_r30, "signups"."facebook_uid" AS t3_r31, "signups"."twitter_id" AS t3_r32, "signups"."twitter_login" AS t3_r33, "signups"."is_facebook_fan" AS t3_r34, "signups"."is_twitter_follower" AS t3_r35, "signups"."last_donated_at" AS t3_r36, "signups"."address_id" AS t3_r37, "signups"."parent_id" AS t3_r38, "signups"."is_fundraiser" AS t3_r39, "signups"."donations_raised_amount_in_cents" AS t3_r40, "signups"."donations_raised_count" AS t3_r41, "signups"."donations_to_raise_amount_in_cents" AS t3_r42, "signups"."last_contacted_by_id" AS t3_r43, "signups"."support_level" AS t3_r44, "signups"."last_contacted_at" AS t3_r45, "signups"."call_status_id" AS t3_r46, "signups"."support_level_changed_at" AS t3_r47, "signups"."warnings_count" AS t3_r48, "signups"."work_phone" AS t3_r49, "signups"."last_call_id" AS t3_r50, "signups"."donations_raised_amount_this_cycle_in_cents" AS t3_r51, "signups"."donations_raised_count_this_cycle" AS t3_r52, "signups"."donations_amount_this_cycle_in_cents" AS t3_r53, "signups"."donations_count_this_cycle" AS t3_r54, "signups"."is_survey_question_private" AS t3_r55, "signups"."children_count" AS t3_r56, "signups"."is_profile_private" AS t3_r57, "signups"."is_profile_searchable" AS t3_r58, "signups"."donations_pledged_amount_in_cents" AS t3_r59, "signups"."recruiter_id" AS t3_r60, "signups"."twitter_updated_at" AS t3_r61, "signups"."recruits_count" AS t3_r62, "signups"."van_id" AS t3_r63, "signups"."middle_name" AS t3_r64, "signups"."suffix" AS t3_r65, "signups"."state_file_id" AS t3_r66, "signups"."sex" AS t3_r67, "signups"."party" AS t3_r68, "signups"."born_at" AS t3_r69, "signups"."registered_at" AS t3_r70, "signups"."dw_id" AS t3_r71, "signups"."facebook_updated_at" AS t3_r72, "signups"."spent_capital_amount_in_cents" AS t3_r73, "signups"."received_capital_amount_in_cents" AS t3_r74, "signups"."capital_amount_in_cents" AS t3_r75, "signups"."assistant_id" AS t3_r76, "signups"."auto_import_id" AS t3_r77, "signups"."is_supporter" AS t3_r78, "signups"."first_donated_at" AS t3_r79, "signups"."could_vote_status" AS t3_r80, "signups"."is_leaderboardable" AS t3_r81, "signups"."do_not_call" AS t3_r82, "signups"."do_not_contact" AS t3_r83, "signups"."broadcaster_id" AS t3_r84, "signups"."cim_id" AS t3_r85, "signups"."username" AS t3_r86, "signups"."rule_violations_count" AS t3_r87, "signups"."last_rule_violation_at" AS t3_r88, "signups"."banned_at" AS t3_r89, "signups"."twitter_error_count" AS t3_r90, "signups"."facebook_error_count" AS t3_r91, "signups"."is_twitter_protected" AS t3_r92, "signups"."facebook_username" AS t3_r93, "signups"."twitter_name" AS t3_r94, "signups"."twitter_description" AS t3_r95, "signups"."twitter_website" AS t3_r96, "signups"."twitter_location" AS t3_r97, "signups"."klout_score" AS t3_r98, "signups"."twitter_friends_count" AS t3_r99, "signups"."twitter_followers_count" AS t3_r100, "signups"."is_prospect" AS t3_r101, "signups"."phone_country_code" AS t3_r102, "signups"."phone_number" AS t3_r103, "signups"."mobile_number" AS t3_r104, "signups"."mobile_country_code" AS t3_r105, "signups"."work_phone_number" AS t3_r106, "signups"."work_phone_country_code" AS t3_r107, "signups"."email_hashed" AS t3_r108, "signups"."membership_level_id" AS t3_r109, "signups"."membership_expires_at" AS t3_r110, "signups"."membership_started_at" AS t3_r111, "signups"."meetup_id" AS t3_r112, "signups"."meetup_name" AS t3_r113, "signups"."meetup_bio" AS t3_r114, "signups"."meetup_profile_image_url" AS t3_r115, "signups"."meetup_crawled_at" AS t3_r116, "signups"."meetup_error_count" AS t3_r117, "signups"."civicrm_id" AS t3_r118, "signups"."external_id" AS t3_r119, "signups"."invoice_payments_referred_amount_in_cents" AS t3_r120, "signups"."invoice_payments_amount_in_cents" AS t3_r121, "signups"."is_possible_duplicate" AS t3_r122, "signups"."prefix" AS t3_r123, "signups"."pf_strat_id" AS t3_r124, "signups"."household_id" AS t3_r125, "signups"."federal_donotcall" AS t3_r126, "signups"."demo" AS t3_r127, "signups"."mailing_address_id" AS t3_r128, "signups"."registered_address_id" AS t3_r129, "signups"."note" AS t3_r130, "signups"."note_updated_at" AS t3_r131, "signups"."is_mobile_bad" AS t3_r132, "signups"."work_address_id" AS t3_r133, "signups"."is_ignore_donation_limits" AS t3_r134, "signups"."billing_address_id" AS t3_r135, "signups"."twitter_address_id" AS t3_r136, "signups"."facebook_address_id" AS t3_r137, "signups"."meetup_address_id" AS t3_r138, "signups"."user_submitted_address_id" AS t3_r139, "signups"."email2" AS t3_r140, "signups"."email3" AS t3_r141, "signups"."email4" AS t3_r142, "signups"."email2_bounced_at" AS t3_r143, "signups"."email2_bounce_count" AS t3_r144, "signups"."email2_bounce_status" AS t3_r145, "signups"."email2_bounce_reason" AS t3_r146, "signups"."email2_spam_reported_at" AS t3_r147, "signups"."email2_is_invalid" AS t3_r148, "signups"."email2_invalid_reason" AS t3_r149, "signups"."email2_is_bad" AS t3_r150, "signups"."email3_bounced_at" AS t3_r151, "signups"."email3_bounce_count" AS t3_r152, "signups"."email3_bounce_status" AS t3_r153, "signups"."email3_bounce_reason" AS t3_r154, "signups"."email3_spam_reported_at" AS t3_r155, "signups"."email3_is_invalid" AS t3_r156, "signups"."email3_invalid_reason" AS t3_r157, "signups"."email3_is_bad" AS t3_r158, "signups"."email4_bounced_at" AS t3_r159, "signups"."email4_bounce_count" AS t3_r160, "signups"."email4_bounce_status" AS t3_r161, "signups"."email4_bounce_reason" AS t3_r162, "signups"."email4_spam_reported_at" AS t3_r163, "signups"."email4_is_invalid" AS t3_r164, "signups"."email4_invalid_reason" AS t3_r165, "signups"."email4_is_bad" AS t3_r166, "signups"."precinct_id" AS t3_r167, "signups"."primary_address_id" AS t3_r168, "signups"."grandparent_id" AS t3_r169, "signups"."federal_district" AS t3_r170, "signups"."state_lower_district" AS t3_r171, "signups"."state_upper_district" AS t3_r172, "signups"."city_district" AS t3_r173, "signups"."judicial_district" AS t3_r174, "signups"."school_district" AS t3_r175, "signups"."media_market_id" AS t3_r176, "signups"."is_deceased" AS t3_r177, "signups"."county_file_id" AS t3_r178, "signups"."religion" AS t3_r179, "signups"."church" AS t3_r180, "signups"."ethnicity" AS t3_r181, "signups"."legal_name" AS t3_r182, "signups"."language" AS t3_r183, "signups"."support_probability_score" AS t3_r184, "signups"."turnout_probability_score" AS t3_r185, "signups"."county_district" AS t3_r186, "signups"."village_district" AS t3_r187, "signups"."school_sub_district" AS t3_r188, "signups"."fire_district" AS t3_r189, "signups"."marital_status" AS t3_r190, "signups"."fax" AS t3_r191, "signups"."fax_number" AS t3_r192, "signups"."fax_country_code" AS t3_r193, "signups"."author_id" AS t3_r194, "signups"."primary_email_id" AS t3_r195, "signups"."switchvox_id" AS t3_r196, "signups"."switchvox_extension" AS t3_r197, "signups"."previous_party" AS t3_r198, "signups"."inferred_party" AS t3_r199, "signups"."inferred_support_level" AS t3_r200, "signups"."invoices_count" AS t3_r201, "signups"."closed_invoices_count" AS t3_r202, "signups"."outstanding_invoices_count" AS t3_r203, "signups"."invoices_amount_in_cents" AS t3_r204, "signups"."closed_invoices_amount_in_cents" AS t3_r205, "signups"."outstanding_invoices_amount_in_cents" AS t3_r206, "signups"."first_invoice_at" AS t3_r207, "signups"."last_invoice_at" AS t3_r208, "signups"."active_customer_started_at" AS t3_r209, "signups"."active_customer_expires_at" AS t3_r210, "signups"."priority_level" AS t3_r211, "signups"."priority_level_changed_at" AS t3_r212, "signups"."contact_status_id" AS t3_r213, "signups"."profile_content" AS t3_r214, "signups"."profile_content_html" AS t3_r215, "signups"."profile_headline" AS t3_r216, "signups"."first_supporter_at" AS t3_r217, "signups"."first_prospect_at" AS t3_r218, "signups"."first_recruited_at" AS t3_r219, "signups"."first_volunteer_at" AS t3_r220, "signups"."first_fundraised_at" AS t3_r221, "signups"."last_fundraised_at" AS t3_r222, "signups"."nbec_guid" AS t3_r223, "signups"."overdue_invoices_count" AS t3_r224, "signups"."custom_values" AS t3_r225, "signups"."cached_tag_ids" AS t3_r226, "signups"."salesforce_id" AS t3_r227, "signups"."nbec_precinct_id" AS t3_r228, "signups"."permission_set_id" AS t3_r229, "signups"."locale" AS t3_r230, "signups"."labour_region" AS t3_r231, "signups"."supranational_district" AS t3_r232, "signups"."party_member" AS t3_r233, "signups"."rnc_id_old" AS t3_r234, "signups"."rnc_regid" AS t3_r235, "signups"."city_sub_district" AS t3_r236, "signups"."rnc_id" AS t3_r237, "signups"."datatrust_id" AS t3_r238, "signups"."township" AS t3_r239, "signups"."ward" AS t3_r240, "signups"."inferred_gender" AS t3_r241, "signups"."inferred_demo" AS t3_r242, "signups"."signup_type" AS t3_r243 FROM "pages" INNER JOIN "suggestion_pages" ON "suggestion_pages"."page_id" = "pages"."id" LEFT OUTER JOIN "sites" ON "sites"."id" = "pages"."site_id" LEFT OUTER JOIN "signups" ON "signups"."id" = "pages"."author_id" WHERE "pages"."parent_id" = 21 AND (pages.status_id = 2) AND "pages"."page_type_id" = 13 ORDER BY pages.published_at DESC LIMIT 20 OFFSET 0
Liquid error: PG::UndefinedColumn: ERROR: column signups.rnc_id_old does not exist LINE 1: ... AS t3_r232, "signups"."party_member" AS t3_r233, "signups".... ^ : 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, "suggestion_pages"."id" AS t1_r0, "suggestion_pages"."page_id" AS t1_r1, "suggestion_pages"."content" AS t1_r2, "suggestion_pages"."created_at" AS t1_r3, "suggestion_pages"."updated_at" AS t1_r4, "suggestion_pages"."recruiter_id" AS t1_r5, "suggestion_pages"."content_html" AS t1_r6, "suggestion_pages"."answer" AS t1_r7, "suggestion_pages"."answer_html" AS t1_r8, "suggestion_pages"."answer_author_id" AS t1_r9, "suggestion_pages"."answered_at" AS t1_r10, "suggestion_pages"."answer_type_id" AS t1_r11, "suggestion_pages"."image_file_name" AS t1_r12, "suggestion_pages"."image_content_type" AS t1_r13, "suggestion_pages"."image_file_size" AS t1_r14, "suggestion_pages"."image_updated_at" AS t1_r15, "suggestion_pages"."image_height" AS t1_r16, "suggestion_pages"."image_width" AS t1_r17, "suggestion_pages"."ip_address" AS t1_r18, "suggestion_pages"."user_agent" AS t1_r19, "sites"."id" AS t2_r0, "sites"."name" AS t2_r1, "sites"."slug" AS t2_r2, "sites"."created_at" AS t2_r3, "sites"."updated_at" AS t2_r4, "sites"."homepage_id" AS t2_r5, "sites"."meta_image_file_name" AS t2_r6, "sites"."meta_image_content_type" AS t2_r7, "sites"."meta_image_file_size" AS t2_r8, "sites"."meta_image_updated_at" AS t2_r9, "sites"."domain" AS t2_r10, "sites"."google_analytics_code" AS t2_r11, "sites"."title" AS t2_r12, "sites"."headline" AS t2_r13, "sites"."subheadline" AS t2_r14, "sites"."splash_page_id" AS t2_r15, "sites"."friends_page_id" AS t2_r16, "sites"."donation_page_id" AS t2_r17, "sites"."volunteer_page_id" AS t2_r18, "sites"."broadcaster_id" AS t2_r19, "sites"."google_application_id" AS t2_r20, "sites"."theme_updated_at" AS t2_r21, "sites"."theme_variation" AS t2_r22, "sites"."theme_variation_advanced" AS t2_r23, "sites"."long_name" AS t2_r24, "sites"."rule_page_id" AS t2_r25, "sites"."permission_level_id" AS t2_r26, "sites"."footer_content" AS t2_r27, "sites"."footer_content_html" AS t2_r28, "sites"."chartbeat_api_key" AS t2_r29, "sites"."chartbeat_uid" AS t2_r30, "sites"."signup_page_id" AS t2_r31, "sites"."twitter_api_key" AS t2_r32, "sites"."ask_for_mobiles" AS t2_r33, "sites"."ask_for_volunteers" AS t2_r34, "sites"."show_stream" AS t2_r35, "sites"."allow_comments" AS t2_r36, "sites"."google_verification_key" AS t2_r37, "sites"."invoice_page_id" AS t2_r38, "sites"."is_facebook_like_dark" AS t2_r39, "sites"."nation_signup_page_id" AS t2_r40, "sites"."quantcast_code" AS t2_r41, "sites"."show_public_profiles" AS t2_r42, "sites"."ask_to_publish_to_stream" AS t2_r43, "sites"."button1_text" AS t2_r44, "sites"."button1_page_id" AS t2_r45, "sites"."button2_text" AS t2_r46, "sites"."button2_page_id" AS t2_r47, "sites"."button3_text" AS t2_r48, "sites"."button3_page_id" AS t2_r49, "sites"."show_parent_in_nav_dropdown" AS t2_r50, "sites"."membership_page_id" AS t2_r51, "sites"."theme_id" AS t2_r52, "sites"."background_image_file_name" AS t2_r53, "sites"."background_image_content_type" AS t2_r54, "sites"."background_image_file_size" AS t2_r55, "sites"."background_image_updated_at" AS t2_r56, "sites"."background_image_height" AS t2_r57, "sites"."background_image_width" AS t2_r58, "sites"."header_image_file_name" AS t2_r59, "sites"."header_image_content_type" AS t2_r60, "sites"."header_image_file_size" AS t2_r61, "sites"."header_image_updated_at" AS t2_r62, "sites"."header_image_height" AS t2_r63, "sites"."header_image_width" AS t2_r64, "sites"."allow_search" AS t2_r65, "sites"."is_domain_active" AS t2_r66, "sites"."email_provider_id" AS t2_r67, "sites"."email_provider_ip_address" AS t2_r68, "sites"."host" AS t2_r69, "sites"."add_to_dme" AS t2_r70, "sites"."is_profile_wide" AS t2_r71, "sites"."favicon_image_file_name" AS t2_r72, "sites"."favicon_image_content_type" AS t2_r73, "sites"."favicon_image_file_size" AS t2_r74, "sites"."favicon_image_updated_at" AS t2_r75, "sites"."favicon_image_height" AS t2_r76, "sites"."favicon_image_width" AS t2_r77, "sites"."site_type_id" AS t2_r78, "sites"."locale" AS t2_r79, "sites"."show_social_slider" AS t2_r80, "sites"."page_comment_notifications" AS t2_r81, "sites"."opt_in_default_value" AS t2_r82, "signups"."id" AS t3_r0, "signups"."first_name" AS t3_r1, "signups"."last_name" AS t3_r2, "signups"."email1" AS t3_r3, "signups"."email_opt_in" AS t3_r4, "signups"."submitted_address" AS t3_r5, "signups"."is_volunteer" AS t3_r6, "signups"."availability" AS t3_r7, "signups"."phone" AS t3_r8, "signups"."mobile" AS t3_r9, "signups"."mobile_opt_in" AS t3_r10, "signups"."phone_time" AS t3_r11, "signups"."created_at" AS t3_r12, "signups"."updated_at" AS t3_r13, "signups"."unsubscribed_at" AS t3_r14, "signups"."email1_spam_reported_at" AS t3_r15, "signups"."email1_bounced_at" AS t3_r16, "signups"."email1_bounce_count" AS t3_r17, "signups"."email1_bounce_status" AS t3_r18, "signups"."email1_bounce_reason" AS t3_r19, "signups"."email1_is_bad" AS t3_r20, "signups"."full_name" AS t3_r21, "signups"."ngp_id" AS t3_r22, "signups"."import_id" AS t3_r23, "signups"."page_id" AS t3_r24, "signups"."employer" AS t3_r25, "signups"."occupation" AS t3_r26, "signups"."donations_amount_in_cents" AS t3_r27, "signups"."donations_count" AS t3_r28, "signups"."email1_is_invalid" AS t3_r29, "signups"."email1_invalid_reason" AS t3_r30, "signups"."facebook_uid" AS t3_r31, "signups"."twitter_id" AS t3_r32, "signups"."twitter_login" AS t3_r33, "signups"."is_facebook_fan" AS t3_r34, "signups"."is_twitter_follower" AS t3_r35, "signups"."last_donated_at" AS t3_r36, "signups"."address_id" AS t3_r37, "signups"."parent_id" AS t3_r38, "signups"."is_fundraiser" AS t3_r39, "signups"."donations_raised_amount_in_cents" AS t3_r40, "signups"."donations_raised_count" AS t3_r41, "signups"."donations_to_raise_amount_in_cents" AS t3_r42, "signups"."last_contacted_by_id" AS t3_r43, "signups"."support_level" AS t3_r44, "signups"."last_contacted_at" AS t3_r45, "signups"."call_status_id" AS t3_r46, "signups"."support_level_changed_at" AS t3_r47, "signups"."warnings_count" AS t3_r48, "signups"."work_phone" AS t3_r49, "signups"."last_call_id" AS t3_r50, "signups"."donations_raised_amount_this_cycle_in_cents" AS t3_r51, "signups"."donations_raised_count_this_cycle" AS t3_r52, "signups"."donations_amount_this_cycle_in_cents" AS t3_r53, "signups"."donations_count_this_cycle" AS t3_r54, "signups"."is_survey_question_private" AS t3_r55, "signups"."children_count" AS t3_r56, "signups"."is_profile_private" AS t3_r57, "signups"."is_profile_searchable" AS t3_r58, "signups"."donations_pledged_amount_in_cents" AS t3_r59, "signups"."recruiter_id" AS t3_r60, "signups"."twitter_updated_at" AS t3_r61, "signups"."recruits_count" AS t3_r62, "signups"."van_id" AS t3_r63, "signups"."middle_name" AS t3_r64, "signups"."suffix" AS t3_r65, "signups"."state_file_id" AS t3_r66, "signups"."sex" AS t3_r67, "signups"."party" AS t3_r68, "signups"."born_at" AS t3_r69, "signups"."registered_at" AS t3_r70, "signups"."dw_id" AS t3_r71, "signups"."facebook_updated_at" AS t3_r72, "signups"."spent_capital_amount_in_cents" AS t3_r73, "signups"."received_capital_amount_in_cents" AS t3_r74, "signups"."capital_amount_in_cents" AS t3_r75, "signups"."assistant_id" AS t3_r76, "signups"."auto_import_id" AS t3_r77, "signups"."is_supporter" AS t3_r78, "signups"."first_donated_at" AS t3_r79, "signups"."could_vote_status" AS t3_r80, "signups"."is_leaderboardable" AS t3_r81, "signups"."do_not_call" AS t3_r82, "signups"."do_not_contact" AS t3_r83, "signups"."broadcaster_id" AS t3_r84, "signups"."cim_id" AS t3_r85, "signups"."username" AS t3_r86, "signups"."rule_violations_count" AS t3_r87, "signups"."last_rule_violation_at" AS t3_r88, "signups"."banned_at" AS t3_r89, "signups"."twitter_error_count" AS t3_r90, "signups"."facebook_error_count" AS t3_r91, "signups"."is_twitter_protected" AS t3_r92, "signups"."facebook_username" AS t3_r93, "signups"."twitter_name" AS t3_r94, "signups"."twitter_description" AS t3_r95, "signups"."twitter_website" AS t3_r96, "signups"."twitter_location" AS t3_r97, "signups"."klout_score" AS t3_r98, "signups"."twitter_friends_count" AS t3_r99, "signups"."twitter_followers_count" AS t3_r100, "signups"."is_prospect" AS t3_r101, "signups"."phone_country_code" AS t3_r102, "signups"."phone_number" AS t3_r103, "signups"."mobile_number" AS t3_r104, "signups"."mobile_country_code" AS t3_r105, "signups"."work_phone_number" AS t3_r106, "signups"."work_phone_country_code" AS t3_r107, "signups"."email_hashed" AS t3_r108, "signups"."membership_level_id" AS t3_r109, "signups"."membership_expires_at" AS t3_r110, "signups"."membership_started_at" AS t3_r111, "signups"."meetup_id" AS t3_r112, "signups"."meetup_name" AS t3_r113, "signups"."meetup_bio" AS t3_r114, "signups"."meetup_profile_image_url" AS t3_r115, "signups"."meetup_crawled_at" AS t3_r116, "signups"."meetup_error_count" AS t3_r117, "signups"."civicrm_id" AS t3_r118, "signups"."external_id" AS t3_r119, "signups"."invoice_payments_referred_amount_in_cents" AS t3_r120, "signups"."invoice_payments_amount_in_cents" AS t3_r121, "signups"."is_possible_duplicate" AS t3_r122, "signups"."prefix" AS t3_r123, "signups"."pf_strat_id" AS t3_r124, "signups"."household_id" AS t3_r125, "signups"."federal_donotcall" AS t3_r126, "signups"."demo" AS t3_r127, "signups"."mailing_address_id" AS t3_r128, "signups"."registered_address_id" AS t3_r129, "signups"."note" AS t3_r130, "signups"."note_updated_at" AS t3_r131, "signups"."is_mobile_bad" AS t3_r132, "signups"."work_address_id" AS t3_r133, "signups"."is_ignore_donation_limits" AS t3_r134, "signups"."billing_address_id" AS t3_r135, "signups"."twitter_address_id" AS t3_r136, "signups"."facebook_address_id" AS t3_r137, "signups"."meetup_address_id" AS t3_r138, "signups"."user_submitted_address_id" AS t3_r139, "signups"."email2" AS t3_r140, "signups"."email3" AS t3_r141, "signups"."email4" AS t3_r142, "signups"."email2_bounced_at" AS t3_r143, "signups"."email2_bounce_count" AS t3_r144, "signups"."email2_bounce_status" AS t3_r145, "signups"."email2_bounce_reason" AS t3_r146, "signups"."email2_spam_reported_at" AS t3_r147, "signups"."email2_is_invalid" AS t3_r148, "signups"."email2_invalid_reason" AS t3_r149, "signups"."email2_is_bad" AS t3_r150, "signups"."email3_bounced_at" AS t3_r151, "signups"."email3_bounce_count" AS t3_r152, "signups"."email3_bounce_status" AS t3_r153, "signups"."email3_bounce_reason" AS t3_r154, "signups"."email3_spam_reported_at" AS t3_r155, "signups"."email3_is_invalid" AS t3_r156, "signups"."email3_invalid_reason" AS t3_r157, "signups"."email3_is_bad" AS t3_r158, "signups"."email4_bounced_at" AS t3_r159, "signups"."email4_bounce_count" AS t3_r160, "signups"."email4_bounce_status" AS t3_r161, "signups"."email4_bounce_reason" AS t3_r162, "signups"."email4_spam_reported_at" AS t3_r163, "signups"."email4_is_invalid" AS t3_r164, "signups"."email4_invalid_reason" AS t3_r165, "signups"."email4_is_bad" AS t3_r166, "signups"."precinct_id" AS t3_r167, "signups"."primary_address_id" AS t3_r168, "signups"."grandparent_id" AS t3_r169, "signups"."federal_district" AS t3_r170, "signups"."state_lower_district" AS t3_r171, "signups"."state_upper_district" AS t3_r172, "signups"."city_district" AS t3_r173, "signups"."judicial_district" AS t3_r174, "signups"."school_district" AS t3_r175, "signups"."media_market_id" AS t3_r176, "signups"."is_deceased" AS t3_r177, "signups"."county_file_id" AS t3_r178, "signups"."religion" AS t3_r179, "signups"."church" AS t3_r180, "signups"."ethnicity" AS t3_r181, "signups"."legal_name" AS t3_r182, "signups"."language" AS t3_r183, "signups"."support_probability_score" AS t3_r184, "signups"."turnout_probability_score" AS t3_r185, "signups"."county_district" AS t3_r186, "signups"."village_district" AS t3_r187, "signups"."school_sub_district" AS t3_r188, "signups"."fire_district" AS t3_r189, "signups"."marital_status" AS t3_r190, "signups"."fax" AS t3_r191, "signups"."fax_number" AS t3_r192, "signups"."fax_country_code" AS t3_r193, "signups"."author_id" AS t3_r194, "signups"."primary_email_id" AS t3_r195, "signups"."switchvox_id" AS t3_r196, "signups"."switchvox_extension" AS t3_r197, "signups"."previous_party" AS t3_r198, "signups"."inferred_party" AS t3_r199, "signups"."inferred_support_level" AS t3_r200, "signups"."invoices_count" AS t3_r201, "signups"."closed_invoices_count" AS t3_r202, "signups"."outstanding_invoices_count" AS t3_r203, "signups"."invoices_amount_in_cents" AS t3_r204, "signups"."closed_invoices_amount_in_cents" AS t3_r205, "signups"."outstanding_invoices_amount_in_cents" AS t3_r206, "signups"."first_invoice_at" AS t3_r207, "signups"."last_invoice_at" AS t3_r208, "signups"."active_customer_started_at" AS t3_r209, "signups"."active_customer_expires_at" AS t3_r210, "signups"."priority_level" AS t3_r211, "signups"."priority_level_changed_at" AS t3_r212, "signups"."contact_status_id" AS t3_r213, "signups"."profile_content" AS t3_r214, "signups"."profile_content_html" AS t3_r215, "signups"."profile_headline" AS t3_r216, "signups"."first_supporter_at" AS t3_r217, "signups"."first_prospect_at" AS t3_r218, "signups"."first_recruited_at" AS t3_r219, "signups"."first_volunteer_at" AS t3_r220, "signups"."first_fundraised_at" AS t3_r221, "signups"."last_fundraised_at" AS t3_r222, "signups"."nbec_guid" AS t3_r223, "signups"."overdue_invoices_count" AS t3_r224, "signups"."custom_values" AS t3_r225, "signups"."cached_tag_ids" AS t3_r226, "signups"."salesforce_id" AS t3_r227, "signups"."nbec_precinct_id" AS t3_r228, "signups"."permission_set_id" AS t3_r229, "signups"."locale" AS t3_r230, "signups"."labour_region" AS t3_r231, "signups"."supranational_district" AS t3_r232, "signups"."party_member" AS t3_r233, "signups"."rnc_id_old" AS t3_r234, "signups"."rnc_regid" AS t3_r235, "signups"."city_sub_district" AS t3_r236, "signups"."rnc_id" AS t3_r237, "signups"."datatrust_id" AS t3_r238, "signups"."township" AS t3_r239, "signups"."ward" AS t3_r240, "signups"."inferred_gender" AS t3_r241, "signups"."inferred_demo" AS t3_r242, "signups"."signup_type" AS t3_r243 FROM "pages" INNER JOIN "suggestion_pages" ON "suggestion_pages"."page_id" = "pages"."id" LEFT OUTER JOIN "sites" ON "sites"."id" = "pages"."site_id" LEFT OUTER JOIN "signups" ON "signups"."id" = "pages"."author_id" WHERE "pages"."parent_id" = 21 AND (pages.status_id = 2) AND "pages"."page_type_id" = 13 ORDER BY pages.published_at DESC LIMIT 20 OFFSET 0
Like this page to spread the word