User:Polomo47/Semi-automations by user Ungoliant Roman Numerals

Introduction

User:Ungoliant something something made over 29000 “semi-automated” entry creations. Some of them are pretty bad — especially the ones about Portuguese non-lemma forms. Below, the entries, queried using the following SQL:

SELECT DISTINCT page_title
FROM revision_userindex
JOIN page ON rev_page = page_id
JOIN actor_revision ON rev_actor = actor_id
JOIN comment ON rev_comment_id = comment_id
JOIN categorylinks ON page_id = cl_from
WHERE
    page_namespace = 0
    AND actor_name = "Ungoliant MMDCCLXIV"
    AND comment_text LIKE "%semi-automated%"
    AND cl_to IN ("Portuguese lemmas", "Portuguese_non-lemma_forms", "Portuguese_obsolete_terms", "Portuguese_obsolete_forms", "Portuguese_archaic_terms", "Portuguese_archaic_forms", "Portuguese_dated_terms", "Portuguese_dated_forms", "Portuguese_superseded_terms", "Portuguese_superseded_forms", "Portuguese_forms_superseded_in_1911", "Portuguese_forms_superseded_in_1943")

(with the selected categories altered accordingly)

User:Polomo47/Semi-automations by user Ungoliant Roman Numerals

Introduction

Obsolete, archaic, dated, superseded

1911 1943

Non-lemmas