SELECT rc_timestamp, rc_actor, rc_id, rc_comment
FROM recentchanges
WHERE... |
6 months ago |
SELECT rc_actor, COUNT(rc_id) as ct
FROM recentchanges
WHERE rc_timestamp >=... |
6 months ago |
SELECT rc_actor, rc_bot, COUNT(rc_id) as ct
FROM recentchanges
WHERE... |
6 months ago |
SELECT rc_actor, rc_bot, COUNT(rc_id) as ct
FROM recentchanges
WHERE... |
6 months ago |
SELECT rc_actor, rc_bot, COUNT(rc_id) as ct
FROM recentchanges
WHERE... |
6 months ago |
USE wikidatawiki_p;
SELECT rc_user_text, rc_bot, COUNT(rc_id) as ct
FROM... |
6 months ago |