Special:Log/create + categories for mainspace nonredirs

The 100 most recent entries in [[Special:Log/create]], limited to still-existing pages that are currently in mainspace and not redirects, augmented with their current categories and page length.

For [[Wikipedia talk:Arbitration Committee/Requests for comment/Article creation at scale#Question 2: New creations report]] circa 7 September 2022.

SQL

SELECT log_timestamp,
       actor_name,
       page_title,
       CONCAT('[[:Category:', GROUP_CONCAT(cl_to SEPARATOR ']] [[:Category:'), ']]') AS `categories`
FROM (SELECT log_timestamp, actor_name, page_title, log_page
      FROM logging
      LEFT JOIN actor_logging ON actor_id = log_actor
      JOIN page ON page_id = log_page
      WHERE log_type = 'create'
        AND page_namespace = 0
        AND page_is_redirect = 0
      ORDER BY log_id DESC
      LIMIT 150) sq
LEFT JOIN categorylinks ON cl_from = log_page
GROUP BY log_timestamp, actor_name, page_title;

SQL

Checking query status...