Alexandre056 categories

SQL

USE frwiki_p;

SELECT 
  cl_to AS Category,
  COUNT(DISTINCT page.page_title) AS Total_Pages
FROM 
  page
  INNER JOIN categorylinks ON page.page_id = categorylinks.cl_from
  INNER JOIN revision ON page.page_latest = revision.rev_id
  INNER JOIN actor ON revision.rev_actor = actor.actor_id
WHERE 
  page_namespace = 14
  AND actor.actor_name = 'Alexandre056'
  AND categorylinks.cl_to IN (
    SELECT 
      cl_to
    FROM 
      categorylinks
    WHERE 
      cl_type = 'page'
      AND cl_sortkey_prefix = ''
      AND cl_from IN (SELECT page_id FROM page WHERE page_namespace = 14 AND page_title = 'Utilisateur:Alexandre056')
  )
GROUP BY 
  cl_to;
SQL

Checking query status...
