Pages that could benefit from T44783

This query is marked as a draft This query has been published by Lucas Werkmeister (WMDE).

T44783 proposes to optimize change dispatching by not re-rendering the wikitext when only the sitelinks were changed. If I understand correctly, this would affect all pages with a “sitelink” usage (displaying the sitelinks) but without “other” usage (sitelinks accessed by Lua ⇒ requires re-rendering). This query counts how many pages could benefit from this optimization.

SQL

USE `ptwiki_p`;

SELECT COUNT(*) AS "could benefit"
FROM wbc_entity_usage
WHERE eu_aspect = 'S'
AND eu_page_id NOT IN (
  SELECT DISTINCT eu_page_id
  FROM wbc_entity_usage
  WHERE eu_aspect = 'O'
);

SELECT COUNT(DISTINCT eu_page_id) AS "total"
FROM wbc_entity_usage;

SELECT NOW() AS "as of";

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