Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Amorymeltzer
.
Toggle Highlighting
SQL
SELECT /*SUBSTR(rev_timestamp, 1, 6) AS MONTH, COUNT(rev_id) AS edits*/ rev_id, rev_timestamp, comment_text /*ct_tag_id, ctd_id, ctd_name*/ FROM change_tag /* LEFT JOIN change_tag_def ON ct_tag_id = ctd_id*/ JOIN revision ON rev_id = ct_rev_id JOIN page ON page_id = rev_page LEFT JOIN comment_logging ON rev_comment_id = comment_id WHERE page_namespace = 0 /*ctd_name = 'twinkle'*/ AND ct_tag_id = '583' AND comment_text RLIKE "Added \{\{" /*search comments, limit namespace, etc.*/ /*GROUP BY MONTH*/ ORDER BY rev_timestamp DESC 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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...