Biologie - Quarry

SQL

SELECT
  page_title AS title,
  GROUP_CONCAT(DISTINCT cl_to SEPARATOR ';') AS categories,
  GROUP_CONCAT(DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(page_text, '{{ébauche|', -1), '}}', 1) SEPARATOR ';') AS stubs,
  GROUP_CONCAT(DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(page_text, '{{taxobox', -1), '}}', 1) SEPARATOR ';') AS classifications
FROM page
JOIN categorylinks ON cl_from = page_id
JOIN templatelinks ON tl_from = page_id
WHERE cl_to = 'Portail:Biologie/Articles_liés'
  AND (tl_title = 'Ébauche' OR tl_title = 'Taxobox')
GROUP BY page_title;
SQL

Checking query status...
