#/mainspace nonredirects by shortdesc length

Fork of #/mainspace nonredirects by shortdesc length by Cryptic

This query is marked as a draft This query has been published by Qwerfjkl.

Number of mainspace, non-redirect pages with each short description length, combining 100+.

The length field is mislabelled; the number is the length in bytes, not characters.  This makes a difference for characters not represented in one byte in UTF-8 (é, for example, is one character but two bytes).

For [[WP:RAQ#Request for table showing the length of short descriptions in article space]] circa 24 June 2022.

SQL

SELECT 'N/A (no SD)' AS 'Length (in characters)',
       COUNT(*) AS 'Number of articles'
FROM page
LEFT JOIN page_props
  ON pp_page = page_id
 AND pp_propname = 'wikibase-shortdesc'
WHERE page_namespace = 0
  AND page_is_redirect = 0
  AND pp_page IS NULL

UNION

SELECT * FROM
(SELECT CASE WHEN LENGTH(pp_value) < 100 THEN LENGTH(pp_value) ELSE '100+' END AS len,
       COUNT(*)
 FROM page_props
 JOIN page
   ON page_id = pp_page
 WHERE pp_propname = 'wikibase-shortdesc'
   AND page_namespace = 0
   AND page_is_redirect = 0
 GROUP BY len
 ORDER BY CAST(len AS INT) ASC) q2;

SQL

Checking query status...