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

SQL

SELECT page_title
FROM categorylinks
JOIN page ON cl_from = page_id
LEFT JOIN (
  SELECT rev_page, MIN(rev_timestamp) AS first_revision_timestamp
  FROM revision
  GROUP BY rev_page
) AS first_revision ON page_id = first_revision.rev_page
WHERE page_namespace = 14
  AND page.page_touched >= NOW() - INTERVAL 30 DAY
  AND first_revision.first_revision_timestamp >= NOW() - INTERVAL 30 DAY
  AND pp_propname !='hiddencat'
  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'
  )
  AND NOT EXISTS (
    SELECT 1
    FROM templatelinks
    JOIN linktarget ON lt_id = tl_target_id
    WHERE tl_from = cl_from
      AND linktarget.lt_namespace = 10
      AND linktarget.lt_title = 'Maintenance_category'
  )
GROUP BY page_title
ORDER BY MAX(cl_timestamp) DESC
SQL

Checking query status...
