Untitled query #58544

SQL

SELECT rc_timestamp, SUBSTR(rc_timestamp,11,2) AS minut, rc_title, actor_name FROM recentchanges INNER JOIN actor ON rc_actor=actor_id WHERE 
rc_timestamp > '20230117180000'
AND rc_timestamp < '20230117190000'
AND rc_type < 5
ORDER BY rc_timestamp

/*
SELECT DISTINCT rc_title FROM recentchanges INNER JOIN page ON rc_title=page_title WHERE
rc_timestamp > '20221226000000'
AND rc_namespace = 0
AND rc_type < 2
ORDER BY rc_timestamp DESC
LIMIT 1000
*/

/*
SELECT MID(log_timestamp,1,6) AS blockeringsmanad, COUNT(*) FROM logging WHERE
log_type = 'block' AND
log_timestamp > '2018010100000' AND log_timestamp < '20221201000000'
GROUP BY blockeringsmanad
ORDER BY blockeringsmanad
*/

/*
SELECT * FROM user LEFT JOIN ipblocks ON user_id=ipb_user WHERE
ipb_user IS NULL AND
user_registration > '20221001000000' AND user_registration < '20221201000000' AND
user_editcount >= 5
*/
/*
GROUP BY registreringsmanad
ORDER BY registreringsmanad
*/

/*
SELECT MID(user_registration,1,6) AS registreringsmanad, COUNT(*) AS antal FROM user LEFT JOIN ipblocks ON user_id=ipb_user WHERE
ipb_user IS NULL AND
user_registration > '20170101000000' AND user_registration < '20221201000000' AND
user_editcount >= 5
GROUP BY registreringsmanad
ORDER BY registreringsmanad
*/

/*
SELECT actor_name, COUNT(*) AS antal FROM revision INNER JOIN page ON rev_page=page_id INNER JOIN actor ON rev_actor=actor_id WHERE 
page_title LIKE 'Opinionsundersökningar_inför_riksdagsvalet_i_Sverige_2022' AND
page_namespace = 0
GROUP BY actor_name
ORDER BY antal DESC
*/

/*
SELECT  page_title, MAX(rc_timestamp) AS senast, COUNT(*) AS antal FROM recentchanges INNER JOIN page ON rc_title=page_title INNER JOIN categorylinks ON page_id=cl_from WHERE
rc_timestamp > '20221101000000' AND
rc_type < 5 AND
(cl_to = 'Kvinnor' OR cl_to = 'Män')
GROUP BY page_title
*/
SQL

Checking query status...
