[itvoy] pagine con wikilink alle disambigue

Fork of [itvoy] pagine con wikilink alle disambigue by Andyrom75

This query is marked as a draft This query has been published by Estopedist1.

SQL

USE etwiki_p;
SELECT CONCAT('# [[', page_namespace,':',page_title, ']] (', COUNT(*), ')')
FROM pagelinks, page
WHERE pl_from = page_id
AND page_is_redirect = 0
AND pl_title IN
(SELECT page_title
FROM page, page_props
WHERE pp_propname = 'disambiguation'
AND page_id = pp_page
AND page_is_redirect = 0)
AND pl_from IN
(SELECT page_id
FROM page)
AND page_id NOT IN
(SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation')
GROUP BY page_title
HAVING COUNT(*) >= 2
ORDER BY COUNT(*) DESC
LIMIT 50;

SQL

Checking query status...