Untitled query #71180

SQL

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,
    el_to    
FROM (
  SELECT 
      rc_timestamp, 
      rc_user_text, 
      page_title,
      eu_entity_id, 
      eu_aspect, 
      eu_page_id, 
      rc_source, 
      rc_comment,
      el_to
  FROM 
      wbc_entity_usage, 
      page_props, 
      recentchanges_compat,
      user,
      page,
      externallinks
  WHERE 
      page_id=eu_page_id
      AND page_id=el_from
      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...
