YoavR draft - Quarry

SQL

use hewiki_p;
select * from page
where page_title = "המקבץ_השבועי/מזרח/דף_משנה";
select count(pl_title), rev_user_text from pagelinks join page
on page_title = pl_title
join revision
on rev_page = page_id
where pl_from in
(select * from page
 where page_title = "המקבץ_השבועי/מזרח/דף_משנה"
 and page_namespace = 4)
and page_namespace = 0
and rev_user > 0
group by rev_user_text;
select * from pagelinks join page
on page_title = pl_title
join revision
on rev_page = page_id
where pl_from = 1374968
and page_namespace = 0
and rev_user > 0
and rev_parent_id = 0
SQL

Checking query status...
