Skip to content

Instantly share code, notes, and snippets.

@jsfenfen
Created August 25, 2016 19:41
Show Gist options
  • Save jsfenfen/3c4ae40fccc0d30c4bdb1f3a05d98558 to your computer and use it in GitHub Desktop.
Save jsfenfen/3c4ae40fccc0d30c4bdb1f3a05d98558 to your computer and use it in GitHub Desktop.
SELECT ••• FROM "core_candidate" INNER JOIN "core_person" ON ("core_candidate"."person_ptr_id" = "core_person"."person_id") WHERE "core_person"."fec_id" = 'S8NY00082'
4.42025803649%
104.12
+
SELECT ••• FROM "core_candidate" INNER JOIN "core_person" ON ("core_candidate"."person_ptr_id" = "core_person"."person_id") WHERE "core_candidate"."fec_candidate_id" = 'S8NY00082'
4.09909409277%
96.55
+
SELECT ••• FROM "crpdata_crp_candidate" WHERE "crpdata_crp_candidate"."id" = 2108
4.07429496067%
95.97
+
SELECT ••• FROM "images_candidatesocial" WHERE "images_candidatesocial"."fec_id" = 'S8NY00082'
4.12825584769%
97.24
+
SELECT ••• FROM "fec_candidate_master" WHERE "fec_candidate_master"."cand_id" = 'S8NY00082'
Duplicated 5 times.
4.13169735989%
97.32
+
SELECT ••• FROM "core_campaign" INNER JOIN "core_campaign_candidate_in_campaign" ON ("core_campaign"."campaign_id" = "core_campaign_candidate_in_campaign"."campaign_id") WHERE "core_campaign_candidate_in_campaign"."candidate_id" = 2289
4.05458724223%
95.50
+
SELECT ••• FROM "fec_committee_master" INNER JOIN "core_campaign_inside_groups" ON ("fec_committee_master"."cmte_id" = "core_campaign_inside_groups"."fec_committee_id") WHERE "core_campaign_inside_groups"."campaign_id" = 9126 ORDER BY "fec_committee_master"."cmte_nm" ASC
4.00602143171%
94.36
+
SELECT ••• FROM "fec_committee_master" INNER JOIN "core_campaign_outside_groups" ON ("fec_committee_master"."cmte_id" = "core_campaign_outside_groups"."fec_committee_id") WHERE "core_campaign_outside_groups"."campaign_id" = 9126 ORDER BY "fec_committee_master"."cmte_nm" ASC
4.05400016074%
95.49
+
SELECT ••• FROM "fec_committee_master" INNER JOIN "core_campaign_opposition_groups" ON ("fec_committee_master"."cmte_id" = "core_campaign_opposition_groups"."fec_committee_id") WHERE "core_campaign_opposition_groups"."campaign_id" = 9126 ORDER BY "fec_committee_master"."cmte_nm" ASC
4.06402103452%
95.73
+
SELECT ••• FROM "core_politicalrace" INNER JOIN "core_politicalrace_entrant" ON ("core_politicalrace"."id" = "core_politicalrace_entrant"."politicalrace_id") WHERE "core_politicalrace_entrant"."campaign_id" = 9126
4.04890874709%
95.37
+
SELECT ••• FROM "core_campaign" INNER JOIN "core_politicalrace_entrant" ON ("core_campaign"."campaign_id" = "core_politicalrace_entrant"."campaign_id") WHERE ("core_politicalrace_entrant"."politicalrace_id" = 972 AND "core_campaign"."is_frontrunner" = true)
3.9835706256%
93.83
+
SELECT ••• FROM "core_candidate" INNER JOIN "core_campaign_candidate_in_campaign" ON ("core_candidate"."person_ptr_id" = "core_campaign_candidate_in_campaign"."candidate_id") INNER JOIN "core_person" ON ("core_candidate"."person_ptr_id" = "core_person"."person_id") WHERE "core_campaign_candidate_in_campaign"."campaign_id" = 9117
Duplicated 4 times.
4.02138677152%
94.72
+
SELECT ••• FROM "fec_candidate_master" WHERE "fec_candidate_master"."cand_id" = 'S2NY00259'
Duplicated 5 times.
4.07484155379%
95.98
+
SELECT ••• FROM "core_candidate" INNER JOIN "core_campaign_candidate_in_campaign" ON ("core_candidate"."person_ptr_id" = "core_campaign_candidate_in_campaign"."candidate_id") INNER JOIN "core_person" ON ("core_candidate"."person_ptr_id" = "core_person"."person_id") WHERE "core_campaign_candidate_in_campaign"."campaign_id" = 9120
Duplicated 4 times.
4.09997471501%
96.57
+
SELECT ••• FROM "fec_candidate_master" WHERE "fec_candidate_master"."cand_id" = 'S6NY00383'
Duplicated 5 times.
4.04359464736%
95.24
+
SELECT ••• FROM "core_candidate" INNER JOIN "core_campaign_candidate_in_campaign" ON ("core_candidate"."person_ptr_id" = "core_campaign_candidate_in_campaign"."candidate_id") INNER JOIN "core_person" ON ("core_candidate"."person_ptr_id" = "core_person"."person_id") WHERE "core_campaign_candidate_in_campaign"."campaign_id" = 9125
Duplicated 4 times.
4.33079896325%
102.01
+
SELECT ••• FROM "fec_candidate_master" WHERE "fec_candidate_master"."cand_id" = 'S6NY00433'
Duplicated 5 times.
4.19193394564%
98.74
+
SELECT ••• FROM "core_candidate" INNER JOIN "core_campaign_candidate_in_campaign" ON ("core_candidate"."person_ptr_id" = "core_campaign_candidate_in_campaign"."candidate_id") INNER JOIN "core_person" ON ("core_candidate"."person_ptr_id" = "core_person"."person_id") WHERE "core_campaign_candidate_in_campaign"."campaign_id" = 9126
Duplicated 4 times.
4.02012150967%
94.69
+
SELECT ••• FROM "fec_candidate_master" WHERE "fec_candidate_master"."cand_id" = 'S8NY00082'
Duplicated 5 times.
4.16416903979%
98.08
+
SELECT ••• FROM "fecdata_fec_periodic_report" WHERE "fecdata_fec_periodic_report"."com_id" = 'C00346312' LIMIT 1
4.10711079179%
96.74
+
SELECT ••• FROM "fecdata_fec_periodic_report" WHERE "fecdata_fec_periodic_report"."com_id" = 'C00346312'
4.56456874107%
107.52
+
SELECT ••• FROM "fecdata_fec_periodic_report" WHERE "fecdata_fec_periodic_report"."com_id" = 'C00346312'
4.40705882496%
103.81
+
SELECT ••• FROM "fecdata_fec_periodic_report" WHERE "fecdata_fec_periodic_report"."com_id" = 'C00346312'
4.41661408238%
104.03
+
SELECT ••• FROM "fecdata_fec_periodic_report" WHERE "fecdata_fec_periodic_report"."com_id" = 'C00346312'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment