Infobox_Settlement

SQL

USE arwiki_p;
SELECT DISTINCT page_title FROM page
JOIN templatelinks ON tl_from=page_id WHERE page_namespace=0 
and (page_title like "%(مدينة)" or page_title like "%مدينة")

and page_id in (SELECT tl_from
						FROM templatelinks
						WHERE tl_namespace = 10 and tl_from_namespace=0
						and tl_title in ("Infobox_Settlement") #("Infobox_Settlement","Infobox_officeholder")
  					)
                    
  GROUP BY page_title
  ORDER BY page_title DESC
  #imit 50;
  /*
USE arwiki_p;
SELECT DISTINCT page_title FROM page
JOIN templatelinks ON tl_from=page_id WHERE page_namespace=0 
and (page_title like "%(محافظة)" or page_title like "%محافظة")

and page_id in (SELECT tl_from
						FROM templatelinks
						WHERE tl_namespace = 10 and tl_from_namespace=0
						and tl_title in ("Infobox_Settlement") #("Infobox_Settlement","Infobox_officeholder")
  					)
                    
  GROUP BY page_title
  ORDER BY page_title DESC
  #imit 50;*/
SQL

Checking query status...
