Alexandre056 categories

SQL

USE frwiki_p;

SELECT 
  page.page_title AS Page,
  COUNT(DISTINCT cl_to, IF(cl_type = 'page', page_id, NULL)) AS Total_Children
FROM 
  page
  INNER JOIN categorylinks ON page.page_id = categorylinks.cl_from
  LEFT JOIN page AS subpage ON categorylinks.cl_to = subpage.page_title AND subpage.page_namespace = 0
WHERE 
  page.page_namespace = 14
  AND page.page_title IN (
    SELECT 
      page.page_title
    FROM 
      page
      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'
  )
GROUP BY 
  page.page_title
HAVING 
  Total_Children < 10;
SQL

Checking query status...
