Untitled query #76139

SQL

-- Fetch full title and other details for pages with Armenian but no Azerbaijani translations
SELECT 
    CAST(rev_timestamp AS DATETIME) AS rev_timestamp,
    rev_id,
    REPLACE(IF(namespaces.name = '', page_title, CONCAT(namespaces.name, ':', page_title)), '_', ' ') AS full_page_title,
    page_namespace,
    page_title
FROM revision
LEFT JOIN page ON page.page_id = revision.rev_page
LEFT JOIN namespaces ON namespaces.id = page.page_namespace
WHERE page.page_namespace = 0
AND revision.rev_comment LIKE '%{{t+|hy|%}}%'
AND revision.rev_comment NOT LIKE '%{{t+|az|%}}%'
ORDER BY page.page_namespace, page.page_title;
SQL

Checking query status...
