Disambig reports [lvwiki]

SQL

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;

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 <> 'Disambigua_compass.svg'
AND il_to <> 'Wiktionary_small.svg'
AND il_to <> 'Nuvola_mimetypes_charnotfound.PNG')
AND page_id IN 
(SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation')
SQL

Checking query status...
