Untitled query #82019

SQL

SELECT 
    CASE 
        WHEN p1.page_namespace = 14 THEN CONCAT('Kategorî:', p1.page_title)
        ELSE p1.page_title
    END AS page_title
FROM 
    page p1
LEFT OUTER JOIN 
    categorylinks ON cl_from = p1.page_id
LEFT JOIN 
    page p2 ON cl_to = p2.page_title AND p2.page_namespace = 14
LEFT JOIN 
    page_props ON p2.page_id = pp_page AND pp_propname = 'hiddencat'
LEFT JOIN
    langlinks ON cl_from = langlinks.ll_from AND langlinks.ll_lang = 'en'
WHERE 
    (p1.page_namespace = 0)
    AND p1.page_is_redirect = 0
    AND p1.page_title NOT LIKE '%/%'
    AND p1.page_title NOT LIKE '!Serkategorî%'
    AND langlinks.ll_from IS NOT NULL -- Only consider pages with langlinks to English
    AND NOT EXISTS (
        SELECT 1 
        FROM categorylinks 
        WHERE cl_from = p1.page_id 
            AND cl_to = 'Hemû_rûpelên_bêkategorî'
    )
GROUP BY 
    p1.page_title
HAVING 
    COUNT(cl_from) - COUNT(pp_propname) = 0;
SQL

Checking query status...
