Untitled query #88419

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_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", "Portuguese_forms_superseded_in_1945", "Portuguese_forms_superseded_in_1971", "Portuguese_forms_superseded_in_1973", "Portuguese_forms_superseded_by_AO1990", "Brazilian_Portuguese_forms_superseded_by_AO1990", "European_Portuguese_forms_superseded_by_AO1990")
SQL

Checking query status...
