Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
#SheSaid on English Wikiquote from Oct 1st 2022 till 31 Dec
by
Anthere
This query is marked as a draft
This query has been published
by
Djm-leighpark
.
New #SheSaid WikiQuote 2022 campaign articles. on English WikiQuote from Oct 1st 2022 till 31 Dec 2022
Toggle Highlighting
SQL
SELECT page_title AS "Article", actor_name AS "Creator", rev_timestamp AS "Date created", rev_page FROM revision JOIN page ON rev_page=page_id JOIN actor_revision ON rev_actor=actor_id WHERE revision_id in (SELECT revision_id FROM revision WHERE rev_page in (SELECT rev_page FROM revision JOIN comment_revision ON rev_comment_id=comment_id JOIN page ON rev_page=page_id WHERE rev_timestamp BETWEEN 20221001000000 AND 20221231999999 AND comment_text RLIKE '.*#[Ss]he[Ss]aid.*' AND page_namespace = 0) GROUP BY rev_page HAVING MIN(rev_timestamp) >= 20221001000000 ) 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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...