blue links linked from page linked on a page

SQL

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

Checking query status...
