Untitled query #17569

SQL

USE svwiki_p;

SELECT rc_user_text AS Användare, COUNT(rc_id) AS Redigeringar, MAX(rc_timestamp) AS Senaste FROM recentchanges
WHERE rc_bot=0
GROUP BY rc_user_text
ORDER BY Redigeringar DESC
LIMIT 100;

/*
SELECT MID(rc_timestamp,1,10) AS timme, COUNT(DISTINCT rc_user_text)
FROM recentchanges
WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170505120000' AND rc_timestamp < '20170508060000' 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 > '20170505120000' AND rc_timestamp < '20170508060000' AND rc_bot LIKE '0' AND (rc_type LIKE '0' OR rc_type LIKE '1')
GROUP BY timme
ORDER BY timme 
LIMIT 1000

/*
USE svwiki_p;
SELECT MID(rc_timestamp,1,8) AS dygn, COUNT(DISTINCT rc_user_text)
FROM recentchanges
WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170422000000' AND rc_timestamp < '2017050600000' AND rc_bot LIKE '0' AND (rc_type LIKE '0' OR rc_type LIKE '1')
GROUP BY dygn
ORDER BY dygn 
LIMIT 1000;

USE trwiki_p;
SELECT MID(rc_timestamp,1,8) AS dygn, COUNT(DISTINCT rc_user_text)
FROM recentchanges
WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170422000000' AND rc_timestamp < '20170506000000' AND rc_bot LIKE '0' AND (rc_type LIKE '0' OR rc_type LIKE '1')
GROUP BY dygn
ORDER BY dygn 
LIMIT 1000
*/
SQL

Checking query status...
