Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Pages with obsolete font tags, excluding other types of Lint errors
by
ಮಲ್ನಾಡಾಚ್ ಕೊಂಕ್ಣೊ
This query is marked as a draft
This query has been published
by
Sheep8144402
.
Toggle Highlighting
SQL
select CONCAT('[[', case when page_namespace = 2303 then 'Gadget definition talk:' when page_namespace = 2302 then 'Gadget definition:' when page_namespace = 2301 then 'Gadget talk:' when page_namespace = 2300 then 'Gadget:' when page_namespace = 829 then 'Module talk:' when page_namespace = 828 then 'Module:' when page_namespace = 710 then 'TimedText:' when page_namespace = 711 then 'TimedText talk:' when page_namespace = 119 then 'Draft talk:' when page_namespace = 118 then 'Draft:' when page_namespace = 101 then 'Portal talk:' when page_namespace = 100 then 'Portal:' when page_namespace = 15 then 'Category talk:' when page_namespace = 14 then 'Category:' when page_namespace = 13 then 'Help talk:' when page_namespace = 12 then 'Help:' when page_namespace = 11 then 'Template talk:' when page_namespace = 10 then 'Template:' when page_namespace = 9 then 'MediaWiki talk:' when page_namespace = 8 then 'MediaWiki:' when page_namespace = 7 then 'File talk:' when page_namespace = 6 then 'File:' when page_namespace = 5 then 'Wikipedia talk:' when page_namespace = 4 then 'Wikipedia:' when page_namespace = 3 then 'User talk:' when page_namespace = 2 then ':User:' when page_namespace = 1 then 'Talk:' when page_namespace = 0 then '' end, replace(page_title, '_', ' '), ']]') as 'Page title' -- Format as wikilink, replace _ with space from linter join page p1 on page_id = linter_page where linter_cat=2 -- filter obsolete html tag errors and page_namespace in (3) -- filter by namespace and linter_params like '%"font"%' -- filter font tag errors and not exists (select 1 -- filter out pages with center tag error from linter join page p3 on page_id = linter_page where linter_cat = 2 and p1.page_id = p3.page_id and linter_params like '%"center"%') and not exists (select 1 -- filter out pages which also has other types of Lint errors from linter join page p2 on page_id = linter_page where linter_cat <> 2 and p1.page_id = p2.page_id) group by page_id -- filter duplicate pages with multiple font tag errors -- having count(*) between 15 and 20 -- filter by font tag error count order by count(*) desc, page_namespace asc, page_title asc -- arrange by most number of errors, namespace and title in asceding order -- limit 10000;
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...