find types subtemplates on commons - Quarry

Fork of find template redirects by Jarekt

This query is marked as a draft This query has been published by Jarekt.

search through all the templates with subtemplates and find all the last segments of the subtemplate names. Keep segments which appear more then once and are shorter than 13 (the longest language code is 12) and start with a letter

SQL

select sub, num, length(sub) as len, left(sub,1) as ch from (
	select RIGHT(page_title, INSTR(REVERSE(page_title),'/') -1) as sub, count(*) as num
	from page
	where page_namespace = 10 and page_title LIKE "%/%"
	group by sub
	order by num desc
) as innerquery
having num>1 and len<13

AخA
 
select sub, num, length(sub) as len, left(sub,1) as ch from (    select RIGHT(page_title, INSTR(REVERSE(page_title),'/') -1) as sub, count(*) as num    from page    where page_namespace = 10 and page_title LIKE "%/%"    group by sub    order by num desc) as innerqueryhaving num>1 and len<13 

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...