Argentine film stubs

SQL

SELECT page_title,
       GROUP_CONCAT(DISTINCT cl_to SEPARATOR '|') AS `category`,
       page_len,
       COUNT(DISTINCT pl_title) AS `#/outgoing links to mainspace`
FROM page
JOIN pagelinks ON pl_from = page_id AND pl_namespace = 0
JOIN categorylinks ON cl_from = page_id AND cl_to LIKE '1%Argentine\_films'
WHERE page_namespace = 0
  AND page_is_redirect = 0
  AND page_len < 2000
GROUP BY page_title;

AخA
 
SELECT page_title,       GROUP_CONCAT(DISTINCT cl_to SEPARATOR '|') AS `category`,       page_len,       COUNT(DISTINCT pl_title) AS `#/outgoing links to mainspace`FROM pageJOIN pagelinks ON pl_from = page_id AND pl_namespace = 0JOIN categorylinks ON cl_from = page_id AND cl_to LIKE '1%Argentine\_films'WHERE page_namespace = 0  AND page_is_redirect = 0  AND page_len < 2000GROUP BY page_title;

SQL

Checking query status...