Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
ruwiki: count article titles ending with ? ! . ... … " »
by
Jack who built the house
This query is marked as a draft
This query has been published
by
NSkaggs (WMF)
.
It can be used on 404 page (MediaWiki:Noarticletext), when the user has clicked on a link without ending character, checking its existense with #ifexist and advising him to follow the link. Article titles ending with "." are here: https://quarry.wmflabs.org/query/16258.
Toggle Highlighting
SQL
select case when right(page_title, 3) = "..." or right(page_title, 3) = "…" then right(page_title, 3) when right(page_title, 2) = "»" then right(page_title, 2) else right(page_title, 1) end as "Last character(s)", if(page_is_redirect, "yes", "no") as "Is redirect", count(*) as "Count of pages", replace(page_title, "_", " ") as "Pagename example" from page where page_namespace = 0 and ( right(page_title, 1) = "?" or right(page_title, 1) = "!" or right(page_title, 1) = "." or right(page_title, 3) = "…" or right(page_title, 1) = "\"" or right(page_title, 2) = "»") group by case when right(page_title, 3) = "..." or right(page_title, 3) = "…" then right(page_title, 3) when right(page_title, 2) = "»" then right(page_title, 2) else right(page_title, 1) end, if(page_is_redirect, "yes", "no")
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...