Untitled query #58544

SQL

/*
SELECT * FROM revision JOIN page ON rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE
*/
SELECT actor_name, COUNT(*) AS antal FROM revision JOIN actor ON rev_actor=actor_id WHERE 
rev_timestamp > '20241111120000'
GROUP BY actor_name

/*
SELECT *, test, page1.page_title, lt_title, lt_namespace FROM pagelinks JOIN linktarget ON pl_target_id=lt_id JOIN page AS page1 ON pl_from=page1.page_id JOIN categorylinks ON page1.page_id=cl_from LEFT OUTER JOIN page AS page2 ON lt_title=page2.page_title WHERE
*/
/*SELECT page1.page_title, COUNT(*) AS antal FROM pagelinks JOIN linktarget ON pl_target_id=lt_id JOIN page AS page1 ON pl_from=page1.page_id JOIN categorylinks ON page1.page_id=cl_from LEFT OUTER JOIN page AS page2 ON lt_title=page2.page_title WHERE
cl_to = 'Efternamnsförgreningssidor'
AND lt_namespace = 0

AND page1.page_title = 'Möller'
AND page2.page_id IS NULL
 GROUP BY page1.page_title
*/
/*SELECT rev_timestamp, page_title, actor_name, comment_text FROM comment JOIN revision ON comment_id=rev_comment_id JOIN actor on rev_actor=actor_id JOIN page on rev_page=page_id WHERE
comment_text LIKE '%ag skrev%'
AND rev_timestamp > '20200101000000'
AND page_namespace = 0
ORDER BY rev_timestamp
*/
/*
SELECT log_timestamp, actor_name, log_title FROM logging JOIN actor ON log_actor=actor_id WHERE
log_timestamp > '20231001000000'
AND log_timestamp < '20241001000000'
AND log_action = 'thank'
*/
/*
SELECT actor_name, COUNT(*) as antal FROM revision JOIN actor ON rev_actor=actor_id WHERE
rev_timestamp < '20241001000000' 
AND rev_timestamp > '20231001000000'
AND NOT actor_user IS NULL
AND NOT actor_name LIKE '%Bot'
AND NOT actor_name LIKE '%bot'
AND NOT actor_name LIKE 'EnBotEn'
GROUP BY actor_name 
ORDER BY antal DESC
*/

/*
SELECT SUBSTR(rev_timestamp,1,6) AS month, COUNT(*) FROM revision JOIN page ON rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE
*/

/*
SELECT * FROM revision JOIN page ON rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE

actor_name = 'Lsjbot'
AND page_namespace = 0
AND rev_timestamp > '20161110000000'
AND rev_parent_id = 0
*/

/*
GROUP BY month
ORDER BY month
*/
SQL

Checking query status...
