Amostras de Categorias Vazias e com poucas páginas

SQL

SELECT CONCAT('Categoria:', cat_title) Categorias_vazias, 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, 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
LIMIT 100;
SELECT CONCAT('Categoria:', cat_title) Categorias_com_2_págnas
FROM category INNER JOIN page ON cat_title = page_title AND page_namespace = 14
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 '!%'
LIMIT 100;
SELECT CONCAT('Categoria:', cat_title) Categorias_com_3_págnas
FROM category INNER JOIN page ON cat_title = page_title AND page_namespace = 14
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 '!%'
LIMIT 100;
SQL

Checking query status...
