Anonymous mobile editing in Italian Wikipedia

SQL

SET @START = "20131101";
SET @END = "20150224";
 
SELECT
    DATE,
    IFNULL(mobile_edits.count, 0) AS mobile_edits,
    IFNULL(anon_edits.count, 0) AS anon_edits,
    IFNULL(mobile_anon_edits.count, 0) AS mobile_anon_edits,
    IFNULL(mobile_registrations.registrations, 0) AS mobile_registrations
FROM (
    SELECT
        LEFT(rev_timestamp, 8) AS DATE,
        COUNT(*) AS COUNT
    FROM revision
    INNER JOIN tag_summary ON
        ts_rev_id = rev_id AND
        ts_tags LIKE "%mobile edit%" AND
        ts_tags NOT LIKE "%mobile app edit%"
    WHERE
        rev_timestamp BETWEEN @START AND @END
    GROUP BY DATE
) AS mobile_edits
LEFT JOIN (
    SELECT
        LEFT(rev_timestamp, 8) AS DATE,
        COUNT(*) AS COUNT
    FROM revision
    INNER JOIN tag_summary ON
        ts_rev_id = rev_id AND
        ts_tags LIKE "%mobile edit%" AND
        ts_tags NOT LIKE "%mobile app edit%"
    WHERE
        rev_timestamp BETWEEN @START AND @END AND
        rev_user = 0
    GROUP BY DATE
) AS mobile_anon_edits USING (DATE)
LEFT JOIN (
    SELECT
        LEFT(rev_timestamp, 8) AS DATE,
        COUNT(*) AS COUNT
    FROM revision
    WHERE
        rev_timestamp BETWEEN @START AND @END AND
        rev_user = 0
    GROUP BY DATE
) AS anon_edits USING (DATE)
LEFT JOIN (
    SELECT
        LEFT(TIMESTAMP, 8) AS DATE,
        COUNT(*) AS registrations
    FROM log.ServerSideAccountCreation_5487345
    WHERE
        wiki = "itwiki" AND
        event_isSelfMade = 1 AND
        event_displayMobile = 1 AND
        TIMESTAMP BETWEEN @START AND @END
    GROUP BY DATE
) AS mobile_registrations USING (DATE)
SQL

Checking query status...
