Kotz draft - Quarry

SQL

use hewiki_p;
select concat("[[", replace(page_title, "_", " "), "]]") from page
where exists
(select * from pagelinks
 where pl_from = 1342539
 and pl_title = page_title
 and pl_namespace = page_namespace)
and not exists
(select * from categorylinks
 where cl_from = page_id
 and cl_to = "חברי_המפלגה_הדמוקרטית_(ארצות_הברית)")
and page_namespace = 0;
select concat("[[", replace(page_title, "_", " "), "]]") from page
where exists
(select * from pagelinks
 where pl_from = 1342528
 and pl_title = page_title
 and pl_namespace = page_namespace)
and not exists
(select * from categorylinks
 where cl_from = page_id
 and cl_to = "חברי_המפלגה_הרפובליקנית_(ארצות_הברית)")
and page_namespace = 0
SQL

Checking query status...
