Query test 4 - Quarry

SQL

SELECT
     CONCAT("[[",page_title,"]]") as page, cl_to as category
FROM page p
JOIN categorylinks cl
ON p.page_namespace = 0 -- main page
AND cl.cl_from = p.page_id
      AND cl.cl_to in (
SELECT
  page_title as subcat
FROM page p
JOIN categorylinks cl
ON p.page_namespace = 14 -- Optional namespace check. 14 - categories, 6 - files
AND cl.cl_from = p.page_id
      AND cl.cl_to = "Persone_per_attività" -- Insert your category here.
      )
     AND p.page_id NOT IN 
	(SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('Bio'));
SQL

Checking query status...
