User:EllenCT

From MediaWiki.org
Jump to navigation Jump to search

I am from en:User:EllenCT.

I wrote http://quarry.wmflabs.org/query/1337

USE enwiki_p;
SELECT page_title as article, COUNT(DISTINCT rc.rc_id) as recent_edits, 
 page_counter as deprecated_pageviews, -- ancient; see comment above
 COUNT(DISTINCT pl.pl_from) as inbound_wikilinks
FROM page
JOIN categorylinks AS cats ON page.page_id = cats.cl_from 
JOIN recentchanges AS rc ON page.page_title = rc.rc_title
JOIN pagelinks AS pl ON page.page_title = pl.pl_title
 AND pl.pl_namespace = 0 -- careful: query won't terminate without this; wtf!
WHERE cats.cl_to IN ("Economics", "Macroeconomics", "Welfare_economics",
 "Economic_growth", "Economy_of_the_United_States", "Economic_efficiency", 
 "Organisation_for_Economic_Co-operation_and_Development_member_economies",
 "Politics_of_the_United_States", "Campaign_finance_in_the_United_States",
 "Campaign_finance_reform_in_the_United_States", "Taxation_and_redistribution",
 "Economic_inequality", "Unemployment", "Income_distribution", "Tax_incidence",
 "Economic_inequality_in_the_United States", "Distribution_of_wealth", 
 "Corporate_inversions", "Offshore_finance", "Taxation_in_the_United_States",
 "Corporate_taxation_in_the_United_States", "Tax_reform_in_the_United_States",
 "United_States_federal_income_tax", "United_States_tax_law", "Tax_avoidance", 
 "United_States_taxation_and_revenue_case_law", "Taxation_and_efficiency", 
 "United_States_federal_taxation_legislation", "Welfare_state",
 "Local_taxation_in_the_United_States", "State_taxation_in_the_United_States",
 "United_States_proposed_federal_taxation_legislation", "Monetary_policy",
 "New_Keynesian_economics", "Keynesian_economics", "Business_cycle",
 "Business_cycle_theory", "International_taxation", "Economic_policy", 
 "United_States_economic_policy", "Macroeconomic_policy", "Public_economics",
 "Bank_regulation", "Bank_regulation_in_the_United_States", "Taxation",
 "Economic_stimulus_programs", "Health_economics", "Income_distribution",
 -- "Demographics", "Poverty", -- these two don't really help find what I want
 "Basic_income", "Demographic_economics", "Tax_reform", "Public_policy")
AND cats.cl_type = "page"
AND page.page_namespace = 0 AND page.page_is_redirect = 0
AND rc.rc_namespace = 0 AND rc.rc_bot = 0 AND rc.rc_minor = 0
GROUP BY article;