ruwiki: count article titles ending with ? ! . ... … " »

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.

SQL

use ruwiki_p;

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, 2) = "…" 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")

SQL

Checking query status...