Hewiki Sweden - Quarry

SQL

use hewiki_p;
#select * from page where (page_title like "%שבדי%" or page_title like "%נורבגי%") and page_is_redirect = 1;
#select * from page where (page_title like "%שבדי%" or page_title like "%נורבגי%") and page_is_redirect = 0;
#select * from page
#where (page_title like "%שבדי%" or page_title like "%נורבגי%")
#and page_is_redirect = 1
#and not exists
#(select * from pagelinks
# where pl_title = page_title
# and pl_namespace = page_namespace)
select * from page as p1
where p1.page_title like "%שבדי%"
and not p1.page_namespace in (2, 3)
and not exists
(select * from page as p3
 where p1.page_namespace = p3.page_namespace
 and p3.page_title = replace(p1.page_title, "שבדי", "שוודי"));
select * from page as p1
where p1.page_title like "%נורבגי%"
and not p1.page_namespace in (2, 3)
and not exists
(select * from page as p3
 where p1.page_namespace = p3.page_namespace
 and p3.page_title = replace(p1.page_title, "נורבגי", "נורווגי"));
SQL

Checking query status...
