Alexandre056 categories

This query is marked as a draft This query has been published by LD.

fr:Wikipédia:Bulletin_des_administrateurs/2023/Semaine_14#Création_de_catégories_à_la_chaîne

SQL

USE frwiki_p;

SELECT 
  cl_to AS Category,
  COUNT(*) AS Total_Articles
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 
  Category
HAVING 
  Total_Articles < 10;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...