WIP Infobox {power station,dam} transclusions in article space

SQL

SELECT
  ns_name,
  page_title,
  page_len,
  lt_title
FROM page
JOIN toolserver.namespace
ON dbname = 'enwiki_p'
AND ns_id = page_namespace
LEFT JOIN templatelinks
ON tl_from = page_id
AND page_namespace = 0
AND page_is_redirect = 0
LEFT JOIN linktarget ON tl_target_id = lt_id
WHERE tl_target_id IN (
  (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = "Infobox_power_station"),
  (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = "Infobox_dam")
) AND tl_from_namespace = 0
LIMIT 50;

SQL

Checking query status...