SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
WITH rel_users(us, gen, yr) AS (
SELECT DISTINCT actor_user, up_property,... |
1 year ago |
WITH rel_users(us, gen, yr) AS (
SELECT DISTINCT actor_user, up_property,... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(revision.rev_timestamp, '%Y_%m') AS revision_month,
... |
1 year ago |
SELECT
DATE_FORMAT(user_registration, '%Y-%m') AS registration_month,
... |
1 year ago |
SELECT
DATE_FORMAT(user_registration, '%Y-%m') AS registration_month,
... |
1 year ago |
SELECT
DATE_FORMAT(user_registration, '%Y-%m') AS registration_month,
... |
1 year ago |
SELECT
DATE_FORMAT(user_registration, '%Y-%m') AS registration_month,
... |
1 year ago |
SELECT
DATE_FORMAT(user_registration, '%Y-%m') AS registration_month,
... |
1 year ago |
SELECT
DATE_FORMAT(user_registration, '%Y-%m') AS registration_month,
... |
1 year ago |
SELECT
DATE_FORMAT(user_registration, '%Y-%m') AS registration_month,
... |
1 year ago |
SELECT
DATE_FORMAT(user_registration, '%Y-%m') AS registration_month,
... |
1 year ago |
SELECT
DATE_TRUNC('month', user_registration) AS registration_month,
... |
1 year ago |
WITH rel_users(us, usp, uspv, yr) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(us, usp, uspv, yr) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(us, usp, uspv, yr) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(us, usp, uspv, yr) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(us, usp, uspv, yr) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(us, gen, yr) AS (
SELECT DISTINCT actor_user, up_property,... |
1 year ago |
WITH rel_users(user, gender, year_month) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(user, gender, year_month) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(user, gender, year_month) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(user, gender, year_month) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(user, gender, year_month) AS (
SELECT DISTINCT actor_user,... |
1 year ago |
WITH rel_users(users) AS (
SELECT DISTINCT actor_user, up_property,... |
1 year ago |
WITH rel_users(users) AS (
SELECT DISTINCT actor_user, up_property,... |
1 year ago |
WITH active_users(users) AS (
SELECT DISTINCT actor_user, rev_timestamp
... |
1 year ago |
WITH active_users(users) AS (
SELECT DISTINCT actor_user
FROM... |
1 year ago |
WITH active_users(users) AS (
SELECT actor_user
FROM... |
1 year ago |
WITH active_users(users) AS (
SELECT actor_user
FROM... |
1 year ago |
WITH active_users(users) AS
SELECT actor_user
FROM
... |
1 year ago |
WITH active_users(users) AS
SELECT actor_user
FROM
... |
1 year ago |
WITH active_users(users) AS
SELECT actor_user
FROM
... |
1 year ago |
WITH active_users(users) AS
SELECT actor_user
FROM
... |
1 year ago |
WITH active_users(users) AS
SELECT actor_user
FROM
... |
1 year ago |
WITH active_users(users) AS
SELECT actor_user
FROM
... |
1 year ago |
SELECT actor_user
FROM
revision_userindex AS revision
... |
1 year ago |
SELECT COUNT(up_user), up_value
WHERE up_property = "gender"
FROM... |
1 year ago |
SELECT COUNT(up_user), up_value
WHERE up_property = "gender"
FROM... |
1 year ago |
SELECT COUNT(up_user), up_value
WHERE up_property = "gender"
FROM... |
1 year ago |
SELECT COUNT(up_user), up_value
WHERE up_property = "gender"
FROM... |
1 year ago |
SELECT COUNT(up_user), up_value
WHERE up_property =... |
1 year ago |
SELECT
COUNT(DISTINCT rev_actor)
FROM
(
SELECT COUNT(up_user),... |
1 year ago |
SELECT
COUNT(DISTINCT rev_actor)
FROM
(
SELECT COUNT(up_user),... |
1 year ago |
SELECT
COUNT(DISTINCT rev_actor)
FROM
(
SELECT COUNT(up_user),... |
1 year ago |
SELECT
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
rev_actor
... |
1 year ago |
SELECT
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
rev_actor
... |
1 year ago |
SELECT
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
rev_actor
... |
1 year ago |
SELECT
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
rev_actor
... |
1 year ago |
SELECT
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
rev_actor
... |
1 year ago |
SELECT
year,
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
... |
1 year ago |
SELECT
year,
COUNT(DISTINCT rev_actor)
FROM
(
SELECT
... |
1 year ago |