Untitled query #17569

SQL

USE svwiki_p;

SELECT rc_title, COUNT(*) AS antal FROM recentchanges INNER JOIN actor ON rc_actor=actor_id WHERE
actor_name = 'ListeriaBot' 
/*
AND rc_timestamp > '20210817000000'
*/
GROUP BY rc_title
ORDER BY antal DESC
LIMIT 10



/*
SELECT COUNT(*) AS antal FROM pagelinks WHERE
(pl_title = 'Osmia' OR pl_title = 'Murarbin_(Osmia)')
AND pl_namespace = 0
*/

/*
SELECT
CONCAT("# {{target | user =",actor_name,"| site = mediawiki.org }}") AS rev_user_text,
COUNT(actor_id) AS recent_user_editcount
FROM revision
JOIN actor_revision ON rev_actor=actor_id
JOIN page ON rev_page=page_id
WHERE actor_user IS NOT NULL
  AND page_namespace IN (0)
  AND rev_timestamp BETWEEN 20210101000000 AND 20210630235959
  AND actor_user NOT IN (select ug_user from user_groups where ug_group = 'bot')
GROUP BY actor_id
ORDER BY recent_user_editcount DESC
LIMIT 300;
*/

/*
SELECT SUBSTR(log_timestamp,1,6) AS month, COUNT(*) AS antal FROM logging WHERE
log_action = 'delete'
AND log_namespace = 0
AND log_timestamp > '20180101000000'

GROUP BY month
ORDER BY month
*/

/*
SELECT page_title, "§" x, rev_timestamp, "§" y, actor_name FROM page INNER JOIN revision ON page_id=rev_page INNER JOIN actor on rev_actor=actor_id
WHERE page_namespace = 4 
AND page_title LIKE 'Sidor_föreslagna_för_radering/%'
*/

/*
SELECT DISTINCT p1.page_namespace, p1.page_title, cl_to, pp_propname FROM categorylinks 
INNER JOIN page p1 ON cl_from=p1.page_id 
INNER JOIN category ON cl_to=cat_title
INNER JOIN page p2 ON cat_title=p2.page_title
INNER JOIN page_props ON p2.page_id=pp_page
WHERE ((p1.page_namespace = 2 AND p1.page_title LIKE '%/%') OR p1.page_namespace= 3)
AND p1.page_title NOT LIKE 'Lsjbot%'
*/
SQL

Checking query status...
