Untitled query #10787

SQL

SELECT CONCAT ('[[',urp.page_title,']]'), CONCAT ('[[:en:',enp.page_title,']]') , CONCAT ('[[File:',limagelist.il_to,'|72px]]> File:',limagelist.il_to)

  FROM urwiki_p.page as urp INNER JOIN urwiki_p.langlinks as url ON
 urp.page_id = url.ll_from inner join enwiki_p.page as enp on
url.ll_title=enp.page_title join (SELECT * FROM enwiki_p.imagelinks as eni) as limagelist WHERE

 urp.page_namespace = 0  and url.ll_lang = 'en' AND urp.page_is_redirect = 0 and
 urp.page_id not in (SELECT uri.il_from FROM urwiki_p.imagelinks as uri) 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 'Wikivoyage%' and
 not limagelist.il_to like 'Incubator%' and
 not limagelist.il_to like 'Searchtool%' and
 not limagelist.il_to like 'Speech_balloon%' and
 not limagelist.il_to like 'Crystal_Clear%' and
 not limagelist.il_to like 'Speakerlink%' and
 not limagelist.il_to like 'Loudspeaker%' and
 not limagelist.il_to like 'Padlock%' and
 not limagelist.il_to like 'Nuvola_apps_%' 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 '%_stub%' and
 not limagelist.il_to like 'Rod_of_Asclepius%' and
 not limagelist.il_to like 'Merge-arrows%' and
 not limagelist.il_to like '%_icon%' and
 not limagelist.il_to like '%Balloon%' and
 not limagelist.il_to like 'Mergefrom%' and
 not limagelist.il_to like 'WikiProject%' and
 not limagelist.il_to like 'Yes_check%' and
 not limagelist.il_to like 'X_mark%' and
 not limagelist.il_to like 'Blank%' 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 'Wiki_letter_w_cropped%' and
 not limagelist.il_to like 'Commons%'
 limit 5000;
SQL

Checking query status...
