Pages on fawiki with more than 25 interwiki links

This query is marked as a draft This query has been published by Huji.
SQL

use fawiki_p;
SELECT
  fap.page_title,
  enp.page_title,
  limagelist.il_to,
  limagelist.il_to
FROM fawiki_p.page AS fap
JOIN fawiki_p.langlinks AS fal
  ON fap.page_id = fal.ll_from
  AND fap.page_namespace = 0
  AND fap.page_is_redirect = 0
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%'
  )
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
  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
    WHERE
      NOT fai.il_to LIKE 'Flag_of_%'
      AND NOT fai.il_to LIKE 'Ambox_%'
      AND NOT fai.il_to LIKE 'Wiktionary%'
      AND NOT fai.il_to LIKE 'Wikibooks%'
      AND NOT fai.il_to LIKE 'Wikivoyage%'
      AND NOT fai.il_to LIKE 'Incubator%'
      AND NOT fai.il_to LIKE 'Searchtool%'
      AND NOT fai.il_to LIKE 'Speech_balloon%'
      AND NOT fai.il_to LIKE 'Crystal_Clear%'
      AND NOT fai.il_to LIKE 'Speakerlink%'
      AND NOT fai.il_to LIKE 'Loudspeaker%'
      AND NOT fai.il_to LIKE 'Padlock%'
      AND NOT fai.il_to LIKE 'Nuvola_apps_%'
      AND NOT fai.il_to LIKE 'Wikiquote%'
      AND NOT fai.il_to LIKE 'Wikisource%'
      AND NOT fai.il_to LIKE 'Wikinews%'
      AND NOT fai.il_to LIKE 'Wikiversity%'
      AND NOT fai.il_to LIKE 'Question_book%'
      AND NOT fai.il_to LIKE 'Folder_Hexagonal%'
      AND NOT fai.il_to LIKE 'Portal-puzzle%'
      AND NOT fai.il_to LIKE 'Edit-clear%'
      AND NOT fai.il_to LIKE 'Text_document_with_red_question_mark%'
      AND NOT fai.il_to LIKE '%_stub%'
      AND NOT fai.il_to LIKE 'Rod_of_Asclepius%'
      AND NOT fai.il_to LIKE 'Merge-arrows%'
      AND NOT fai.il_to LIKE '%_icon%'
      AND NOT fai.il_to LIKE '%Balloon%'
      AND NOT fai.il_to LIKE 'Mergefrom%'
      AND NOT fai.il_to LIKE 'WikiProject%'
      AND NOT fai.il_to LIKE 'Yes_check%'
      AND NOT fai.il_to LIKE 'X_mark%'
      AND NOT fai.il_to LIKE 'Blank%'
      AND NOT fai.il_to LIKE '%_Icon%'
      AND NOT fai.il_to LIKE 'Symbol_book_class%'
      AND NOT fai.il_to LIKE 'Free_and_open-source_software_logo%'
      AND NOT fai.il_to LIKE 'Red_pog%'
      AND NOT fai.il_to LIKE 'Symbol_list_class%'
      AND NOT fai.il_to LIKE 'Allah-green%'
      AND NOT fai.il_to LIKE 'Symbol_support_vote%'
      AND NOT fai.il_to LIKE 'A_coloured_voting_box%'
      AND NOT fai.il_to LIKE 'Wiki_letter_w_cropped%'
      AND NOT fai.il_to LIKE '%.wav'
      AND NOT fai.il_to LIKE '%.mid'
      AND NOT fai.il_to LIKE '%.ogg'
      AND NOT fai.il_to LIKE '%.ogv'
      AND NOT fai.il_to LIKE '%.webm'
      AND NOT fai.il_to LIKE 'Commons%'
  )
  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 '%.ogv'
  AND NOT limagelist.il_to LIKE '%.wav'
  AND NOT limagelist.il_to LIKE '%.mid'
  AND NOT limagelist.il_to LIKE 'Commons%'
GROUP BY limagelist.il_to
ORDER BY fap.page_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
