Untitled query #58544

SQL

SELECT cl_to, COUNT(*) AS count FROM categorylinks 
WHERE cl_to LIKE 'Ab%'
GROUP BY cl_to


/*
SELECT LEFT(log_timestamp,4) AS år, actor_name, COUNT(log_title) FROM logging INNER JOIN page ON log_title=page_title INNER JOIN categorylinks on page_id=cl_from INNER JOIN actor ON log_actor=actor_id WHERE
log_action = 'create'
AND log_namespace = 0
AND cl_to = 'Svenska_präster_under_1800-talet'
GROUP BY år, actor_name
*/

/*
SELECT actor_name AS användare, COUNT(*) AS antal_biografiredigeringar, COUNT(IF(cl_to='Kvinnor','1',NULL)) AS därav_antal_kvinnor, COUNT(IF(cl_to='Män','1',NULL)) AS därav_antal_män,  SUM(IF(cl_to='Kvinnor',1,0))/COUNT(*) AS andel_kvinnor, MIN(rc_timestamp) AS från, MAX(rc_timestamp) AS till FROM recentchanges INNER JOIN actor ON rc_actor=actor_id INNER JOIN page ON rc_title=page_title INNER JOIN categorylinks ON page_id=cl_from WHERE
rc_namespace = 0
AND rc_bot = 0
AND NOT rc_source = 'wb'
AND (cl_to = 'Kvinnor' OR cl_to = 'Män')
GROUP BY actor_name
HAVING antal_biografiredigeringar>=30
ORDER BY antal_biografiredigeringar DESC, andel_kvinnor DESC
*/

/* SELECT CONCAT('[[',REPLACE(page_title,'_',' '),']]') AS Artikel, COUNT(*) AS Antal_redigeringar_under_2021, COUNT(DISTINCT rev_actor) AS Antal_redigerare_under_2021 FROM revision INNER JOIN page ON rev_page=page_id INNER JOIN actor on rev_actor=actor_id WHERE 
rev_timestamp > '20210101000000' AND rev_timestamp < '20220101000000'
AND page_namespace=0
GROUP BY page_title, page_namespace
ORDER BY Antal_redigeringar_under_2021 DESC, page_title
LIMIT 1000
*/
SQL

Checking query status...
