Páginas problemáticas do Wikisource em português

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

SQL

SELECT page_title
FROM 
  page 
  LEFT JOIN (
    SELECT 
      tl_from, 
      lt_title 
    FROM 
      templatelinks 
      LEFT JOIN linktarget ON linktarget.lt_id = templatelinks.tl_target_id 
    WHERE 
      tl_from_namespace = 0 
      AND (
        lt_title = 'Navegar' 
        OR lt_title = 'Header' 
        OR lt_title = 'Navegar-desc' 
        OR lt_title = 'Tradução_header' 
        OR lt_title = 'Translation_header'
      )
  ) AS links ON links.tl_from = page.page_id 
WHERE 
  page_namespace = 0 
  AND page_is_redirect = 0
  AND lt_title IS NULL
LIMIT 
  10;

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...