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

SQL

SELECT fap.page_title, CONCAT ('[[:en:',enp.page_title,']]') , CONCAT ('[[File:',limagelist.il_to,'|72px]]> 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%' 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 'Question_book%' and
 not limagelist.il_to like 'Folder_Hexagonal%' and
 not limagelist.il_to like 'Portal-puzzle%' and
 not limagelist.il_to like 'Edit-clear%' and
 not limagelist.il_to like 'Text_document_with_red_question_mark%' and
 not limagelist.il_to like 'PD-icon%' and
 not limagelist.il_to like '_icon%' and
 not limagelist.il_to like 'Symbol_book_class%' and
 not limagelist.il_to like 'Free_and_open-source_software_logo%' and
 not limagelist.il_to like 'Red_pog%' and
 not limagelist.il_to like 'Symbol_list_class%' and
 not limagelist.il_to like 'Allah-green%' and
 not limagelist.il_to like 'Symbol_support_vote%' and
 not limagelist.il_to like 'A_coloured_voting_box%' and
 not limagelist.il_to like 'Commons%'
 limit 5000;
SQL

Checking query status...
