Diff in capital letters in wiki vs wikt articles on en wiki

Fork of Diff in capital letters in wiki vs wikt articles on cs wiki by Wesalius

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

SQL

USE enwiki_p;
SELECT DISTINCT (page.page_title)
  FROM page INNER JOIN iwlinks ON page.page_id = iwlinks.iwl_from
 WHERE page.page_namespace = 0
   AND iwlinks.iwl_prefix = 'wikt'
   AND iwlinks.iwl_title RLIKE '^[aábcčdďeéěfghchiíjklmnňoópqrřsštťuúůvwxyýzž].*';

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...