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
MGA73
.
Toggle Highlighting
SQL
SELECT DISTINCT CONCAT('# [[', page.page_title, ']]') AS output FROM revision JOIN comment ON revision.rev_comment_id = comment.comment_id JOIN page ON revision.rev_page = page.page_id WHERE revision.rev_timestamp >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY) AND revision.rev_timestamp < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 29 DAY) AND comment.comment_text LIKE '%Commenting out use(s) of file%' AND comment.comment_text NOT LIKE 'wb%' #SELECT DISTINCT CONCAT('# [[', page.page_title, ']]') AS output #FROM revision #JOIN comment ON revision.rev_comment_id = comment.comment_id #JOIN page ON revision.rev_page = page.page_id #WHERE revision.rev_timestamp >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY) #AND comment.comment_text LIKE '%Commenting out use(s) of file%' #AND comment.comment_text NOT LIKE 'wb%' #LIMIT 2
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...
