Econ articles by recent edits, old views, and wikilinks

SQL

USE enwiki_p;
SELECT page_title as article, COUNT(rc.rc_id) as recent_edits, 
  page_counter as deprecated_pageviews -- ancient; see comment above
FROM page
JOIN categorylinks AS cats ON page.page_id = cats.cl_from 
LEFT JOIN recentchanges AS rc ON page.page_title = rc.rc_title
WHERE cl.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")
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;
SQL

Checking query status...
