wbc3 - Quarry

pirms nākamās reizes atcerēties nomainīt order by

10 - veidne
14 - kategorija

use lvwiki_p;
SELECT 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" or cl_to="Lapas,_kas_izvirzītas_dzēšanai")
order by p.page_title

SQL

select now();

SELECT p.page_title,
    (SELECT GROUP_CONCAT(cl_to SEPARATOR '|') FROM categorylinks cl where cl.cl_from=page_id) as cats,
    (SELECT GROUP_CONCAT(lt_title SEPARATOR '|') FROM templatelinks join linktarget ON tl_target_id = lt_id
            WHERE lt_namespace = 10 and tl_from=page_id and lt_title like "%kaste%") as box
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 ("Dzēšanai_izvirzītās_lapas","Nozīmju_atdalīšana"))
and p.page_id not in (select t.tl_from from templatelinks t join linktarget ON tl_target_id = lt_id
                      where lt_namespace = 10 AND lt_title='Uzvārds')
order by p.page_id desc

SQL

Checking query status...