WITH RECURSIVE super_actor AS(
SELECT rc_actor
FROM recentchanges
... |
4 years ago |
WITH RECURSIVE super_actor AS(
SELECT rc_actor
FROM recentchanges
... |
4 years ago |
WITH super_actor AS(
SELECT rc_actor
FROM recentchanges
WHERE rc_bot =... |
4 years ago |
WITH super_actor AS(
SELECT rc_actor
FROM recentchanges
WHERE rc_bot =... |
4 years ago |
WITH super_actor AS(
SELECT rc_actor
FROM recentchanges
WHERE rc_bot =... |
4 years ago |
WITH super_actor AS(
SELECT rc_actor
FROM recentchanges
WHERE rc_bot =... |
4 years ago |
WITH super_actor AS(
SELECT rc_actor
FROM recentchanges
WHERE rc_bot =... |
4 years ago |
SELECT
WEEK(rev_timestamp) AS week,
COUNT(DISTINCT rev_actor) AS wau
FROM... |
4 years ago |