Untitled query #51849

SQL

use tewiki_p;
select actor_name,concat("[[చర్చ:",page_title,"]]"),concat(left(rev_timestamp,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2)) as Edit_Date from page p
join revision on rev_page = page_id
join actor on actor_id = rev_actor
where page_is_new =  1 
	and page_namespace=1
    and page_is_redirect = 0
    and actor_user is not null
    and page_title not in (select rd_title from redirect where rd_namespace = p.page_namespace)
    and rev_page in (select tl_from from templatelinks)
order by actor_name,Edit_Date
SQL

Checking query status...
