مقالات نیازمند پرونده همسنگ

SQL

SELECT fap.page_title,limagelist.il_to
  FROM fawiki_p.page as fap INNER JOIN fawiki_p.langlinks as fal ON
 fap.page_id = fal.ll_from inner join enwiki_p.page as enp on
fal.ll_title=enp.page_title join (SELECT * FROM enwiki_p.imagelinks as eni) as limagelist WHERE

 fap.page_namespace = 0  and fal.ll_lang = 'en' AND fap.page_is_redirect = 0 and
 fap.page_id not in (SELECT fai.il_from FROM fawiki_p.imagelinks as fai) and  enp.page_id=limagelist.il_from  and
 not limagelist.il_to like 'Flag_of_%' and
 not limagelist.il_to like 'Ambox_%' and
 not limagelist.il_to like 'Wiktionary%' and
 not limagelist.il_to like 'Wikibooks%' and
 not limagelist.il_to like 'Wikiquote%' and
 not limagelist.il_to like 'Wikisource%' and
 not limagelist.il_to like 'Wikinews%' and
 not limagelist.il_to like 'Wikiversity%' and
 not limagelist.il_to like 'Commons%'
 limit 1000;
SQL

Checking query status...
