Zsáklapok a huwikin

SQL

USE huwiki_p;
Insert into pl1
SELECT pl_from FROM pagelinks group by pl_from;
alter table pl1 add KEY (pl_from);
CREATE TABLE zsak LIKE ujwikin2.zsak;
Insert into zsak (page_id, page_namespace, page_title)
select page_id, page_namespace, page_title from page
left join pl1 on page_id=pl_from
where pl_from is null and page.page_namespace = 0;
CREATE TABLE zsak_noatir LIKE zsak;
Insert into zsak_noatir (page_id, page_namespace, page_title)
select zsak.page_id, zsak.page_namespace, zsak.page_title from zsak
left join page on zsak.page_id=page.page_id
where page.page_is_redirect=0;
SQL

Checking query status...
