Commons main pages without page language set

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

Commons main pages are manually translated. Without page language set, magic words return English results, the editing interface doesn’t specifically support non-Latin scripts etc.

SQL

SELECT page_title, page_lang
	FROM pagelinks INNER JOIN page ON (page_namespace = pl_namespace AND page_title = pl_title)
    WHERE pl_from = 1615 AND pl_namespace = 0 AND page_lang IN (NULL, '', 'en');

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