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
Jack who built the house
.
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
use ruwiki_p; select right(page_title, 1) as "Последний символ", page_is_redirect, count(*), replace(page_title, "_", " ") as "page_title (пример)" 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, 2) = '»' group by "Последний символ", page_is_redirect
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...