Occupational Safety and Health – historical quality

SQL

SELECT 
	timestamp, 
    SUM(weighted_sum) AS weighed_sum,
    SUM(prediction = "Stub") AS stub_n,
    SUM(prediction = "Start") AS start_n,
    SUM(prediction = "C") AS c_n,
    SUM(prediction = "B") AS b_n,
    SUM(prediction = "GA") AS ga_n,
    SUM(prediction = "FA") AS fa_n
FROM templatelinks
INNER JOIN page AS talk ON 
	talk.page_id = tl_from AND
    talk.page_namespace = 1
INNER JOIN page AS article ON 
	article.page_namespace = 0 AND
    article.page_title = talk.page_title
INNER JOIN u2041__ores_p.monthly_wp10_enwiki AS wp10 ON
	wp10.page_id = article.page_id
WHERE 
	tl_namespace = 10 AND 
    tl_title = "WikiProject_Occupational_Safety_and_Health"
GROUP BY wp10.timestamp;

SQL

Checking query status...