Most common properties used on Lexemes

The properties used most commonly on Lexemes, anywhere on the page. (Strictly speaking, this includes properties used as the values of statements for property-type properties, but that should be exceedingly rare.)

SQL

USE `wikidatawiki_p`;

SELECT `property_id`, `wbx_text` AS `property_label`, `count`
FROM (
  SELECT `pl_title` AS `property_id`, COUNT(DISTINCT `pl_from`) AS `count`
  FROM `pagelinks`
  WHERE `pl_from_namespace` = 146 -- Lexeme:
  AND `pl_namespace` = 120 -- Property:
  GROUP BY `pl_title`
) AS `properties`
JOIN `wbt_property_terms` ON SUBSTRING(`property_id`, 2) = `wbpt_property_id`
JOIN `wbt_term_in_lang` ON `wbpt_term_in_lang_id` = `wbtl_id`
JOIN `wbt_text_in_lang` ON `wbtl_text_in_lang_id` = `wbxl_id`
JOIN `wbt_text` ON `wbxl_text_id` = `wbx_id`
WHERE `wbtl_type_id` = (
  SELECT `wby_id` FROM `wbt_type` WHERE `wby_name` = "label"
)
AND `wbxl_language` = "en"
ORDER BY `count` DESC;

SQL

Checking query status...