langl - Quarry

SQL

SET @N = 20;
set @initial = "s";


/*select page_title, length(page_title)
, substring(page_title,1,length(page_title)/4) as i1
, substring(page_title,length(page_title)/4,length(page_title)/2) as i2
, substring(page_title,length(page_title)/2,length(page_title)*3/4) as i3
, substring(page_title,length(page_title)*3/4) as i4
*/
SELECT cmp.id as id, cmp.ad as ad, cmp.uz as uz
,substring(cmp.adutf,1,cmp.uz / 4) as utf1
,substring(cmp.adutf,cmp.uz / 4,cmp.uz / 2) as utf2
,substring(cmp.adutf,cmp.uz / 2,cmp.uz * 3 / 4) as utf3
,substring(cmp.adutf,cmp.uz * 3/ 4) as utf4
from 

(select page_id as id, page_title as ad, lower(convert(page_title using utf8)) as adutf, length(page_title) as uz
from commonswiki_p.page
where page_namespace = 6 and page_is_redirect = 0 and page_is_new = 0
and lower(convert( substring(page_title,1,1) using utf8)) = @initial
and length(page_title) <= @N

limit 10 ) as cmp
;
SQL

Checking query status...
