blue links linked from page linked on a page

SQL

use ruwiki_p;
SELECT
CONCAT("*[[", GROUP_CONCAT((select pl_title from pagelinks where p00.pl_title IN 
             (SELECT page_title FROM page WHERE page_namespace = 10 and page_title 
              not in ("Таксон")) 
#              not like "Биологический_такс%") 
                            GROUP BY p00.pl_title) SEPARATOR "]], [["), "]]") as blue_links,/*
CONCAT("\[[", GROUP_CONCAT((select pl_title from p00 where p00.pl_title not IN 
                            (SELECT page_title FROM page WHERE page_namespace = 0) 
                            GROUP BY p00.pl_title) SEPARATOR "]], [["), "]]") as red_links,*/#pl_title,
CONCAT("\[[Template:",page_title,"]]") as template
FROM pagelinks as p00
JOIN page ON page_namespace = 10 AND page.page_id = p00.pl_from
WHERE p00.pl_from_namespace = 10
#AND p00.pl_namespace = 0
and page_title in (select pl_title from pagelinks pl1 where pl1.pl_from = 1683139 and pl1.pl_namespace = 10)
#GROUP BY page_title
#ORDER BY blue_links ASC, red_links ASC
ORDER BY page_title ASC
limit 30
SQL

Checking query status...
