Did a host refer you?
No
Liquid error: PG::UndefinedColumn: ERROR: column signups.rnc_id_old does not exist
LINE 1: ... AS t1_r225, "signups"."party_member" AS t1_r226, "signups"....
^
: SELECT "event_hosts"."id" AS t0_r0, "event_hosts"."page_id" AS t0_r1, "event_hosts"."event_page_id" AS t0_r2, "event_hosts"."signup_id" AS t0_r3, "event_hosts"."created_at" AS t0_r4, "event_hosts"."updated_at" AS t0_r5, "signups"."id" AS t1_r0, "signups"."first_name" AS t1_r1, "signups"."last_name" AS t1_r2, "signups"."email1" AS t1_r3, "signups"."email_opt_in" AS t1_r4, "signups"."submitted_address" AS t1_r5, "signups"."is_volunteer" AS t1_r6, "signups"."availability" AS t1_r7, "signups"."phone" AS t1_r8, "signups"."mobile" AS t1_r9, "signups"."mobile_opt_in" AS t1_r10, "signups"."phone_time" AS t1_r11, "signups"."created_at" AS t1_r12, "signups"."updated_at" AS t1_r13, "signups"."unsubscribed_at" AS t1_r14, "signups"."email1_spam_reported_at" AS t1_r15, "signups"."email1_bounced_at" AS t1_r16, "signups"."email1_bounce_count" AS t1_r17, "signups"."email1_bounce_status" AS t1_r18, "signups"."email1_bounce_reason" AS t1_r19, "signups"."email1_is_bad" AS t1_r20, "signups"."full_name" AS t1_r21, "signups"."ngp_id" AS t1_r22, "signups"."import_id" AS t1_r23, "signups"."page_id" AS t1_r24, "signups"."employer" AS t1_r25, "signups"."occupation" AS t1_r26, "signups"."donations_amount_in_cents" AS t1_r27, "signups"."donations_count" AS t1_r28, "signups"."email1_is_invalid" AS t1_r29, "signups"."email1_invalid_reason" AS t1_r30, "signups"."facebook_uid" AS t1_r31, "signups"."twitter_id" AS t1_r32, "signups"."twitter_login" AS t1_r33, "signups"."is_facebook_fan" AS t1_r34, "signups"."is_twitter_follower" AS t1_r35, "signups"."last_donated_at" AS t1_r36, "signups"."address_id" AS t1_r37, "signups"."parent_id" AS t1_r38, "signups"."is_fundraiser" AS t1_r39, "signups"."donations_raised_amount_in_cents" AS t1_r40, "signups"."donations_raised_count" AS t1_r41, "signups"."donations_to_raise_amount_in_cents" AS t1_r42, "signups"."last_contacted_by_id" AS t1_r43, "signups"."support_level" AS t1_r44, "signups"."last_contacted_at" AS t1_r45, "signups"."call_status_id" AS t1_r46, "signups"."support_level_changed_at" AS t1_r47, "signups"."warnings_count" AS t1_r48, "signups"."work_phone" AS t1_r49, "signups"."last_call_id" AS t1_r50, "signups"."donations_raised_amount_this_cycle_in_cents" AS t1_r51, "signups"."donations_raised_count_this_cycle" AS t1_r52, "signups"."donations_amount_this_cycle_in_cents" AS t1_r53, "signups"."donations_count_this_cycle" AS t1_r54, "signups"."is_survey_question_private" AS t1_r55, "signups"."children_count" AS t1_r56, "signups"."is_profile_private" AS t1_r57, "signups"."is_profile_searchable" AS t1_r58, "signups"."donations_pledged_amount_in_cents" AS t1_r59, "signups"."recruiter_id" AS t1_r60, "signups"."twitter_updated_at" AS t1_r61, "signups"."recruits_count" AS t1_r62, "signups"."van_id" AS t1_r63, "signups"."middle_name" AS t1_r64, "signups"."suffix" AS t1_r65, "signups"."state_file_id" AS t1_r66, "signups"."sex" AS t1_r67, "signups"."party" AS t1_r68, "signups"."born_at" AS t1_r69, "signups"."registered_at" AS t1_r70, "signups"."dw_id" AS t1_r71, "signups"."facebook_updated_at" AS t1_r72, "signups"."spent_capital_amount_in_cents" AS t1_r73, "signups"."received_capital_amount_in_cents" AS t1_r74, "signups"."capital_amount_in_cents" AS t1_r75, "signups"."assistant_id" AS t1_r76, "signups"."auto_import_id" AS t1_r77, "signups"."is_supporter" AS t1_r78, "signups"."first_donated_at" AS t1_r79, "signups"."could_vote_status" AS t1_r80, "signups"."is_leaderboardable" AS t1_r81, "signups"."do_not_call" AS t1_r82, "signups"."do_not_contact" AS t1_r83, "signups"."broadcaster_id" AS t1_r84, "signups"."cim_id" AS t1_r85, "signups"."username" AS t1_r86, "signups"."rule_violations_count" AS t1_r87, "signups"."last_rule_violation_at" AS t1_r88, "signups"."banned_at" AS t1_r89, "signups"."twitter_error_count" AS t1_r90, "signups"."facebook_error_count" AS t1_r91, "signups"."is_twitter_protected" AS t1_r92, "signups"."facebook_username" AS t1_r93, "signups"."twitter_name" AS t1_r94, "signups"."twitter_description" AS t1_r95, "signups"."twitter_website" AS t1_r96, "signups"."twitter_location" AS t1_r97, "signups"."klout_score" AS t1_r98, "signups"."twitter_friends_count" AS t1_r99, "signups"."twitter_followers_count" AS t1_r100, "signups"."is_prospect" AS t1_r101, "signups"."phone_country_code" AS t1_r102, "signups"."phone_number" AS t1_r103, "signups"."mobile_number" AS t1_r104, "signups"."mobile_country_code" AS t1_r105, "signups"."work_phone_number" AS t1_r106, "signups"."work_phone_country_code" AS t1_r107, "signups"."email_hashed" AS t1_r108, "signups"."meetup_id" AS t1_r109, "signups"."meetup_name" AS t1_r110, "signups"."meetup_bio" AS t1_r111, "signups"."meetup_profile_image_url" AS t1_r112, "signups"."meetup_crawled_at" AS t1_r113, "signups"."meetup_error_count" AS t1_r114, "signups"."civicrm_id" AS t1_r115, "signups"."invoice_payments_referred_amount_in_cents" AS t1_r116, "signups"."invoice_payments_amount_in_cents" AS t1_r117, "signups"."is_possible_duplicate" AS t1_r118, "signups"."prefix" AS t1_r119, "signups"."pf_strat_id" AS t1_r120, "signups"."household_id" AS t1_r121, "signups"."federal_donotcall" AS t1_r122, "signups"."demo" AS t1_r123, "signups"."mailing_address_id" AS t1_r124, "signups"."registered_address_id" AS t1_r125, "signups"."note" AS t1_r126, "signups"."note_updated_at" AS t1_r127, "signups"."is_mobile_bad" AS t1_r128, "signups"."work_address_id" AS t1_r129, "signups"."is_ignore_donation_limits" AS t1_r130, "signups"."billing_address_id" AS t1_r131, "signups"."twitter_address_id" AS t1_r132, "signups"."facebook_address_id" AS t1_r133, "signups"."meetup_address_id" AS t1_r134, "signups"."user_submitted_address_id" AS t1_r135, "signups"."email2" AS t1_r136, "signups"."email3" AS t1_r137, "signups"."email4" AS t1_r138, "signups"."email2_bounced_at" AS t1_r139, "signups"."email2_bounce_count" AS t1_r140, "signups"."email2_bounce_status" AS t1_r141, "signups"."email2_bounce_reason" AS t1_r142, "signups"."email2_spam_reported_at" AS t1_r143, "signups"."email2_is_invalid" AS t1_r144, "signups"."email2_invalid_reason" AS t1_r145, "signups"."email2_is_bad" AS t1_r146, "signups"."email3_bounced_at" AS t1_r147, "signups"."email3_bounce_count" AS t1_r148, "signups"."email3_bounce_status" AS t1_r149, "signups"."email3_bounce_reason" AS t1_r150, "signups"."email3_spam_reported_at" AS t1_r151, "signups"."email3_is_invalid" AS t1_r152, "signups"."email3_invalid_reason" AS t1_r153, "signups"."email3_is_bad" AS t1_r154, "signups"."email4_bounced_at" AS t1_r155, "signups"."email4_bounce_count" AS t1_r156, "signups"."email4_bounce_status" AS t1_r157, "signups"."email4_bounce_reason" AS t1_r158, "signups"."email4_spam_reported_at" AS t1_r159, "signups"."email4_is_invalid" AS t1_r160, "signups"."email4_invalid_reason" AS t1_r161, "signups"."email4_is_bad" AS t1_r162, "signups"."precinct_id" AS t1_r163, "signups"."primary_address_id" AS t1_r164, "signups"."grandparent_id" AS t1_r165, "signups"."federal_district" AS t1_r166, "signups"."state_lower_district" AS t1_r167, "signups"."state_upper_district" AS t1_r168, "signups"."city_district" AS t1_r169, "signups"."judicial_district" AS t1_r170, "signups"."school_district" AS t1_r171, "signups"."media_market_id" AS t1_r172, "signups"."is_deceased" AS t1_r173, "signups"."county_file_id" AS t1_r174, "signups"."religion" AS t1_r175, "signups"."church" AS t1_r176, "signups"."ethnicity" AS t1_r177, "signups"."legal_name" AS t1_r178, "signups"."language" AS t1_r179, "signups"."support_probability_score" AS t1_r180, "signups"."turnout_probability_score" AS t1_r181, "signups"."county_district" AS t1_r182, "signups"."village_district" AS t1_r183, "signups"."school_sub_district" AS t1_r184, "signups"."fire_district" AS t1_r185, "signups"."marital_status" AS t1_r186, "signups"."fax" AS t1_r187, "signups"."fax_number" AS t1_r188, "signups"."fax_country_code" AS t1_r189, "signups"."author_id" AS t1_r190, "signups"."primary_email_id" AS t1_r191, "signups"."previous_party" AS t1_r192, "signups"."inferred_party" AS t1_r193, "signups"."inferred_support_level" AS t1_r194, "signups"."invoices_count" AS t1_r195, "signups"."closed_invoices_count" AS t1_r196, "signups"."outstanding_invoices_count" AS t1_r197, "signups"."invoices_amount_in_cents" AS t1_r198, "signups"."closed_invoices_amount_in_cents" AS t1_r199, "signups"."outstanding_invoices_amount_in_cents" AS t1_r200, "signups"."first_invoice_at" AS t1_r201, "signups"."last_invoice_at" AS t1_r202, "signups"."active_customer_started_at" AS t1_r203, "signups"."active_customer_expires_at" AS t1_r204, "signups"."priority_level" AS t1_r205, "signups"."priority_level_changed_at" AS t1_r206, "signups"."contact_status_id" AS t1_r207, "signups"."profile_content" AS t1_r208, "signups"."profile_content_html" AS t1_r209, "signups"."profile_headline" AS t1_r210, "signups"."first_supporter_at" AS t1_r211, "signups"."first_prospect_at" AS t1_r212, "signups"."first_recruited_at" AS t1_r213, "signups"."first_volunteer_at" AS t1_r214, "signups"."first_fundraised_at" AS t1_r215, "signups"."last_fundraised_at" AS t1_r216, "signups"."nbec_guid" AS t1_r217, "signups"."overdue_invoices_count" AS t1_r218, "signups"."custom_values" AS t1_r219, "signups"."salesforce_id" AS t1_r220, "signups"."nbec_precinct_id" AS t1_r221, "signups"."permission_set_id" AS t1_r222, "signups"."locale" AS t1_r223, "signups"."labour_region" AS t1_r224, "signups"."supranational_district" AS t1_r225, "signups"."party_member" AS t1_r226, "signups"."rnc_id_old" AS t1_r227, "signups"."rnc_regid" AS t1_r228, "signups"."city_sub_district" AS t1_r229, "signups"."rnc_id" AS t1_r230, "signups"."external_id" AS t1_r231, "signups"."datatrust_id" AS t1_r232, "signups"."township" AS t1_r233, "signups"."ward" AS t1_r234, "signups"."inferred_gender" AS t1_r235, "signups"."inferred_demo" AS t1_r236, "signups"."signup_type" AS t1_r237 FROM "event_hosts" LEFT OUTER JOIN "signups" ON "signups"."id" = "event_hosts"."signup_id" WHERE "event_hosts"."event_page_id" = 157 ORDER BY signups.last_name, signups.first_name
Showing 3 reactions