Pages with defaultsort (lvwiki)

SQL

SELECT pl.pl_namespace, pl.pl_title, count(pl.pl_from), pl.pl_from_namespace
from pagelinks pl
where pl.pl_namespace=0 
and pl.pl_from_namespace=0
and /*pl.pl_from_namespace=0 and  - svarīgi arī veidnēs izvākt*/ pl.pl_title in (SELECT p2.page_title
from pagelinks pl2
join page p2 on pl2.pl_from=p2.page_id
where p2.page_is_redirect=1 and pl2.pl_namespace=0
		and pl2.pl_from_namespace=0
      and /*pl2.pl_from_namespace=0 and  - svarīgi arī veidnēs izvākt*/pl2.pl_title in (
#SELECT p.page_title, COUNT(pl.pl_from) FROM page p
SELECT p.page_title
FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = "Izolētie_raksti"
INNER JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
INNER JOIN page p2 ON p2.page_id = pl.pl_from
AND pl.pl_from_namespace = 0 and p2.page_is_redirect=0)
group by pl.pl_title
order by count(pl.pl_from)
SQL

Checking query status...
