Table templates by usage

This query is marked as a draft This query has been published by Isaac (WMF).

Likely table templates sorted by usage in articles.

SQL

WITH possible_table_templates AS (
  SELECT
    lt_id,
    lt_title
  FROM linktarget
  WHERE
    LOWER(lt_title) LIKE "%table%"  # Case insensitive: template name contains the word 'table'
    AND lt_namespace = 10  # Template namespace
)
SELECT
  lt_title,
  COUNT(tl_from) AS num_links
FROM templatelinks tl
INNER JOIN possible_table_templates tt
  ON (tl.tl_target_id = tt.lt_id)
WHERE
  tl_from_namespace = 0  # linked to from article
GROUP BY
  lt_title
ORDER BY
  num_links DESC

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