SQL
x
USE cswiki_p;
SELECT page_title, COUNT(pl_from) AS links
FROM page_props
JOIN page ON page_id = pp_page
LEFT JOIN pagelinks ON pl_namespace = page_namespace AND pl_title = page_title AND pl_from_namespace = 0
WHERE page_namespace = 0 AND page_title LIKE '%\_(rozcestník)' AND pp_propname = 'disambiguation'
GROUP BY page_title
ORDER BY page_title;
SELECT page_title, COUNT(pl_from) AS links
FROM page_props
JOIN page ON page_id = pp_page
LEFT JOIN pagelinks ON pl_namespace = page_namespace AND pl_title = page_title AND pl_from_namespace = 0
WHERE page_namespace = 0 AND page_title NOT LIKE '%\_(rozcestník)' AND pp_propname = 'disambiguation'
GROUP BY page_title
ORDER BY page_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.