Stubs by number of backlinks (cswiki)

SQL

USE cswiki_p;
SELECT linter_cat, COUNT(*), COUNT(DISTINCT linter_page) FROM linter GROUP BY linter_cat;
SELECT linter_cat, COUNT(*), COUNT(DISTINCT linter_page) FROM linter JOIN page ON page_id = linter_page
WHERE page_namespace IN (0, 10, 14) GROUP BY linter_cat;
/*
SELECT eu_entity_id, eu_aspect, COUNT(*) FROM wbc_entity_usage
WHERE eu_aspect <> 'S'
GROUP BY eu_entity_id, eu_aspect
HAVING COUNT(*) >= 50
ORDER BY COUNT(*) DESC;
*/
/*
SELECT page_namespace, page_title, eu_entity_id, eu_aspect
FROM wbc_entity_usage JOIN page ON page_id = eu_page_id
WHERE eu_aspect LIKE 'L.%' AND eu_aspect NOT IN ('L.cs', 'L.sk', 'L.en');
*/
SQL

Checking query status...
