frk rakstu pāradresācijas

SQL

use lvwiki_p;
SELECT rd_title, rd_namespace, page_title, page_namespace FROM redirect INNER JOIN page ON rd_from=page_id WHERE rd_title IN (

  SELECT page_title
FROM revision r
join page p on p.page_id=r.rev_page
WHERE p.page_namespace=0 and p.page_is_redirect=0
	and r.rev_parent_id=0 and r.rev_user=9590
and not exists (select * from templatelinks t where p.page_id = t.tl_from AND t.tl_namespace = 10 AND t.tl_title in ('Uzvārds','Nozīmju_atdalīšana'))

)
and rd_namespace=0 and page_namespace=0

SQL

Checking query status...