USE zhwiki_p;

SELECT

rev_id, rev_timestamp,

/*page_id,*/ page_title, actor_name, comment_text, ug_group

FROM revision

LEFT JOIN page ON revision.rev_page = page.page_id

LEFT JOIN comment ON revision.rev_comment_id = comment.comment_id

LEFT JOIN actor ON rev_actor = actor_id

LEFT JOIN user ON actor_user = user_id

LEFT JOIN user_groups ON user_id = ug_user

WHERE

    revision.rev_timestamp > '20200301000000'

    AND page.page_namespace = 2

    AND page.page_title LIKE "Bluedecklibrary%"

ORDER BY revision.rev_timestamp DESC

;

​