Wikipedie:Seznam rozcestníků

SQL

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;
SQL

Checking query status...
