wikidatawiki: pages with DeltaBot source code

SQL

# pages ending in "/Configuration"; indicating whether they transclude [[Template:DeltaBot_source]]
SELECT
  page_namespace,
  page_title,
  lt_namespace,
  lt_title
FROM
  templatelinks
    JOIN linktarget ON tl_target_id=lt_id AND lt_id=141827 # transcludes [[Template:DeltaBot_source]] (lt_id=141827)
    RIGHT JOIN page ON tl_from=page_id
WHERE
  page_namespace NOT IN (0, 120, 146)
  AND page_title LIKE '%/Configuration';

# pages transcluding subpages of [[User:DeltaBot/source]], usually via [[Template:DeltaBot_source]]
SELECT
  p1.page_namespace,
  p1.page_title,
  lt_namespace,
  lt_title,
  p2.page_content_model AS lt_content_model
FROM
  linktarget
    JOIN templatelinks ON tl_target_id=lt_id
      JOIN page AS p1 ON tl_from=p1.page_id
    JOIN page AS p2 ON lt_namespace=p2.page_namespace AND lt_title=p2.page_title
WHERE
  lt_namespace=2
  AND lt_title LIKE 'DeltaBot/source/%';
SQL

Checking query status...
