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

​

  FROM fawiki_p.page as fap INNER JOIN fawiki_p.langlinks as fal ON

 fap.page_id = fal.ll_from and fap.page_namespace = 0 AND fap.page_is_redirect = 0 inner join fawiki_p.templatelinks as fat on fat.tl_namespace=10 and fat.tl_from=fap.page_id  and 

 (fat.tl_title like 'جعبه%' or fat.tl_title like 'Infobox%')

 inner join enwiki_p.page as enp on

fal.ll_title=enp.page_title and enp.page_namespace = 0 AND enp.page_is_redirect = 0  join (SELECT * FROM enwiki_p.imagelinks as eni) as limagelist WHERE

 fal.ll_lang = 'en'  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 '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 '%.svg' and

  not limagelist.il_to like '%.png' and

   not limagelist.il_to like '%.ogg' and

   not limagelist.il_to like '%.webm' and

 not limagelist.il_to like 'Commons%'

 group by limagelist.il_to order by fap.page_title;