# of villages containing bracket in the title (category based)

SQL

USE fawiki_p;
SELECT /*SLOW OK*/ CONCAT ( '# [[',page_title,']]')
FROM fawiki_p.page
where page_id IN (
        SELECT cl_from
        FROM langlinks INNER join page
        WHERE page_id IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation') and ll_lang = "en"
        )
        and page_title in (SELECT ll_title
        FROM enwiki_p.langlinks
        WHERE ll_lang = "fa" and
		ll_from not in (
		SELECT cl_from
		from enwiki_p.categorylinks
        where  cl_to ="All_disambiguation_pages")) and page_namespace=0 and page_is_redirect =0;
        
        
        AND page_id IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation')

SQL

Checking query status...