Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Fiwiki Wikidata edits in last 30 days (data)
by
Zache
This query is marked as a draft
This query has been published
by
Zache
.
wikidata edits by fiwiki users
Toggle Highlighting
SQL
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, page, templatelinks, linktarget WHERE page_id=eu_page_id AND page_id=tl_from AND tl_target_id = lt_id AND lt_namespace = 10 AND lt_title IN ("Museo_WD", "Perustiedot_Wikidatassa") 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 ( (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", ""), "%")) ) ORDER BY rc_timestamp DESC
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...