Edits by Qwerfjkl bot task 19 - Quarry

Fork of Edits by Qwerfjkl bot task 19 by Certes

This query is marked as a draft This query has been published by Qwerfjkl.

Edit summaries of "date formats per [[MOS:DATEFORMAT]] by [[WP:MOSNUMscript|script]]"

SQL

SELECT rev_id, page_title FROM revision_userindex
JOIN comment_revision ON comment_id=rev_comment_id AND comment_text LIKE "%([[Wikipedia:Bots/Requests for approval/Qwerfjkl (bot) 19|Task 19)]]%"
JOIN page ON page_id=rev_page
WHERE rev_actor=216586954 /* User:Qwerfjkl (bot) */ AND rev_parent_id != 0
ORDER BY rev_id

AخA
 
SELECT rev_id, page_title FROM revision_userindexJOIN comment_revision ON comment_id=rev_comment_id AND comment_text LIKE "%([[Wikipedia:Bots/Requests for approval/Qwerfjkl (bot) 19|Task 19)]]%"JOIN page ON page_id=rev_pageWHERE rev_actor=216586954 /* User:Qwerfjkl (bot) */ AND rev_parent_id != 0ORDER BY rev_id

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...