1 year >10 - Quarry

SQL

# #len of article (total - month - week - day before, same), page namespace
SELECT page.page_title, page.page_id, 
			page.page_len as page_len_today, 
            count(categorylinks.cl_to) categorylinks_today,
            min(revision.rev_timestamp) as created_at,
            count(revision.rev_id) as count_rev_today,
            sum(revision.rev_len) rev_len_today
FROM page
	LEFT JOIN categorylinks ON categorylinks.cl_from=page.page_id 
    LEFT JOIN revision on revision.rev_page = page.page_id # and revisions.rev_timestamp<=''
WHERE page_title ='Prime_Minister_of_Haiti'  
		and page_namespace=0
GROUP BY 1,2,3




# #age of the page
# SELECT MIN(rev_timestamp)
# FROM revision
# LIMIT 100;

# # number of edits 
# SELECT rev_page, rev_timestamp, rev_minor_edit, rel_len
# FROM revision
# LIMIT 100;

# # internal links 
# SELECT pl_from
# FROM pagelinks
# LIMIT 100;

# #number of external links 
# SELECT el_from
# FROM externallinks
# LIMIT 100;

 #'Marshall_Fire'????
SQL

Checking query status...
