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 text on text.old_id = revision.rev_text_id
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 text.old_text LIKE '%{{t+|hy|%}}%'
AND text.old_text NOT LIKE '%{{t+|az|%}}%'
order by page.page_namespace, page.page_title;
SQL

Checking query status...
