use lvwiki_p;

#http://tools.wmflabs.org/lists/itwiki/Disambigue/Disambigue_con_disambiguante_diverso_da_disambigua

SELECT CONCAT('# [[', page_title, ']]')

FROM page, page_props

WHERE pp_propname = 'disambiguation'

AND page_id = pp_page

AND page_namespace = 0

AND page_is_redirect = 0

AND page_title LIKE '%(%)'

AND page_title NOT LIKE '%(nozīmju_atdalīšana)'

ORDER BY page_title;

​

#http://tools.wmflabs.org/lists/itwiki/Disambigue/Disambigue_con_immagini

SELECT page_title

FROM page

WHERE page_namespace = 0

AND page_is_redirect = 0

AND page_id IN

(SELECT il_from

FROM imagelinks

WHERE il_to <> 'Disambig.svg')

AND page_id IN 

(SELECT pp_page

FROM page_props

WHERE pp_propname = 'disambiguation');

​

#http://tools.wmflabs.org/lists/itwiki/Disambigue/Disambigue_corte

SELECT CONCAT('# [[', page_title, ']] - ', page_len)

FROM page

WHERE page_id IN

(SELECT pp_page

FROM page_props

WHERE pp_propname = 'disambiguation')

ORDER BY page_len

LIMIT 1000;

​

#http://tools.wmflabs.org/lists/itwiki/Disambigue/Disambigue_lunghe

SELECT CONCAT('# [[', page_title, ']] - ', page_len)

FROM page

WHERE page_id IN

(SELECT pp_page

FROM page_props

WHERE pp_propname = 'disambiguation')

AND page_namespace = 0

ORDER BY page_len DESC

LIMIT 1000;

​

#http://tools.wmflabs.org/lists/itwiki/Disambigue/Redirect_che_puntano_a_disambigua

SELECT CONCAT('# [[', page_title, ']] -> [[', rd_title, ']] - ', COUNT(*)) 

FROM page JOIN redirect ON page_id = rd_from, pagelinks

WHERE page_namespace = 0 

AND rd_namespace = 0

AND rd_title IN

(SELECT page_title

FROM page

WHERE page_id IN

(SELECT pp_page

FROM page_props

WHERE pp_propname = 'disambiguation'))

AND page_title = pl_title

AND pl_from_namespace = 0

AND pl_namespace = 0

GROUP BY page_title

ORDER BY COUNT(*) DESC;

​

#http://tools.wmflabs.org/lists/itwiki/Disambigue/Voci_con_disambiguante_uguale_a_disambigua

SELECT CONCAT('# [[', page_title, ']]')

FROM page

WHERE page_namespace = 0

AND page_is_redirect = 0

AND page_title LIKE '%(nozīmju_atdalīšana)'

AND page_id NOT IN

(SELECT pp_page

FROM page_props

WHERE pp_propname = 'disambiguation')

ORDER BY page_title;