| WITH admins (a_timestamp, a_name, a_actor) AS
(
SELECT log_timestamp,... |
3 months ago |
| WITH admins (a_timestamp, a_name, a_actor) AS
(
SELECT log_timestamp,... |
3 months ago |
| SELECT user_name,
COUNT(*) AS edits_live,
0 AS... |
3 months ago |
| SELECT user_name,
COUNT(*) AS edits_live,
0 AS... |
3 months ago |
| SELECT user_name,
COUNT(*) AS edits_live,
0 AS... |
3 months ago |
| SELECT user_name,
SUM(CASE WHEN rev_timestamp < a_timestamp THEN... |
3 months ago |
| SELECT a_timestamp,
a_name,
SUM(CASE WHEN rev_timestamp... |
3 months ago |
| WITH admins (a_timestamp, a_name, a_actor) AS
(
SELECT log_timestamp,... |
3 months ago |
