Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Zache
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT * FROM ( SELECT rc_cur_id as rc_id, rc_title as page, tl_title as template, iwl_title as property, comment_text FROM recentchanges, templatelinks, page, iwlinks, comment_recentchanges WHERE rc_namespace=0 AND rc_cur_id = tl_from AND rc_source="wb" AND tl_title=page_title AND page_namespace=10 AND iwl_from=page_id AND iwl_prefix="d" AND iwl_title!="" AND rc_comment_id=comment_id AND comment_text LIKE concat("%", iwl_title, "%") LIMIT 25) AS t GROUP BY rc_id, page, template, comment_text;
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...