Fiwiki Wikidata edits in last 30 days (data)

SQL

SELECT 
	rc_timestamp, 
    rc_user_text, 
    eu_entity_id, 
    eu_aspect, 
    eu_page_id, 
    rc_source, 
    rc_comment 
FROM 
	wbc_entity_usage, 
    page_props, 
    recentchanges_compat,
    user
WHERE 
	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>10
    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", ""), "%"))  
    )
SQL

Checking query status...
