wbc2 - Quarry

SQL

use lvwiki_p;
SELECT p.page_title
from page p
where p.page_namespace=10
and p.page_title not like "%/%"  and p.page_is_redirect=0
and p.page_id not in (SELECT  eu_page_id
					from wbc_entity_usage wb
					GROUP BY eu_page_id)
                    and p.page_id not in (select ll_from from langlinks ll )
#and p.page_namespace=0 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_title not like "%/%" and p.page_namespace=10 and p.page_id not in (select ll_from from langlinks ll )
limit 900;
/*
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...
