Untitled query #27627

SQL

USE zhwiki_p;
select p1.page_title, p1.page_namespace, linter_cat,
       concat('https://zh.wikipedia.org/wiki/', p1.page_title, '?action=parsermigration-edit&lintid=', linter_id) as url,
       linter_params as more_info, linter_id as linter_id, linter_start as start_offset, linter_end as end_offset
from linter
join page p1 on p1.page_id = linter.linter_page and p1.page_namespace in (0, 12, 100, 118)
JOIN templatelinks
ON tl_from = page_id
AND tl_namespace = 10
AND tl_title = "Infobox rail system-route"
AND page_namespace = 0
SQL

Checking query status...
