SQL
AخA
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
COUNT(rev_id) AS edits,
ct_id as id,
ctd_id as ds,
ctd_name,
rev_id
FROM
change_tag_def
LEFT JOIN change_tag ON ct_id = ctd_id
JOIN revision ON rev_id = ct_rev_id
WHERE
ctd_name = 'twinkle'
GROUP BY
MONTH
LIMIT
5;
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.