blue links linked from page linked on a page

SQL

use ruwiki_p;
SELECT/*
CONCAT("*[[", GROUP_CONCAT((select pl_title from p00 where p00.pl_title IN 
             (SELECT page_title FROM page WHERE page_namespace = 0 and page_title 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
limit 30
SQL

Checking query status...
