Untitled query #27528

SQL

#SELECT concat('* [[:پرونده:',page_title,']]')

SELECT page_id, page_title, page_restrictions, page_counter, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang
FROM commonswiki_p.page AS CMM
WHERE page_namespace = 6
AND CMM.page_is_redirect = 0
#AND page_title = "Avenger_TBM.jpg"

AND EXISTS (
  SELECT null
  FROM fawiki_p.page AS FWP
  WHERE page_namespace = 6
  AND CMM.page_title = FWP.page_title
  AND FWP.page_is_redirect = 0

#  AND CMM.page_len = FWP.page_len
)
LIMIT 100;
SQL

Checking query status...
