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;



USE enwiki_p;

#Look for pages where cl_to is Law and cl_namespace = 0
SELECT page_title, 
	count(el_to) 
FROM page JOIN categorylinks ON page_id = cl_from
JOIN externallinks ON page_id = el_from
JOIN templatelinks ON page_id = tl_from
WHERE cl_to = "Law"
AND tl_title LIKE "%disputed%"
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(el_to) page_title 
#FROM externallinks table
#JOIN page ON page_id = el_from
#GROUP BY page_id
#ORDER BY RAND()
#LIMIT 1000;


#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...
