SQL
x
use bnwiki_p;
select concat("#[[আলাপ:",page_title,"]]"),
actor_name
from revision
join page p
on rev_page = page_id
join actor
on rev_actor = actor_id
where page_namespace = 1
and page_len = 29
and rev_parent_id = 0
and page_is_redirect = 0
and exists (
select null
from page
where page_namespace = 0
and page_title = p.page_title
and page_is_redirect = 1
);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.