kuwiki cats without {{commonscat}}

SQL

SELECT 
  CONCAT(
    CASE WHEN page_namespace = 0 THEN '' ELSE 'Kategorî' END,
    ':',
    page_title
  ) AS full_page_title
FROM categorylinks
JOIN page ON cl_from = page_id
WHERE page_is_redirect = 0
  AND page_namespace = 14
  AND page_id NOT IN (
    SELECT tl_from FROM templatelinks JOIN linktarget ON tl_target_id = lt_id
    WHERE lt_namespace = 10
      AND lt_title IN (
        'Commonscat',
        'Otokat',
        'Kategorîkirin',
        'Ewkên ewk'
      )
  )
  AND EXISTS (
    SELECT 1
    FROM langlinks
    WHERE ll_from = cl_from
      AND ll_lang = 'en'
  )
GROUP BY page_title;
SQL

Checking query status...
