Untitled query #76696

SQL

SELECT concat('u"module:',REPLACE(page_title,'_',' '),'",')
#SELECT concat('u"module:',REPLACE(page_title,'_',' '),'",')
FROM fawiki_p.page
WHERE page_namespace = 828
#WHERE page_namespace = 828

AND page_title IN (
  SELECT page_title
  FROM enwiki_p.page
  WHERE page_namespace = 828
  #WHERE page_namespace = 828
)

AND page_title NOT LIKE '%/doc'
AND page_title NOT LIKE '%/documnet'
AND page_title NOT LIKE '%/autodoc'
AND page_title NOT LIKE '%/sandbox'
AND page_title NOT LIKE '%/testcases'


AND page_id NOT IN (
  SELECT ll_from
  FROM arwiki_p.langlinks
  WHERE ll_lang = "en"
);
SQL

Checking query status...
