arwiki wbc - Quarry

SQL

use arwiki_p;
SELECT wb.eu_entity_id, concat('Template:',p.page_title)
from page p
join wbc_entity_usage wb on p.page_id=wb.eu_page_id
where# p.page_id in (SELECT  eu_page_id
	#				from wbc_entity_usage wb
	#				GROUP BY eu_page_id)
#and 
p.page_title not like "%/%" and p.page_title REGEXP '^[A-Za-z0-9]'
#p.page_title like "Izmeklēti_notikumi%"
and p.page_namespace=10 and p.page_is_redirect=0# and p.page_id not in (select cl_from
												#				from categorylinks
												#				where cl_to="Nozīmju_atdalīšana")
and p.page_id not in (select ll_from from langlinks ll )
group by p.page_title
order by p.page_title asc
#limit 5;
/*
use lvwiki_p;
SELECT
  *
FROM pagelinks pl
join page p ON pl.pl_title = p.page_title
join wbc_entity_usage wb on p.page_id = wb.eu_page_id
#JOIN pagelinks pl ON pl.pl_from = p.page_id
WHERE  pl.pl_namespace = 0 AND p.page_namespace=0 and
pl.pl_from = 290249
GROUP BY eu_page_id
limit 10;
*/
SQL

Checking query status...
