Untitled query #86096

SQL

/* 
Missing items at Commons
2024-09-09: execution time: ca. 6000 seconds, results: ca. 800 rows
*/

SELECT
  page_id, page_title, eu_entity_id
FROM
  page_props,
  wbc_entity_usage,
  page
WHERE
  pp_propname = "unexpectedUnconnectedPage"
  AND NOT EXISTS (
    SELECT
      null
    FROM
      templatelinks,
      linktarget
    WHERE
      pp_page = tl_from
      AND tl_target_id = lt_id
      AND lt_namespace = 828
      AND lt_title <> "Core"
      AND lt_title <> "Description"
  )
  AND pp_page = eu_page_id
  AND eu_aspect = "S"
  AND page_id = pp_page
  AND page_namespace = 14
LIMIT 1
SQL

Checking query status...
