Amostras de Categorias Vazias e com poucas páginas

SQL

SELECT CONCAT('Categoria:', cat_title) Categorias_vazias, CONCAT('Categoria:', cl_to) É_subcategoria_de
FROM category INNER JOIN page ON cat_title = page_title AND page_namespace = 14 INNER JOIN categorylinks ON page_id = cl_from
WHERE cat_pages = 0
 AND cat_title NOT IN (SELECT page_title FROM page INNER JOIN categorylinks ON cl_from = page_id AND cl_to = '!Redirecionamentos_de_categorias' WHERE page_namespace = 14)
 AND cat_title NOT LIKE '!%'
GROUP BY page_id ORDER BY RAND()
LIMIT 100;
SELECT CONCAT('Categoria:', cat_title) Categorias_com_1_página, CONCAT('Categoria:', cl_to) É_subcategoria_de
FROM category INNER JOIN page ON cat_title = page_title AND page_namespace = 14 INNER JOIN categorylinks ON page_id = cl_from
WHERE cat_pages = 1
 AND cat_title NOT IN (SELECT page_title FROM page INNER JOIN categorylinks ON cl_from = page_id AND cl_to = '!Redirecionamentos_de_categorias' WHERE page_namespace = 14)
 AND cat_title NOT LIKE '!%'
GROUP BY page_id ORDER BY RAND()
LIMIT 100;
SELECT CONCAT('Categoria:', cat_title) Categorias_com_2_págnas, CONCAT('Categoria:', cl_to) É_subcategoria_de
FROM category INNER JOIN page ON cat_title = page_title AND page_namespace = 14 INNER JOIN categorylinks ON page_id = cl_from
WHERE cat_pages = 2
 AND cat_title NOT IN (SELECT page_title FROM page INNER JOIN categorylinks ON cl_from = page_id AND cl_to = '!Redirecionamentos_de_categorias' WHERE page_namespace = 14)
 AND cat_title NOT LIKE '!%'
GROUP BY page_id ORDER BY RAND()
LIMIT 100;
SELECT CONCAT('Categoria:', cat_title) Categorias_com_3_págnas, CONCAT('Categoria:', cl_to) É_subcategoria_de
FROM category INNER JOIN page ON cat_title = page_title AND page_namespace = 14 INNER JOIN categorylinks ON page_id = cl_from
WHERE cat_pages = 3
 AND cat_title NOT IN (SELECT page_title FROM page INNER JOIN categorylinks ON cl_from = page_id AND cl_to = '!Redirecionamentos_de_categorias' WHERE page_namespace = 14)
 AND cat_title NOT LIKE '!%'
GROUP BY page_id ORDER BY RAND()
LIMIT 100;
SQL

Checking query status...
