Stubs by number of backlinks (cswiki)

SQL

USE cswiki_p;
SELECT page_title, COUNT(pl_from) FROM pagelinks
JOIN page ON page_namespace = pl_namespace AND page_title = pl_title
JOIN templatelinks ON tl_from = page_id
WHERE tl_title = 'Pahýl' AND tl_namespace = 10
AND page_namespace = 0
GROUP BY page_title
ORDER BY COUNT(pl_from) DESC
LIMIT 100;
/*
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...
