olmamali - Quarry

SQL

USE trwiki_p;
SELECT concat("tr.wikipedia.org/wiki?redirect=no&curid=",page_id) as url, page.*
from page left join redirect on rd_from = page_id
where page_is_redirect = 1 and rd_title is null

limit 10
;

select  concat("tr.wikipedia.org/wiki?curid=",rd_from) as url, redirect.* from redirect
left join page on page_id = rd_from
where page_title is null 
;

select  concat("tr.wikipedia.org/wiki?curid=",rd_from) as url, page_namespace , page_title, redirect.*
from redirect
join page on page_id = rd_from
where page_is_redirect = 0
;
select  concat("tr.wikipedia.org/wiki?curid=",page_id) as url, page_namespace , page_title
from redirect
right join page on page_id = rd_from
where page_is_redirect = 1 and rd_from is null
;

/*
select concat("tr.wikipedia.org/wiki?curid=",il_from) as url, il_to, count(*) from imagelinks where il_from_namespace = 0

group by il_from, il_to having count(*)>1
order by count(*) desc
;
*/
select concat("tr.wikipedia.org/wiki?curid=",pl_from) as url, pl_title, count(*) from pagelinks where pl_from_namespace = 0 

and  pl_title rlike ".ks.z" and pl_title not rlike "m"
group by pl_from, pl_title having count(*)>1
order by count(*) desc
;
SQL

Checking query status...
