Main pl.wiki query 2

SQL

#RESULTSET_10
SELECT CONCAT('# [[:Kategoria:',cl_to,'|Kategoria:',cl_to,']]') AS cl_to, COUNT(*) AS count_cl_to
FROM page, categorylinks
WHERE page_id = cl_from
AND page_namespace = 0
AND NOT EXISTS
(SELECT * FROM page AS p1
WHERE cl_to = p1.page_title
AND p1.page_namespace = 14)
GROUP BY cl_to
ORDER BY count_cl_to DESC, cl_to ASC;
SELECT CONCAT('# [[',page_title,']]') as page_title
FROM page
LEFT JOIN categorylinks
ON cl_from = page_id
WHERE cl_from IS NULL
AND page_namespace = 0
AND page_is_redirect = 0;
SELECT CONCAT('# [[',p1.page_title,']]') 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'
WHERE p1.page_namespace = 0
AND p1.page_is_redirect = 0
AND p1.page_title NOT LIKE '%/%'
AND p1.page_title NOT LIKE 'Lista_planetoid%'
GROUP BY p1.page_title
HAVING COUNT(cl_from)-COUNT(pp_propname) = 0;
SQL

Checking query status...
