Untitled query #17473

SQL

#Goal: Look for the 
#1) whether articles are marked as controversial,
#2) how many external references they have and 
#3) number of edits.

USE enwiki_p;

#Look for pages where cl_to is Law and cl_namespace = 0
SELECT page_title FROM page
JOIN categorylinks ON page_id = cl_from
WHERE cl_to = "Law"
AND page_namespace = 0
group by page_id 
ORDER BY RAND()
LIMIT 1000;

#Count external references as a proxy for how cited or reliable the article is.
#SELECT count(cl_to) page_title FROM external link table
#JOIN page WHERE page_id = cl_from
#GROUP BY page_id


#Look for whether template links is marked as "disputed" or "controversial" 
#SELECT count(tl_from) page_title FROM external link table
#JOIN page WHERE TL title = "disputed" or "controversial"
#GROUP BY page_id
SQL

Checking query status...
