lvwiki articles with only one sitelink

SQL

use lvwiki_p;

SELECT p.page_title,
    (SELECT GROUP_CONCAT(cl_to SEPARATOR '|') FROM categorylinks cl where cl.cl_from=page_id) as cats,
    (SELECT GROUP_CONCAT(tl_title SEPARATOR '|') FROM templatelinks
            WHERE tl_namespace = 10 and tl_from=page_id and tl_title like "%kaste%") as box
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"))
and p.page_id not in (select t.tl_from from templatelinks t
                      where t.tl_namespace = 10 AND t.tl_title='Uzvārds')
order by p.page_id desc;
SQL

Checking query status...
