langl - Quarry

SQL

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


/*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 * from
(SELECT id, ad, uz
,substring(adutf,1,uz / 4) as utf1
,substring(adutf,uz / 4,uz / 2) as utf2
,substring(adutf,uz / 2,uz * 3 / 4) as utf3
,substring(adutf,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 trwiki_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

) as temp1 ) as trp

join


(SELECT id, ad, uz
,substring(adutf,1,uz / 4) as utf1
,substring(adutf,uz / 4,uz / 2) as utf2
,substring(adutf,uz / 2,uz * 3 / 4) as utf3
,substring(adutf,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 azwiki_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

) as temp2 ) as azp

on trp.utf1 rlike azp.utf1

-- where trp.uz = azp.uz and trp.utf1 = azp.utf1

;
SQL

Checking query status...
