new cats last week which does not link to {{Maintenance_category}}

SQL

SELECT page_title
FROM categorylinks
LEFT JOIN page ON cl_from = page_id
WHERE page_namespace = 14
  AND page.page_touched >= NOW() - INTERVAL 7 DAY
  AND NOT EXISTS (
    SELECT 1
    FROM templatelinks
    JOIN page AS template_page ON tl_from = template_page.page_id
    JOIN revision AS template_revision ON template_page.page_latest = template_revision.rev_id
    WHERE tl_from = cl_from
      AND template_page.page_namespace = 10
      AND template_page.page_title = 'Maintenance_category'
  )
ORDER BY cl_timestamp DESC
LIMIT 50;

SQL

Checking query status...