Biologie - Quarry

SQL

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

Checking query status...
