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 as p1
where exists
(select * from redirect
 where rd_namespace = p1.page_namespace
 and rd_title = p1.page_namespace
 and exists
 (select * from page as p2
  where rd_from = p2.page_id
  and (p2.page_title like "%שבדי%" or p2.page_title like "%נורבגי%")))
SQL

Checking query status...
