langl - Quarry

SQL

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


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

join

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


on azp.bak = trp.bak

limit 10

;
SQL

Checking query status...
