Untitled query #20442

use lvwiki_p;
SELECT p.page_title#concat('Veidne:',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 in ("Lapas,_kas_izvirzītas_dzēšanai","Nozīmju_atdalīšana"))
order by p.page_id desc



use lvwiki_p;
SELECT p.page_title#concat('Veidne:',p.page_title)
from page p
where p.page_namespace=14
and p.page_is_redirect=0
and p.page_id not in (select ll_from from langlinks ll )
order by p.page_id desc

SQL

use lvwiki_p;
SELECT *
from iwlinks
join page on page_id=iwl_from and page_namespace=14 and page_is_redirect=0
where iwl_prefix="commons"
and page_id not in (select ll_from from langlinks ll )
limit 100

SQL

Checking query status...