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