langl - Quarry

SQL

SET @N = 20;
set @I = "z";


SELECT * from
(select page_id as id, page_title as ad, substring(lower(convert(page_title using utf8)),1,@N) as bak, 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)) = @I
) as trp

join

(select page_id as id, page_title as ad, substring(lower(convert(page_title using utf8)),1,@N) as bak, 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)) = @I
) as azp


on azp.bak = trp.bak
where azp.uz = trp.uz

limit 10

;
SQL

Checking query status...
