Alexandre056 categories

SQL

USE frwiki_p;

SELECT 
  categorylinks.cl_to AS Category,
  COUNT(DISTINCT page.page_title) AS Total_Articles
FROM 
  categorylinks
  INNER JOIN page ON categorylinks.cl_from = page.page_id
  INNER JOIN revision ON page.page_latest = revision.rev_id
  INNER JOIN actor ON revision.rev_actor = actor.actor_id
WHERE 
  categorylinks.cl_type = 'page'
  AND categorylinks.cl_sortkey_prefix = ''
  AND page.page_namespace = 14
  AND actor.actor_name = 'Alexandre056'
GROUP BY 
  categorylinks.cl_to
HAVING 
  Total_Articles < 10
ORDER BY 
  Total_Articles DESC;
SQL

Checking query status...
