Econ articles by recent edits, old views, and wikilinks

SQL

USE enwiki_p;
SELECT page_title, page_counter
FROM page AS p
JOIN categorylinks AS cl 
ON p.page_id = cl.cl_from 
WHERE cl.cl_to IN ("Economics", "Macroeconomics", "Welfare_economics", "Economic_growth", "Economy_of_the_United_States",
                   "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‎", "Economic_inequality_in_the_United States",
                   "Income_distribution", "Distribution_of_wealth", "Economic_efficiency", "Welfare_state", "Tax_incidence",
                   "Taxation_and_efficiency", "Tax_avoidance", "Corporate_inversions", "Offshore_finance")
AND cl.cl_type = "page"
AND p.page_namespace = 0
AND p.page_is_redirect = 0
GROUP BY page_title
ORDER BY page_counter;
SQL

Checking query status...
