Untitled query #35039

SQL

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

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

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

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

Checking query status...
