Biologie - Quarry

SQL

SELECT
  page.page_title,
  GROUP_CONCAT(DISTINCT cl_to SEPARATOR '|') AS categories,
  SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING(page.page_text, LOCATE('{{ébauche|', page.page_text) + 10), '}}', 1), '|', -1) AS stub_template,
  SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING(page.page_text, LOCATE('{{taxobox|', page.page_text) + 10), '}}', 1), '|', -1) AS taxobox_template
FROM
  page
  JOIN categorylinks ON page.page_id = categorylinks.cl_from
WHERE
  categorylinks.cl_to = 'Portail:Biologie/Articles_liés'
  AND page.page_namespace = 0
GROUP BY
  page.page_title;
SQL

Checking query status...
