aismallard's junior staff page

The following SCUTTLE query:

SELECT
       page_id,
       FROM_UNIXTIME(CAST(metadata->'$.wikidot_metadata.timestamp' AS UNSIGNED))
           AS timestamp,
       metadata -> '$.wikidot_metadata.comments'
           AS comments
FROM revisions
WHERE wd_user_id = 4598089 -- aismallard
       AND revision_type = 'A' -- tags and reverts
       AND metadata -> '$.wikidot_metadata.comments' REGEXP
           'Added tags: .*(scp|tale|goi-format|001-proposal|hub|essay)' -- adding a primary page tag
GROUP BY page_id, metadata
ORDER BY timestamp;

Results in 216 pages tagged from 2018/11/20 to 2019/10/08. (This SCUTTLE dataset only has revisions up to 2019/10/10)

During the 5K posting period, a total of 57 entries were given tags (counted by hand, only counts those for which full tagging was done).