Wikipedie:Seznam rozcestníků

SQL

USE cswiki_p;
SELECT page_title, COUNT(*) AS links
FROM page
JOIN page_props ON pp_propname = 'disambiguation'
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)'
GROUP BY page_title
ORDER BY page_title;

SELECT page_title, COUNT(*) AS links
FROM page
JOIN page_props ON pp_propname = 'disambiguation'
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)'
GROUP BY page_title
ORDER BY page_title;
SQL

Checking query status...
