Untitled query #79518

SQL

SELECT CONCAT('Kategorî:', page_title) AS full_page_title,
       langlinks.ll_title AS enwiki_sitelink_title
FROM categorylinks
JOIN page ON cl_from = page_id
JOIN langlinks ON page_id = langlinks.ll_from
LEFT JOIN page_props ON page.page_id = page_props.pp_page AND page_props.pp_propname = 'hiddencat'
WHERE page_namespace = 14
  AND page_props.pp_page IS NULL
  AND EXISTS (
    SELECT 1
    FROM langlinks
    WHERE ll_from = cl_from
      AND ll_lang = 'en'
  )
GROUP BY full_page_title, enwiki_sitelink_title
ORDER BY full_page_title;
SQL

Checking query status...
