YoavR draft - Quarry

SQL

set @list = "המקבץ השבועי/מזרח/דף משנה";

use hewiki_p;
select rev_user_text, count(pl_title) from pagelinks join page
on page_title = pl_title
join revision
on rev_page = page_id
where pl_from in
(select page_id from page
 where page_title = replace(@list, " ", "_")
 and page_namespace = 4)
and page_namespace = 0
and rev_user > 0
group by rev_user_text
order by count(pl_title) desc;
select * from pagelinks join page
on page_title = pl_title
join revision
on rev_page = page_id
where pl_from in
(select page_id from page
 where page_title = replace(@list, " ", "_")
 and page_namespace = 4)
and page_namespace = 0
and rev_user > 0
and rev_parent_id = 0
SQL

Checking query status...
