Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
enWikiquote: #SheSaid tagged new articles (01-Oct-22 : 31-Dec-22)
by
Djm-leighpark
This query is marked as a draft
This query has been published
by
Djm-leighpark
.
Scratch query not checked
Toggle Highlighting
SQL
SELECT actor_name AS "Creator", count(*) "Count" FROM revision r JOIN page ON rev_page=page_id JOIN actor_revision ON rev_actor=actor_id LEFT JOIN page_props ON pp_page = page_id AND pp_propname = 'wikibase_item' WHERE rev_id in (SELECT rev_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 AND page_is_redirect = 0) GROUP BY rev_page HAVING MIN(rev_timestamp) >= 20221001000000) group by actor_name ORDER BY actor_name ASC;
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...