bos - Quarry

SQL

USE trwiki_p;

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
;
SQL

Checking query status...
