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

SQL

SELECT fap.page_title, GROUP_CONCAT(CONCAT ('[[',limagelist.il_to,'|150px]]> File:',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%'
 
 
 limit 30;

SQL

Checking query status...