SELECT rc_title, count(*) as num_edits
FROM recentchanges
WHERE... |
3 months ago |
-- -- |
3 months ago |
-- -- |
3 months ago |
SELECT
actor_name as user,
count(*) as patrol_cnt
FROM logging
JOIN... |
3 months ago |
SELECT
actor_name as user,
count(*) as patrol_cnt
FROM logging
JOIN... |
1 year ago |
SELECT
actor_name as user,
count(*) as patrol_cnt
FROM logging
JOIN... |
1 year ago |
SELECT
actor_name as user,
count(*) as patrol_cnt
FROM logging
JOIN... |
1 year ago |
SELECT
actor_name as user,
count(*) as patrol_cnt
FROM logging
JOIN... |
1 year ago |
SELECT
actor_name as user,
count(*) as patrol_cnt
FROM logging
JOIN... |
1 year ago |
select *
from user_groups
where ug_group in
('sysop', 'patroller',... |
1 year ago |
select *
from user_groups
where ug_group in ('sysop', 'patroller')
limit 80; |
1 year ago |
select * from user_groups limit 80; |
1 year ago |
select * from user_groups limit 3; |
1 year ago |
-- -- |
1 year ago |
SELECT
-- log_namespace AS ns,
log_title AS title,
COUNT(log_id) AS... |
2 years ago |
SELECT
-- log_namespace AS ns,
log_title AS title,
COUNT(log_id) AS... |
2 years ago |
SELECT
log_namespace AS ns,
log_title AS title,
COUNT(log_id) AS... |
2 years ago |
SELECT
log_namespace AS ns
log_title AS title,
COUNT(log_id) AS... |
2 years ago |
SELECT
log_title AS title,
COUNT(log_id) AS deletions
FROM logging
WHERE... |
2 years ago |
SELECT
log_title AS title
COUNT(log_id) AS deletions
FROM logging
WHERE... |
2 years ago |
SELECT CONCAT('*[[',log_title,']]') AS title, COUNT(log_id) AS deletions,... |
2 years ago |
SELECT CONCAT('*[[',log_title,']]') AS title, COUNT(log_id) AS deletions,... |
2 years ago |