wbc2 - Quarry

SQL

use lvwiki_p;
SELECT #concat('* [[',p.page_title,']]')
#concat('* [[:Kategorija:',p.page_title,']]')
p.page_title
from page p
where p.page_namespace=0
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_id not in (select cl_from
																from categorylinks
																where cl_to="Nozīmju_atdalīšana")
and p.page_id not in (select cl_from
																from categorylinks
																where cl_to="Lapas,_kas_izvirzītas_dzēšanai" or
                    												  cl_to="Iespējami_autortiesību_pārkāpumi")
order by p.page_title asc
/*
where p.page_namespace=10
and p.page_title like "Val_%"
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_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...
