it.wiki navbox titles

SQL

SELECT page_title FROM
       page
  JOIN templatelinks ON page_id = tl_from
  JOIN linktarget on tl_target_id = lt_id
WHERE page_is_redirect = 0
  AND page_namespace = 10
  AND lt_namespace = 10
  AND lt_title IN ('Navbox', 'Template_di_navigazione')

UNION

SELECT page_title FROM
       page
  JOIN redirect ON page_id = rd_from
WHERE page_namespace = 10
  AND rd_title IN (
    SELECT page_title FROM
           page
      JOIN templatelinks ON page_id = tl_from
      JOIN linktarget on tl_target_id = lt_id
    WHERE page_is_redirect = 0
      AND page_namespace = 10
      AND lt_namespace = 10
      AND lt_title IN ('Navbox', 'Template_di_navigazione')
  )
SQL

Checking query status...
