Untitled query #35039

SQL

SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]')
FROM enwiki_p.page
WHERE page_namespace = 0
AND page_is_redirect = 0

# temp, to restrict results
AND page_title LIKE "%Gmina%"

# ||||||||||||||||||||||||||||||||||||||
# vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
# template has no fa interwiki
AND page_id NOT IN (
  SELECT ll_from
  FROM langlinks
  WHERE ll_lang = "fa"
)

AND NOT EXISTS (
  SELECT null
  FROM langlinks
  WHERE page_id = ll_from
  AND ll_lang = "fa"
)
# ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
# ||||||||||||||||||||||||||||||||||||||
SQL

Checking query status...
