kuwiki: sitelinks to enwiki for cats created in the last 30 days

SQL

SELECT
  CONCAT('Kategorî:', page_title) AS full_page_title,
  langlinks.ll_title AS enwiki_sitelink
FROM
  categorylinks
JOIN
  page ON cl_from = page_id
LEFT JOIN
  page_props ON page.page_id = page_props.pp_page AND page_props.pp_propname = 'hiddencat'
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
LEFT JOIN
  pagelinks ON page_id = pagelinks.pl_from
INNER JOIN  -- Change LEFT JOIN to INNER JOIN
  langlinks ON cl_from = langlinks.ll_from AND langlinks.ll_lang = 'en'
WHERE
  page_namespace = 14
  AND page.page_touched >= NOW() - INTERVAL 30 DAY
  AND first_revision.first_revision_timestamp >= NOW() - INTERVAL 30 DAY
  AND page_props.pp_page IS NULL
  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 = 'Kategoriya_çavdêriyê'
  )
  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 = 'Kategoriya_çavdêriyê'
  )
GROUP BY
  page_title, enwiki_sitelink
ORDER BY
  MAX(cl_timestamp) DESC;
SQL

Checking query status...
