Untitled query #40615

SQL

USE commonswiki_p;

SELECT DISTINCT img_name
FROM externallinks
INNER JOIN page
  ON page_id = el_FROM
INNER JOIN image
  ON img_name = page_title
WHERE page_namespace = 6 AND
  (
    el_to LIKE 'http://youtube.com/watch%' OR
    el_to LIKE 'http://www.youtube.com/watch%' OR
    el_to LIKE 'http://m.youtube.com/watch%' OR
    el_to LIKE 'http://youtu.be/%' OR
    el_to LIKE 'https://youtube.com/watch%' OR
    el_to LIKE 'https://www.youtube.com/watch%' OR
    el_to LIKE 'https://m.youtube.com/watch%' OR
    el_to LIKE 'https://youtu.be/%'
  ) AND
  img_media_type IN ('AUDIO', 'VIDEO')
;

SELECT DISTINCT img_name
FROM externallinks
INNER JOIN page
  ON page_id = el_FROM
INNER JOIN image
  ON img_name = page_title
WHERE page_namespace = 6 AND
  (
    el_to LIKE 'http://youtube.com/watch%' OR
    el_to LIKE 'http://www.youtube.com/watch%' OR
    el_to LIKE 'http://m.youtube.com/watch%' OR
    el_to LIKE 'http://youtu.be/%' OR
    el_to LIKE 'https://youtube.com/watch%' OR
    el_to LIKE 'https://www.youtube.com/watch%' OR
    el_to LIKE 'https://m.youtube.com/watch%' OR
    el_to LIKE 'https://youtu.be/%'
  ) AND
  img_media_type IN ('AUDIO', 'VIDEO') AND
  img_name IN (
    SELECT gil_to
    FROM globalimagelinks
    WHERE gil_wiki != 'commonswiki'
    AND gil_page_namespace_id = 0
  )
;

SELECT DISTINCT img_name
FROM externallinks
INNER JOIN page
  ON page_id = el_FROM
INNER JOIN image
  ON img_name = page_title
WHERE page_namespace = 6 AND
  (
    el_to LIKE 'http://youtube.com/watch%' OR
    el_to LIKE 'http://www.youtube.com/watch%' OR
    el_to LIKE 'http://m.youtube.com/watch%' OR
    el_to LIKE 'http://youtu.be/%' OR
    el_to LIKE 'https://youtube.com/watch%' OR
    el_to LIKE 'https://www.youtube.com/watch%' OR
    el_to LIKE 'https://m.youtube.com/watch%' OR
    el_to LIKE 'https://youtu.be/%'
  ) AND
  img_media_type IN ('AUDIO', 'VIDEO') AND
  img_name IN (
    SELECT gil_to
    FROM globalimagelinks
    WHERE gil_wiki != 'commonswiki'
    AND gil_page_namespace_id = 0
  ) AND
  page_id IN (
    SELECT tl_from
    FROM templatelinks
    WHERE tl_namespace = 10
    AND tl_title IN ('Cc-by-layout', 'Cc-by-sa-layout')
  )
;
SQL

Checking query status...
