Untitled query #58544

SQL

SELECT * FROM page INNER JOIN revision ON page_id=rev_page INNER JOIN actors ON rev_actor=actor_id WHERE
page_namespace = 0 AND
page_is_redirect = 0 AND
rev_parent_id = 0 AND
actor_name = 'Lsjbot'
LIMIT 100

/*
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...
