Biologie - Quarry

SQL

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

Checking query status...
