Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
enWikiquote: Article creators (01-Oct-22 : 31-Dec-22)
by
Djm-leighpark
This query is marked as a draft
This query has been published
by
Djm-leighpark
.
This list is a list of #SheSaid 2022 contributors defined as people who have marked an edit contribution as #SheSaid or who created a new article in the period which is in the scope of #SheSaid. This includes a small number of articles that are up for deletion
Toggle Highlighting
SQL
SELECT actor_name, count(*) "#Created" 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 union all SELECT distinct actor_name, NULL FROM revision r JOIN page ON rev_page=page_id JOIN actor_revision ON rev_actor=actor_id JOIN comment_revision ON rev_comment_id=comment_id WHERE comment_text RLIKE '.*#[Ss]he[Ss]aid.*' AND rev_timestamp BETWEEN 20221001000000 AND 20221231999999 AND actor_name not in ( SELECT actor_name 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 1
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...