Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
ಮಲ್ನಾಡಾಚ್ ಕೊಂಕ್ಣೊ
.
Toggle Highlighting
SQL
select CONCAT('[[', case 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:' end, replace(page_title, '_', ' '), ']]') as 'Page title' -- Format as wikilink, replace _ with space from page join revision on rev_page = page_id -- link with revision table to filter specific user join `comment` on comment_id = rev_comment_id -- link with comment table to filter edit summary. Escape comment keyword with ` join linter on linter_page = page_id -- link with linter table where page_namespace in (1, 2, 3, 4, 5) -- Filter namespaces and rev_timestamp >= '20230201' -- Edit was after 1 February 2023 and comment_text like '%Linter%' -- Edit summary has the word Linter and rev_actor = (select actor_id -- Page was edited by Jonesey95 from actor where actor_name = 'Jonesey95') and linter_cat = 2 -- filter pages with obsolete html tag errors and linter_params like '%"font"%' -- filter pages with font tag errors group by page_id -- filter duplicate pages with multiple font tag errors order by page_namespace asc, page_title asc; -- arrange by namespace and title in asceding order
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...