trws yeni - Quarry

SQL

USE trwikisource_p;
select *, count(*) from (
select lower(convert(page_title using utf8)) as ad, page_namespace, page_id from page 
where page_is_redirect < 1
-- and page_title not rlike "İ"

-- group by 1 having count(*) =1 
) as cc
-- where 
-- cc.ad not rlike "ş" and 
-- cc.ad not rlike "ı"
-- and cc.ad not rlike "ğ"

group by cc.page_namespace
;

select page_namespace, count(*) from page 
where page_is_redirect =1 group by page_namespace 
;
select * from templatelinks join page on page_id = tl_from 
where page_namespace =0
group by tl_from;

select * from page where page_title like "A%"
and page_namespace = 0 
-- and page_is_redirect = 0
;
SQL

Checking query status...
