Untitled query #17569

SQL

USE svwiki_p;

SELECT * FROM page WHERE page_namespace = 14
AND (page_title LIKE '%_Burma' OR page_title LIKE '%_Burma_%')
AND page_is_redirect = 1


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