Chen draft - Quarry

SQL

use hewiki_p;
select replace(page_title, "_", " ") as "ערך", page_len as "גודל" from page as p1
where exists
(select * from page as p3
 where p1.page_title = p3.page_title
 and p3.page_namespace = 1
 and exists
(select * from categorylinks
 where cl_from = p3.page_id
 and replace(cl_to, "_", " ") in
 ('ערכים שנוצרו במסגרת תחרות "יוצרות ערך" 2015')
 and p1.page_namespace = 0));
select count(page_len) as "כמות", sum(page_len) as "סכום" from page as p1
where exists
(select * from page as p3
 where p1.page_title = p3.page_title
 and p3.page_namespace = 1
 and exists
(select * from categorylinks
 where cl_from = p3.page_id
 and replace(cl_to, "_", " ") in
 ('ערכים שנוצרו במסגרת תחרות "יוצרות ערך" 2015')
 and p1.page_namespace = 0));
select replace(page_title, "_", " ") as "ערך", page_len as "גודל" from page as p1
where exists
(select * from page as p3
 where p1.page_title = p3.page_title
 and p3.page_namespace = 1
 and exists
(select * from categorylinks
 where cl_from = p3.page_id
 and replace(cl_to, "_", " ") in
 ('ערכים שנערכו במסגרת מיזם ויקי נשים',
  'ערכים של האגודה לחקר אמנות נשים ומגדר עם ויקי נשים')
 and p1.page_namespace = 0));
select count(page_len) as "כמות", sum(page_len) as "סכום" from page as p1
where exists
(select * from page as p3
 where p1.page_title = p3.page_title
 and p3.page_namespace = 1
 and exists
(select * from categorylinks
 where cl_from = p3.page_id
 and replace(cl_to, "_", " ") in
 ('ערכים שנערכו במסגרת מיזם ויקי נשים',
  'ערכים של האגודה לחקר אמנות נשים ומגדר עם ויקי נשים')
 and p1.page_namespace = 0))
SQL

Checking query status...
