Untitled query #17569

SQL

USE svwiki_p;

SELECT * FROM revision WHERE 
rev_timestamp > '20210301000000'
LIMIT 100

/*
SELECT CURRENT_TIMESTAMP;

SELECT page_namespace AS Namnrymd, COUNT(*) AS Antal_sidor, FLOOR(SUM(1-page_is_redirect)) AS Varav_ej_omdirigeringar, FLOOR(SUM(page_is_redirect)) AS Varav_omdirigeringar FROM page
GROUP BY page_namespace;

SELECT CURRENT_TIMESTAMP;
*/

/*
SELECT CONCAT('[[',page_title,']]') AS artikel, page_len AS sidlängd FROM page 
WHERE page_is_redirect = 1
AND page_namespace = 0
AND page_len>500
ORDER BY page_len DESC
*/

/*
SELECT rc_timestamp, rc_title, actor_name FROM recentchanges INNER JOIN actor on rc_actor = actor_id
WHERE actor_user IS NULL 
AND rc_type < 5
*

/*
SELECT log_title, log_timestamp FROM logging WHERE log_action = 'delete' AND log_title LIKE '%(ö_i%'
*/

/*
SELECT CONCAT('[[',log_title,']]') AS artikel, log_timestamp AS raderingstid, actor_name AS raderad_av FROM logging INNER JOIN actor ON log_actor=actor_id WHERE
log_action = 'delete'
AND log_title LIKE '%(ö_i%'
AND NOT actor_name LIKE 'Lsj%'
ORDER BY log_timestamp DESC
*/

/*
SELECT * FROM recentchanges WHERE
rc_timestamp > '20210204060000'
ORDER BY rc_timestamp DESC
LIMIT 1000
*/

/*
SELECT SUBSTRING('JanFebMarAprMajJunJulAugSepOktNovDec',SUBSTRING(log_timestamp,5,2)*3-2,3) AS månad, COUNT(*)/16 AS antal_blockeringar FROM logging WHERE
log_type = 'block'
AND log_timestamp > '20050101000000'
AND log_timestamp < '20220101000000'
GROUP BY månad
ORDER BY SUBSTRING(log_timestamp,5,2)
*/

/*
SELECT log_type, SUBSTRING(log_timestamp,1,8) AS dag, COUNT(*) AS antal FROM logging INNER JOIN actor on log_actor=actor_id WHERE
log_timestamp >= '20210104000000' AND log_timestamp < '20210303000000'
AND (log_type = 'create' OR log_type = 'delete')
AND log_namespace = 0
GROUP BY log_type, dag
ORDER BY dag
*/

/*
SELECT * FROM logging WHERE
log_timestamp >= '20210104000000' AND log_timestamp < '20210307000000'
AND log_type = 'delete'
AND log_namespace = 0
*/
SQL

Checking query status...
