SQL
AخA
use ptwiki_p;
SELECT right(left(rev_timestamp,6),2) as MES, rev_pagename as artigo, rev_timestamp
FROM revision
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
AND rev_parent_id = 0
and rev_timestamp BETWEEN 20010101000000 AND 20011231000000
AND page.page_is_redirect = 0
group by MES
ORDER BY rev_timestamp desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.