.psql_history

update pgdatabase set datallowconn = TRUE where datname = 'template0';
update pgdatabase set datallowconn = TRUE where datname = 'template0';
show databases;
ls
databases;
ls db
\list
\tables
tables
show tables;
\dt
\list
\list
\q
 update pgdatabase set datallowconn = TRUE where datname = 'template0';
ls
\q
\ls
ls
\d
\dt
\dt
\list
\dt 
use eshares_dev
\dt
\d
\q
\ld
\d
\dl
\l
select username from pg_user;
ls
\list
use postgres
select username from pg_user;
use postgres;
\postgres
\connect postgres
select username from pg_user;
select username from pg_user;
select * from pg_user;
create role foobar;
ls
select * from pg_user;
select * from pg_user;
ls
\connect postgres
select * from pg_user;
select * from pg_user;
create role foobar;
select * from pg_user;
select * from pg_roles;
select * from pg_roles;
select * from pg_users;
select * from pg_user;
select * from pg_roles;
delete from roles where rolname='foobar'
;
delete * from pg_roles where rolname=`foobar`
;
delete from roles where rolname='foobar'
;
delete from pg_roles where rolname=`foobar`
;
delete from roles where rolname='foobar';
delete from pg_roles where rolname='foobar';
delte from pg_roles where rolname='foobar';
delete from pg_roles where rolname='foobar';
drop role foobar;
select * from pg_roles;
select * from pg_user;
create user foobar;
select * from pg_user;
select * from pg_roles;
drop user foobar;
select * from pg_user;
select * from pg_roles;
clear
\list
\d
ls
use eshares_dev
;
ls
\d
\dl
\d
\s
\l
\dt
\dt
\connect eshares_dev
\dt
\q
\d corporations_corporation;
\qq
\q
\q
ls
\list
\q
\list
use eshares_tests
\ls
\q
\dt
select * from organizations_entityorgpermission;
\q
\q
\q
\d+ corporations_corporation
\d+ certificates_certificate
select table_name, pg_relation_size(table_name)
from information_schema.tables
where table_schema = 'public'
order by 2
;
select table_name, pg_relation_size(table_name)
from information_schema.tables
where table_schema = 'public'
order by 1;
\d+ certificates_certificate
clear
\!
\! cls
\! clear
\d+ organizations_organization
\d+ corporations_corporation
\d+ organizations_organizationmembership;
\q
\d+ certificates_certificate
\d+ certificates_certificate
\q
\d+ certificates_certificate
\q
\d+ corporations_corporation;
\q
\q
select * from corporations_corporation;
\d+
\d
\t
\dt
\q
select * from corporations_corporation;
\dt
\dt
\q
\d+ certificates_certificate;
\d+ corporations_stakeholder;
\d+ corporations_stakeholder;
\d+ certificates_certificate;
\d+ certificates_certificate;
\d+ corporations_stakeholder;
\d+ corporations_corporationuserroles;
select token from corporations_stakeholder;
select distinct token from corporations_stakeholder;
q\
\q
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
SELECT uuid_in(md5(random()::text || now()::text)::cstring);
update token from corporations_stakeholder set token = (SELECT uuid_in(md5(random()::text || now()::text)::cstring));
update corporations_stakeholder set token = (SELECT uuid_in(md5(random()::text || now()::text)::cstring));
select token from corporations_stakeholder;
update corporations_stakeholder set token = (SELECT uuid_in(md5(random()::text || clock_timestamp()::text)::cstring));
select token from corporations_stakeholder;
update corporations_stakeholder set token = (SELECT gen_random_uuid());
update corporations_stakeholder set token = gen_random_uuid();
CREATE EXTENSION "pgcrypto";
update corporations_stakeholder set token = gen_random_uuid();
select token from corporations_stakeholder;
update corporations_stakeholder set token = gen_random_uuid();
select token from corporations_stakeholder;
\q
\d+ corporations_corporation;
\d+ corporations_corporation
\d+ corporations_corporation
select count(*) from corporations_corporation where is_void = false;
select count(*) from corporations_corporation where is_void = true;
select count(*) from corporations_corporation where is_void = false;
\d+ corporations_corporationuserroles;
\d+ corporations_corporationuserroles;
\d+ corporations_corporationuserroles;
\d+ corporations_;
\d+ corporations_corporationuserroles;
\d+ corporations_corporation
select has_two_factor_auth from corporations_corporation
\d+ certificates_certificate;
\d+ certificates_certificate;
\d+ corporations_corporation;
psql
\q
\q
\d+ corporations_entityorgpermission;
\d+ organizations_entityorgpermission;
\q
\d+ corporations_stakeholder;
\d+ corporations_certificate;
\d+ corporations_certificates;
\d+ certificates_certificate;
\d+ certificates_certificate;
\d+ corporations_stakeholder;
\d+ corporations_entityorgpermission;
\q
\d+ certificates_certificate;
\d+ warrants_warrants
\d+ warrants_warrants
\d+ warrants_warrant
\d+ certificates_certificate
\d+ warrants_warrant
\d+ corporations_corporation
\q
\q
\q
\d+ auth_user;
\q
\d+ two_factor_phonedevice
exit
\q
\d+ common_uploadedfile
exit
\q
\d+ onboarding_setup_task
\d+ onboarding_setup_tasks
\d+ onboarding_setuptasks
\d+ onboarding_setuptasks
\q
select table_name from information_schema.columns where column_name like '%created_by%'
\d+ asc718_asc718assumption
\d+ asc718_asc718assumptiongroup
\d+ asc718_asc718assumptionpeergroup
\d+ asc718_asc718fmv
\d+ asc718_asc718settings
\d+ certificates_draftcertificate
\d+ certificates_draftcertificate
\d+ certificates_draftcertificate
\d+ onboarding_onboardingimportresults
\d+ onboarding_onboardingimportresults
\d+ onboarding_onboardingrequest
\d+ onboarding_onboardingrequest
\d+ asc718_asc718fmv
\q
\d+ onboarding_setupguide
\q
\d+ corporations_corporation
\d
\q
\q
select * from corporations_corporation;
\d+ corporations_corporation
\d+ corporations_corporation
q
\q
\d+ corporations_corporation
\q
\d+ corporations_corporation_onboarding_request
\d+ corporations_corporation_onboardingrequest
\d+ corporations_corporationonboardingrequest
\q
\d+ onboarding_onboarding_request
\d+ onboardings_onboarding_request
\d+ onboardings_onboardingrequest
\d+ onboarding_onboardingrequest
\q
\d+ corporations_corporation
\q
\d+ organizations_organization
\q

select table_name from information_schema.columns where column_name like '%onboarding%'
select * from corporations_corporationonboardingrequest;
select table_name from information_schema.columns where column_name like '%onboarding%'
select * from corporations_corporationonboardingrequest;
select * from corporations_corporationonboardingrequest;
\d+ onboarding_onboarding_request
\d+ onboarding_onboardingrequest
\d+ onboarding_setupguide
select primary_contact from corporations_corporation;
select primary_contact_id from corporations_corporation;
\q
select * from corporations_corporationonboardingrequest;
select * from corporations_onboardingrequest;
select * from corporations_corporation;
select * from corporations_corporation;
select * from corporations_corporationonboardingrequest;
\q
\d
\q
\d+ onboarding_setuptask
\d
\q
\q
\d+ onboarding_setuptask
\d+ onboarding_setupphase
\q
CREATE EXTENSION pg_trgm;
\q
\q
\q
CREATE EXTENSION pg_trgm;
\q
dropdb 'database name'
dropdb 'eshares_dev'
select * from corporations_corporation;
dropdb 'eshares_dev';
\d+ corporations_corporation
\q
\q
\q
\q
\q
select * from pg_stat_activity order by xact_start desc;
\q
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."setup_complete" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."archived" = False AND T3."is_active" = True AND T3."subscription_type" = platform_basic AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id"
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."setup_complete" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."archived" = False AND T3."is_active" = True AND T3."subscription_type" = platform_basic AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id"
SELECT * FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") 
WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."setup_complete" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."archived" = False AND T3."is_active" = True AND T3."subscription_type" = platform_basic AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id"
SELECT 
* 
FROM "corporations_corporation" 
LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") 
WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."setup_complete" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."archived" = False AND T3."is_active" = True AND T3."subscription_type" = platform_basic AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL))
SELECT 
* 
FROM "corporations_corporation" 
LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") 
WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."setup_complete" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."archived" = False AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL))
SELECT 
* 
FROM "corporations_corporation" 
LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") 
WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."setup_complete" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."archived" = False AND T3."is_active" = True AND T3."subscription_type" = "platform" AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL))
select * from subscriptions_subscription;
select * from subscriptions_subscription
;
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id"
(Pdb) 
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id"
(Pdb) 
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
SELECT 
"corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id"
(Pdb) 
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform_basic", "platform", "platform_plus") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform_basic", "platform", "platform_plus") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform_basic", "platform", "platform_plus") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform_basic", "platform", "platform_plus") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform_basic", "platform", "platform_plus") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform_basic", "platform", "platform_plus") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform_basic", "platform", "platform_plus") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
exit
\q
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_plus, platform_basic, platform) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."setup_complete" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."archived" = False AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
clear
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN (platform_basic, platform, platform_plus) AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = platform AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ("platform") AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = "platform" AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = 'platform' AND T3."start_date" <= 2017-04-07 AND (T3."end_date" >= 2017-04-07 OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
SELECT "corporations_corporation"."id", "corporations_corporation"."created", "corporations_corporation"."modified", "corporations_corporation"."created_by_id", "corporations_corporation"."is_void", "corporations_corporation"."account_id", "corporations_corporation"."default_payment_source", "corporations_corporation"."type", "corporations_corporation"."can_issue", "corporations_corporation"."can_hold", "corporations_corporation"."requires_foia_compliance", "corporations_corporation"."requires_erisa_compliance", "corporations_corporation"."purpose", "corporations_corporation"."include_in_all_funds", "corporations_corporation"."fund_family_id", "corporations_corporation"."fund_order", "corporations_corporation"."prosperworks_id", "corporations_corporation"."is_sharing_dashboard", "corporations_corporation"."is_sharing_portfolio", "corporations_corporation"."is_sharing_portfolio_spreadsheet", "corporations_corporation"."is_sharing_tags", "corporations_corporation"."is_sharing_date", "corporations_corporation"."is_sharing_quantity", "corporations_corporation"."is_sharing_ownership", "corporations_corporation"."is_sharing_cost", "corporations_corporation"."is_sharing_value", "corporations_corporation"."is_sharing_gain_loss", "corporations_corporation"."lp_sharing_to_date", "corporations_corporation"."properties_base", "corporations_corporation"."properties_override", "corporations_corporation"."legal_name", "corporations_corporation"."dba", "corporations_corporation"."tax_id", "corporations_corporation"."tcc_code", "corporations_corporation"."address", "corporations_corporation"."city", "corporations_corporation"."state", "corporations_corporation"."zip", "corporations_corporation"."county", "corporations_corporation"."country", "corporations_corporation"."currency", "corporations_corporation"."phone", "corporations_corporation"."website", "corporations_corporation"."description", "corporations_corporation"."hide_convertible_note_interest", "corporations_corporation"."logo_id", "corporations_corporation"."articles_of_incorporation_id", "corporations_corporation"."bylaws_id", "corporations_corporation"."salesforce_id", "corporations_corporation"."wanted_subscription_period", "corporations_corporation"."is_eshares_company", "corporations_corporation"."asc820_organization_id", "corporations_corporation"."parent_org_id", "corporations_corporation"."converted_into_org_id", "corporations_corporation"."entity_type", "corporations_corporation"."date_of_incorporation", "corporations_corporation"."state_of_incorporation", "corporations_corporation"."gbr_crn_number", "corporations_corporation"."linked_corporation_id", "corporations_corporation"."onboarding_corporation", "corporations_corporation"."date_of_exit", "corporations_corporation"."reason_of_exit", "corporations_corporation"."request_cap_cur_id", "corporations_corporation"."option_exercise_approver_cur_id", "corporations_corporation"."primary_contact_id", "corporations_corporation"."security_contact_cur_id", "corporations_corporation"."investor_access_contact_cur_id", "corporations_corporation"."transaction_contact_cur_id", "corporations_corporation"."document_contact_cur_id", "corporations_corporation"."vesting_contact_cur_id", "corporations_corporation"."left_signatory_cur_id", "corporations_corporation"."left_signatory_title", "corporations_corporation"."right_signatory_cur_id", "corporations_corporation"."right_signatory_title", "corporations_corporation"."option_signatory_cur_id", "corporations_corporation"."warrant_signatory_cur_id", "corporations_corporation"."convertible_note_signatory_cur_id", "corporations_corporation"."account_manager_id", "corporations_corporation"."onboarding_manager_id", "corporations_corporation"."onboarding_complete", "corporations_corporation"."has_downloaded_spreadsheet", "corporations_corporation"."law_firm", "corporations_corporation"."accountant", "corporations_corporation"."_409a_billing_type", "corporations_corporation"."internal_notes", "corporations_corporation"."permissions_last_edited", "corporations_corporation"."permissions_last_edited_by_id", "corporations_corporation"."is_invoiced", "corporations_corporation"."invoicing_notes", "corporations_corporation"."invoicing_details", "corporations_corporation"."ach_exercise", "corporations_corporation"."sent_ach_exercise_emails", "corporations_corporation"."enable_beta_features", "corporations_corporation"."share_ownership_percentage", "corporations_corporation"."skip_cache_clear", "corporations_corporation"."accreditation_docs_id", "corporations_corporation"."accreditation_verified", "corporations_corporation"."rewind_minimum_date", "corporations_corporation"."setup_complete", "corporations_corporation"."fiscal_year_start_date", "corporations_corporation"."archived", "corporations_corporation"."hide_option_export", "corporations_corporation"."financings_enabled", "corporations_corporation"."form_3921_enabled", "corporations_corporation"."read_only", "corporations_corporation"."icebox_reason", "corporations_corporation"."enable_new_409a", "corporations_corporation"."enable_xero", "corporations_corporation"."enable_waterfall", "corporations_corporation"."cbus_enabled", "corporations_corporation"."pius_enabled", "corporations_corporation"."requires_two_factor", "corporations_corporation"."set_up_by_law_firm_id", "corporations_corporation"."go_live_date", "corporations_corporation"."onboarding_billed", "corporations_corporation"."onboarding_billed_by_id", "corporations_corporation"."first_name", "corporations_corporation"."last_name", "corporations_corporation"."last_signature_email", "corporations_corporation"."summary_activity_page_enabled", "corporations_corporation"."security_locks", "corporations_corporation"."enable_new_permissions", "corporations_corporation"."show_fmvs_in_portfolios", "corporations_corporation"."hide_dollars_in_portfolios", "corporations_corporation"."auto_ACH", "corporations_corporation"."source_type", "corporations_corporation"."share_financials_date", "corporations_corporation"."industries", "corporations_corporation"."disclosure_701_file_id", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) AS "latest_subscription_end_date", MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) AS "next_bill_date", CASE WHEN (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) <= (MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END)) OR MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) IS NULL) THEN MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."next_bill_date" ELSE NULL END) ELSE MAX(CASE WHEN ("subscriptions_subscription"."subscription_type" IN ('platform') AND "subscriptions_subscription"."is_void" = False) THEN "subscriptions_subscription"."end_date" ELSE NULL END) END AS "subscription_expiration", "customers_customer"."id", "customers_customer"."created", "customers_customer"."modified", "customers_customer"."created_by_id", "customers_customer"."is_void", "customers_customer"."number_of_tickets", "customers_customer"."next_contact_date", "corporations_corporationuserroles"."id", "corporations_corporationuserroles"."created", "corporations_corporationuserroles"."modified", "corporations_corporationuserroles"."created_by_id", "corporations_corporationuserroles"."is_void", "corporations_corporationuserroles"."token", "corporations_corporationuserroles"."email_token", "corporations_corporationuserroles"."invited_by_id", "corporations_corporationuserroles"."invite_reason", "corporations_corporationuserroles"."accepted_date", "corporations_corporationuserroles"."corporation_id", "corporations_corporationuserroles"."is_active", "corporations_corporationuserroles"."user_id", "corporations_corporationuserroles"."role_id", "corporations_corporationuserroles"."board_role", "corporations_corporationuserroles"."titles", "corporations_corporationuserroles"."portfolio_owner", "corporations_corporationuserroles"."last_visit", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "profiles_userprofile"."id", "profiles_userprofile"."created", "profiles_userprofile"."modified", "profiles_userprofile"."created_by_id", "profiles_userprofile"."is_void", "profiles_userprofile"."user_id", "profiles_userprofile"."image_id", "profiles_userprofile"."signature_line", "profiles_userprofile"."change_email_token", "profiles_userprofile"."ach_administrator", "profiles_userprofile"."is_contractor", "profiles_userprofile"."is_valuations_manager", "profiles_userprofile"."salesforce_id", "profiles_userprofile"."previous_accounts", "common_uploadedfile"."created", "common_uploadedfile"."modified", "common_uploadedfile"."created_by_id", "common_uploadedfile"."is_void", "common_uploadedfile"."eshares_url", "common_uploadedfile"."unmodified_url", "common_uploadedfile"."compressed_url", "common_uploadedfile"."url_pk", T9."id", T9."password", T9."last_login", T9."is_superuser", T9."username", T9."first_name", T9."last_name", T9."email", T9."is_staff", T9."is_active", T9."date_joined", "staff_corporationhealthcheckresult"."id", "staff_corporationhealthcheckresult"."created", "staff_corporationhealthcheckresult"."modified", "staff_corporationhealthcheckresult"."corporation_id", "staff_corporationhealthcheckresult"."stakeholder_count", "staff_corporationhealthcheckresult"."needs_refresh", "staff_corporationhealthcheckresult"."errors", "staff_corporationhealthcheckresult"."error_count", "staff_corporationhealthcheckresult"."last_run", "staff_corporationhealthcheckresult"."last_run_duration", "staff_corporationhealthcheckresult"."last_run_dates", "staff_corporationhealthcheckresult"."severity_score", "staff_corporationhealthcheckresult"."highest_severity_score" FROM "corporations_corporation" LEFT OUTER JOIN "subscriptions_subscription" ON ("corporations_corporation"."id" = "subscriptions_subscription"."corporation_id") INNER JOIN "subscriptions_subscription" T3 ON ("corporations_corporation"."id" = T3."corporation_id") LEFT OUTER JOIN "customers_customer" ON ("corporations_corporation"."account_id" = "customers_customer"."id") LEFT OUTER JOIN "corporations_corporationuserroles" ON ("corporations_corporation"."primary_contact_id" = "corporations_corporationuserroles"."id") LEFT OUTER JOIN "auth_user" ON ("corporations_corporationuserroles"."user_id" = "auth_user"."id") LEFT OUTER JOIN "profiles_userprofile" ON ("auth_user"."id" = "profiles_userprofile"."user_id") LEFT OUTER JOIN "common_uploadedfile" ON ("profiles_userprofile"."image_id" = "common_uploadedfile"."url_pk") LEFT OUTER JOIN "auth_user" T9 ON ("corporations_corporation"."account_manager_id" = T9."id") LEFT OUTER JOIN "staff_corporationhealthcheckresult" ON ("corporations_corporation"."id" = "staff_corporationhealthcheckresult"."corporation_id") WHERE (NOT ("corporations_corporation"."is_void" = True) AND "corporations_corporation"."archived" = False AND "corporations_corporation"."can_hold" = False AND "corporations_corporation"."can_issue" = True AND "corporations_corporation"."is_eshares_company" = True AND "corporations_corporation"."setup_complete" = True AND T3."is_active" = True AND T3."subscription_type" = 'platform' AND T3."start_date" <= '2017-04-07' AND (T3."end_date" >= '2017-04-07' OR T3."end_date" IS NULL)) GROUP BY "corporations_corporation"."id", "customers_customer"."id", "corporations_corporationuserroles"."id", "auth_user"."id", "profiles_userprofile"."id", "common_uploadedfile"."url_pk", T9."id", "staff_corporationhealthcheckresult"."id";
clear
\q
\d corporations_corporation
\d auditing_storedauditevent
XPLAIN SELECT 
"auditing_storedauditevent"."id",
"auditing_storedauditevent"."environment",
"auditing_storedauditevent"."klass",
"auditing_storedauditevent"."event_label",
"auditing_storedauditevent"."user_name",
"auditing_storedauditevent"."user_email",
"auditing_storedauditevent"."user_pk",
"auditing_storedauditevent"."impersonate_name",
"auditing_storedauditevent"."impersonate_email",
"auditing_storedauditevent"."impersonate_pk",
"auditing_storedauditevent"."ip_address",
"auditing_storedauditevent"."path",
"auditing_storedauditevent"."user_agent",
"auditing_storedauditevent"."session",
"auditing_storedauditevent"."referrer",
"auditing_storedauditevent"."request_hash",
"auditing_storedauditevent"."event_hash",
"auditing_storedauditevent"."process_celery",
"auditing_storedauditevent"."celery_task_name",
"auditing_storedauditevent"."original_html",
"auditing_storedauditevent"."context",
"auditing_storedauditevent"."affected_models",
"auditing_storedauditevent"."model_changed_pk",
"auditing_storedauditevent"."model_changed_table",
"auditing_storedauditevent"."is_ajax",
"auditing_storedauditevent"."is_fake",
"auditing_storedauditevent"."faked_reason",
"auditing_storedauditevent"."mongo_id",
"auditing_storedauditevent"."modified",
"auditing_storedauditevent"."created" 
FROM "auditing_storedauditevent" 
WHERE (
NOT ("auditing_storedauditevent"."context" IS NULL) 
AND "auditing_storedauditevent"."model_changed_table" = corporations_corporation 
AND "auditing_storedauditevent"."klass" = ModelChange 
AND "auditing_storedauditevent"."path" = /corporations/icebox/ 
AND "auditing_storedauditevent"."created" < 2017-04-20 07:29:04.258586)
EXPLAIN SELECT 
"auditing_storedauditevent"."id",
"auditing_storedauditevent"."environment",
"auditing_storedauditevent"."klass",
"auditing_storedauditevent"."event_label",
"auditing_storedauditevent"."user_name",
"auditing_storedauditevent"."user_email",
"auditing_storedauditevent"."user_pk",
"auditing_storedauditevent"."impersonate_name",
"auditing_storedauditevent"."impersonate_email",
"auditing_storedauditevent"."impersonate_pk",
"auditing_storedauditevent"."ip_address",
"auditing_storedauditevent"."path",
"auditing_storedauditevent"."user_agent",
"auditing_storedauditevent"."session",
"auditing_storedauditevent"."referrer",
"auditing_storedauditevent"."request_hash",
"auditing_storedauditevent"."event_hash",
"auditing_storedauditevent"."process_celery",
"auditing_storedauditevent"."celery_task_name",
"auditing_storedauditevent"."original_html",
"auditing_storedauditevent"."context",
"auditing_storedauditevent"."affected_models",
"auditing_storedauditevent"."model_changed_pk",
"auditing_storedauditevent"."model_changed_table",
"auditing_storedauditevent"."is_ajax",
"auditing_storedauditevent"."is_fake",
"auditing_storedauditevent"."faked_reason",
"auditing_storedauditevent"."mongo_id",
"auditing_storedauditevent"."modified",
"auditing_storedauditevent"."created" 
FROM "auditing_storedauditevent" 
WHERE (
NOT ("auditing_storedauditevent"."context" IS NULL) 
AND "auditing_storedauditevent"."model_changed_table" = corporations_corporation 
AND "auditing_storedauditevent"."klass" = ModelChange 
AND "auditing_storedauditevent"."path" = /corporations/icebox/ 
AND "auditing_storedauditevent"."created" < 2017-04-20 07:29:04.258586);
clear
EXPLAIN SELECT 
"auditing_storedauditevent"."id",
"auditing_storedauditevent"."environment",
"auditing_storedauditevent"."klass",
"auditing_storedauditevent"."event_label",
"auditing_storedauditevent"."user_name",
"auditing_storedauditevent"."user_email",
"auditing_storedauditevent"."user_pk",
"auditing_storedauditevent"."impersonate_name",
"auditing_storedauditevent"."impersonate_email",
"auditing_storedauditevent"."impersonate_pk",
"auditing_storedauditevent"."ip_address",
"auditing_storedauditevent"."path",
"auditing_storedauditevent"."user_agent",
"auditing_storedauditevent"."session",
"auditing_storedauditevent"."referrer",
"auditing_storedauditevent"."request_hash",
"auditing_storedauditevent"."event_hash",
"auditing_storedauditevent"."process_celery",
"auditing_storedauditevent"."celery_task_name",
"auditing_storedauditevent"."original_html",
"auditing_storedauditevent"."context",
"auditing_storedauditevent"."affected_models",
"auditing_storedauditevent"."model_changed_pk",
"auditing_storedauditevent"."model_changed_table",
"auditing_storedauditevent"."is_ajax",
"auditing_storedauditevent"."is_fake",
"auditing_storedauditevent"."faked_reason",
"auditing_storedauditevent"."mongo_id",
"auditing_storedauditevent"."modified",
"auditing_storedauditevent"."created" 
FROM "auditing_storedauditevent" 
WHERE (
NOT ("auditing_storedauditevent"."context" IS NULL) 
AND "auditing_storedauditevent"."model_changed_table" = 'corporations_corporation'
AND "auditing_storedauditevent"."klass" = 'ModelChange'
AND "auditing_storedauditevent"."path" = '/corporations/icebox/'
AND "auditing_storedauditevent"."created" < '2017-04-20 07:29:04.258586');
EXPLAIN SELECT 
"auditing_storedauditevent"."id",
"auditing_storedauditevent"."environment",
"auditing_storedauditevent"."klass",
"auditing_storedauditevent"."event_label",
"auditing_storedauditevent"."user_name",
"auditing_storedauditevent"."user_email",
"auditing_storedauditevent"."user_pk",
"auditing_storedauditevent"."impersonate_name",
"auditing_storedauditevent"."impersonate_email",
"auditing_storedauditevent"."impersonate_pk",
"auditing_storedauditevent"."ip_address",
"auditing_storedauditevent"."path",
"auditing_storedauditevent"."user_agent",
"auditing_storedauditevent"."session",
"auditing_storedauditevent"."referrer",
"auditing_storedauditevent"."request_hash",
"auditing_storedauditevent"."event_hash",
"auditing_storedauditevent"."process_celery",
"auditing_storedauditevent"."celery_task_name",
"auditing_storedauditevent"."original_html",
"auditing_storedauditevent"."context",
"auditing_storedauditevent"."affected_models",
"auditing_storedauditevent"."model_changed_pk",
"auditing_storedauditevent"."model_changed_table",
"auditing_storedauditevent"."is_ajax",
"auditing_storedauditevent"."is_fake",
"auditing_storedauditevent"."faked_reason",
"auditing_storedauditevent"."mongo_id",
"auditing_storedauditevent"."modified",
"auditing_storedauditevent"."created" 
FROM "auditing_storedauditevent" 
WHERE (
NOT ("auditing_storedauditevent"."context" IS NULL) 
AND "auditing_storedauditevent"."model_changed_table" = 'corporations_corporation'
AND "auditing_storedauditevent"."klass" = 'ModelChange'
AND "auditing_storedauditevent"."path" = '/corporations/icebox/'
AND "auditing_storedauditevent"."created" < '2017-04-20 07:29:04.258586');
\q
drop database eshares_dev;
\q
\dt
\list
drop database eshares_dev;
\q
\dt
\q
\list
drop database esahres_dev;
drop database esahres_dev;
\lsit
\list
dropdb eshares_dev;
dropdb 'eshares_dev'
;
\list
\q
\dt
\q
\list
create database esahres_dev2;
\list
select * from eshares_dev.corporations_corporation;
select * from corporations_corporation;
use eshares_devl
use eshares_dev;
\c eshares_dev;
\q
\q
ls
\list
drop database esahres_dev2;
drop database esahres_dev2;
\list
create database eshares_dev2;
\q
\list
drop database eshares_dev2;
\list
drop database eshares_dev;
SELECT 
    pg_terminate_backend(pid) 
FROM 
    pg_stat_activity 
WHERE 
    -- don't kill my own connection!
    pid <> pg_backend_pid()
    -- don't kill the connections to other databases
    AND datname = 'database_name'
    ;
REVOKE CONNECT ON DATABASE eshares_dev FROM PUBLIC, username;
REVOKE CONNECT ON DATABASE eshares_dev FROM PUBLIC, aj07mm;
REVOKE CONNECT ON DATABASE eshares_dev FROM PUBLIC, eshares;
drop database eshares_dev;
\q
GRANT CONNECT ON DATABASE eshares_dev FROM PUBLIC, eshares;
GRANT CONNECT ON DATABASE eshares_dev FROM PUBLIC, eshares;
\q
GRANT CONNECT TO eshares;
GRANT CONNECT TO eshares;
GRANT ALL TO eshares;
GRANT ALL TABLES IN SCHEMA eshares_dev TO eshares;
GRANT CONNECT
ON DATABASE eshares_dev 
TO eshares;
\q
drop database eshares_dev;
\list
\q
create database eshares_dev;
\q
dropdb eshares_dev
;
dropdb eshares_dev;
dropdb eshares_dev
createdb eshares_dev
\q
\d
\dt
\t
\list
drop database eshares_dev
;
\q
\df+
\q
select * from common_approver;
\d+
select * from django_migrations;
\q
drop database test_eshares_tests;
\q
\q
\dt
\d
\dt
\dt+
list
listdb
\q
\d table_name
\d auditing_sentemail
\q
q
\q
\d certificates_certificate
\q
\d certificates_certificate
\d certificates_certificate
select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS 
where DELETE_RULE ='CASCADE'
;
select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS where DELETE_RULE ='CASCADE'
select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS;
select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS where DELETE_RULE ='CASCADE'
select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS;
\d+ certificates_certificate
describe certificates_certificate
;
\d+ certificates_certificate
SELECT * FROM information_schema.referential_constraints;
SELECT * FROM information_schema.referential_constraints;
SELECT * FROM information_schema.referential_constraints where constraint_name like "%certificate%";
SELECT * FROM information_schema.referential_constraints where constraint_name like "%certificate%";
createdb -O eshares -E UTF8 -T template1 eshares_dev_audit
;
\q
\l
\q
q
\q
\q
\q
\q
\q
\q
\q
\q
\q
\q
\q
\q
\q
\list
\q