Untitled query #17569

SQL

USE svwiki_p;
SELECT MID(rc_timestamp,1,10) AS timme, COUNT(DISTINCT rc_user_text)
FROM recentchanges
WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170419190000' AND rc_timestamp < '20170429190000' AND rc_bot LIKE '0' AND (rc_type LIKE '0' OR rc_type LIKE '1')
GROUP BY timme
ORDER BY timme 
LIMIT 1000;

USE trwiki_p;
SELECT MID(rc_timestamp,1,10) AS timme, COUNT(DISTINCT rc_user_text)
FROM recentchanges
WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170419190000' AND rc_timestamp < '20170429190000' AND rc_bot LIKE '0' AND (rc_type LIKE '0' OR rc_type LIKE '1')
GROUP BY timme
ORDER BY timme 
LIMIT 1000
#SELECT COUNT(*), (HOUR(rc_timestamp) AS timme)
#FROM recentchanges
#WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170428170000'
#ORDER BY timme
#GROUP BY timme 
#LIMIT 100
SQL

Checking query status...
