Enwiki Wikidata edits in last 30 days (summary)

SQL

-- Historical values 
-- date,users_with_editcount100,distinct_pages,distinct_wikidataitems,distinct_properties
-- Tue, 07 Feb 2023 17:35:58 UTC, 58,597,452,36
-- Tue, 14 Feb 2023 08:47:59 UTC, 60, 643, 499, 36
-- Wed, 22 Feb 2023 10:08:37 UTC, 66, 630, 604, 38 
-- Tue, 28 Feb 2023 08:23:44 UTC, 66, 1093, 1055, 40
-- Mon, 06 Mar 2023 05:47:52 UTC, 72, 1051, 1005, 41

SELECT 
	count(distinct(rc_user_text)) as users_with_editcount100,
	count(distinct(page_title)) as distinct_pages,    
	count(distinct(eu_entity_id)) as distinct_wikidataitems,
	count(distinct(eu_aspect)) as distinct_properties
FROM (
  SELECT 
      rc_timestamp, 
      rc_user_text, 
      page_title,
      eu_entity_id, 
      eu_aspect, 
      eu_page_id, 
      rc_source, 
      rc_comment 
  FROM 
      wbc_entity_usage, 
      page_props, 
      recentchanges_compat,
      user,
      page
  WHERE 
      page_id=eu_page_id
      AND rc_cur_id=pp_page 
      AND eu_entity_id=pp_value 
      AND pp_propname="wikibase_item" 
      AND rc_source="wb" 
      AND rc_comment NOT LIKE "%quicstatements%" 
      AND rc_user=user_id
      AND user_editcount>100
      AND (
        (eu_aspect LIKE "D.%" AND rc_comment LIKE CONCAT("%description%", replace(eu_aspect, "D.", "|"), "%")  ) 
        OR (eu_aspect like "L.%" AND rc_comment LIKE CONCAT("%label%", replace(eu_aspect, "L.", "|"), "%") ) 
        OR (rc_comment LIKE concat("%P", replace(eu_aspect, "C.P", ""), "%"))  
      ) 
) AS t
SQL

Checking query status...
