Untitled query #17569

SQL

USE svwiki_p;


SELECT * FROM revision WHERE
rev_timestamp >= NOW()
/*
SELECT rc_timestamp, rc_title, comment_text FROM recentchanges INNER JOIN comment ON rc_comment_id=comment_id WHERE
rc_actor = 356
AND comment_text LIKE '% tas bort %'
*/

/*
SELECT * FROM ipblocks INNER JOIN actor ON ipb_address = actor_name
WHERE ipb_timestamp > '20200420000000'
*/

/*
SELECT * FROM logging
WHERE log_timestamp>'20190101000000'
AND log_type='create'
AND log_namespace=0
*/

/*
SELECT rc_timestamp, rc_actor, rc_namespace, rc_title, rc_new, rc_ip, rc_old_len, rc_new_len FROM recentchanges WHERE
rc_type < 4
AND rc_source = 'mw.edit'
*/

/*
SELECT page_title AS Artikel FROM page LEFT JOIN categorylinks ON page_id=cl_from WHERE
cl_from IS NULL AND page_namespace = 0 AND page_is_redirect = 0
*/
SQL

Checking query status...
