lvwiki pages without WD item

SQL

SELECT p.page_namespace, p.page_title
from page p
where p.page_namespace in (0,10,14)
and p.page_title not like "%/doc"
and p.page_is_redirect=0
and not exists (SELECT *
					from wbc_entity_usage wb
                where eu_page_id=p.page_id
					GROUP BY eu_page_id limit 1)
and not exists (select * from langlinks where p.page_id=ll_from limit 1)
and p.page_id not in (select cl_from
							from categorylinks
							where cl_to in ("Lapas,_kas_izvirzītas_dzēšanai","Nozīmju_atdalīšana","Latvijas_ciemi"))
order by p.page_id desc;

SELECT p.page_title
from page p
where p.page_namespace=0
and p.page_is_redirect=0
and not exists (SELECT *
					from wbc_entity_usage wb
                where eu_page_id=p.page_id
					GROUP BY eu_page_id limit 1)
and not exists (select * from langlinks where p.page_id=ll_from limit 1)
and p.page_id not in (select cl_from
							from categorylinks
							where cl_to in ("Lapas,_kas_izvirzītas_dzēšanai","Nozīmju_atdalīšana","Latvijas_ciemi"))
order by p.page_id desc;

SELECT p.page_title
from page p
where p.page_namespace=0
and p.page_is_redirect=0
and exists (SELECT *
					from wbc_entity_usage wb
                where eu_page_id=p.page_id
					GROUP BY eu_page_id limit 1)
and not exists (select * from langlinks where p.page_id=ll_from limit 1)
and p.page_id not in (select cl_from
							from categorylinks
							where cl_to in ("Lapas,_kas_izvirzītas_dzēšanai","Nozīmju_atdalīšana","Latvijas_ciemi"))
order by p.page_id desc;
SQL

Checking query status...
