Untitled query #25955

Fork of Redirects hiding Commons files V2 - No more :( by KylieTastic

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

SQL

SELECT CONCAT ('File:',w.page_title) as page_title FROM enwiki_p.page w
INNER JOIN commonswiki_p.page c ON c.page_title = w.page_title
INNER JOIN enwiki_p.templatelinks tl ON tl.tl_from = w.page_id AND tl.tl_namespace = 10 AND tl.tl_title IN
  (
    'R_from_move'
  ) 
LEFT JOIN enwiki_p.templatelinks tx ON tx.tl_from = w.page_id AND tx.tl_namespace = 10 AND tx.tl_title IN
(
  'db-redircom'
)

WHERE w.page_namespace = 6 AND w.page_is_redirect = 1 AND c.page_namespace = 6 AND c.page_is_redirect = 0
AND tx.tl_from IS NULL

SQL

Checking query status...