SQL
AخA
SELECT
CONCAT('[[',REPLACE(page_title,'_',' '),']]') AS "New WikiQuote #SheSaid article",
actor_name AS "Creator",
CONCAT( MID(rev_timestamp,1,4),'-',MID(rev_timestamp,5,2),'-',MID(rev_timestamp,7,2),' ',
MID(rev_timestamp,9,2),':',MID(rev_timestamp,11,2),':',MID(rev_timestamp,13,2)) AS "Date created",
IF(ISNULL(pp_value),pp_value,CONCAT('[[:d:',pp_value,']]')) AS "Wikidata item"
FROM
revision
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)
ORDER BY page_title ASC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.