Untitled query #85965

SQL

SELECT
  COUNT(page_id) AS ct_all_categories
FROM
  page
WHERE
  page_namespace = 14
  AND page_is_redirect = 0
;

SELECT
  COUNT(*) as ct_unconnected_categories
FROM
  page,
  page_props
WHERE
  page_namespace = 14
  AND page_is_redirect = 0
  AND pp_page = page_id
  AND pp_propname = "unexpectedUnconnectedPage"
;

SELECT
  COUNT(page_props.pp_value) AS ct_connected_categories
FROM
  page_props
  JOIN page ON page_props.pp_page = page.page_id
WHERE
  page.page_namespace = 14
  AND page.page_is_redirect = 0
  AND page_props.pp_propname = 'wikibase_item'
;
SQL

Checking query status...
