wikidatawiki Alias equal to label

This query is marked as a draft This query has been published by Bdijkstra.

Query breakdown:
- inner 2 queries (t1 & t2): find recently changed items with labels and aliases and their languages
- middle query (t3): find items that use the same text in the same language as both its label and as an alias
- outer query: lookup the texts themselves and the language codes and group them by item ID

Takes ½-2 hours w/o recentchanges, and ½-1 hours with.

SQL

SELECT * FROM wbt_text LIMIT 1;
SELECT * FROM wbt_type;
SELECT * FROM wbt_text_in_lang WHERE wbxl_language='nl';
SELECT * FROM wbt_term_in_lang LIMIT 1;

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.

SQL

Checking query status...