Untitled query #17569

SQL

USE svwiki_p;


SELECT * FROM recentchanges WHERE 
rc_type<5
AND rc_comment LIKE '%{{k[0-6]%'
LIMIT 1000
/*
SELECT rev_user_text, rev_timestamp FROM revision WHERE
rev_comment LIKE '%WP:HG%'
*
/*
SELECT log_action,log_title, log_user, user_name, log_timestamp, log_params FROM logging INNER JOIN user ON log_user=user_id WHERE
#log_action = 'block'
log_timestamp > '20160701000000'
#AND log_timestamp < '20180201000000'
#AND log_title = '213.204.35.226'
AND log_params LIKE '%06-15%'
#AND log_title LIKE '%:%'
#AND LENGTH(log_title)>30
#AND SUBSTR(log_title,5,1)=':'
#log_timestamp > '20180518000000'
ORDER BY log_timestamp DESC
#GROUP BY log_title
#ORDER BY log_title
*/
SQL

Checking query status...
